I was wondering if anyone could help me with a macro question. I created a macro for a specific spreadsheet. The macro basically matches up date in the worksheet, however the data in the worksheet will change on a daily basis. Meaning the worksheet has a split screen and the new data is copied in different cells on a daily basis. Is there any way to get the macro to run for a specific area in the worksheet? Any advice would be greatly appreciated.
Bookmarks