Hi,
I currently have a Macro that pulls the data from work books in a file.
The only issue is that it runs very slowly. See Excerpt below there is a lot more data it copies.
The reason for the Else if, is because the data in the file could shift down depending on the inputs. So if there is text in cell that determines what data needs to be picked up.
I've also reduced the number of inputs here. There is 4 Else if statements and also about 170 cells I am picking the info from and pasting into a summary sheet.
Any help would be greatly appreciated.
Thanks and regards
Christian
Bookmarks