The tab LS Raw Data Close has 7 examples labeled in Column A
Can someone please help me write a basic macro that goes through each example and identifies if there is a date in column I. If there is a date in Column I then copy range B:BY to A61 on the worksheet Results Long Data Close ERN.
If there is no date in Column I then copy the range B:BY to A61 on the worksheet Results Long Data Close.
In my spreadsheet I copied by hand the data into the appropriate cells to show you how the data should copy after the macro runs.
I am not very good at writing macros so any help with this would be great!
Bookmarks