Hi all, here is my problem and desired goal. It shouldn't be so hard but I'm not too smart with excel.
Spreadsheet A: I have a ton of raw data, so for example, Name, Number, X, Y, Z.
Spreadsheet B: I want to pull the data from spreadsheet A, into this one, ALL AT ONCE.
I know how to do it one at a time, I just click "='Spreadsheet A'$A$1"
I want to know, how to do all at once, so I can create just one row of values, and then 'drag it down' to pull data from the entire spreadsheet A and populate B.
Please let me know if this makes sense and if you have any ideas for me!
Thanks,
Mike
Bookmarks