I am looking to write a macro that that affects 2 worksheets, “Worksheet 1” and “Worksheet 2”.
The macro will:
1. In “Worksheet 1” copy cells Range B6:B58.
2. Then identify value (it would be a date) in “Worksheet 1” Cell A3.
3. Then find “Worksheet 1” Cell A3 date in “Worksheet 2” Row 3.
4. Paste Values of “Worksheet 1” Range B6:B58 below the date found in “Worksheet 2” Row 3.
5. Clear values in “Worksheet 1” copy cells Range B6:B58.
End.
Bookmarks