redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,604
- Office Version
- 365
- Platform
- Windows
Hi all
Can someone please show how I can look down column A of Sheet1 for the last time a specific date is shown - this date found from cell A1 of Sheet2
When this date is found insert a row after
so for example A1 Sheet2 = 06SEP
Sheet 1 shows before code added
06SEP
06SEP
06SEP
07SEP
07SEP
07SEP
after code added and run
06SEP
06SEP
06SEP
07SEP
07SEP
07SEP
thanks in advance
Can someone please show how I can look down column A of Sheet1 for the last time a specific date is shown - this date found from cell A1 of Sheet2
When this date is found insert a row after
so for example A1 Sheet2 = 06SEP
Sheet 1 shows before code added
06SEP
06SEP
06SEP
07SEP
07SEP
07SEP
after code added and run
06SEP
06SEP
06SEP
07SEP
07SEP
07SEP
thanks in advance