AB33 you are a legend.
I deleted the
as I want to continually add to the data spreadsheet with more and more, so I didnt want that to be erased every time i ran the macro .... thanks!!!
I have found a problem....
With your code that identifies the last row of data, i have noticed that in my data at times I may have hundreds of blank rows then randomly there will be a "0" or something. Your code looks for that and therefore copies all those blank rows to the data sheet. How can I overcome this?
Solved with this addition
Bookmarks