Hi all,
I have been trying to do something for the past while and am unable to come up with anything that works...
I have about 50 different worksheets in a spreadsheet and want to grab a single value out of all of them and put them into a row on a single worksheet. The worksheets are named "1", "2", "3" etc...and the value that I want to look up is in the same cell for each worksheet (lets just say A1).
I have been briefly messing around with a macro to accomplish the task, but am unable to get the macro to look up a different worksheep each time it pulls the data.
Anybody have any ideas/tips?
Bookmarks