Excel Dilema
Hello,
I am at wits end and I hope you can help me with this problem i am facing.
I have multiple spreadsheets with different names in which i need to gather fixed cell information from each one and Transpose the information to a master spreadsheet.
They all have the same layout and data within these spreadsheets are within the same fields as other spreadsheets.
The Cell with data that are required from the multiple spreadsheets are;
* The Address Name in Cell 'C2'
* The Address Number in Cell 'C3'
* Scores - Cell Range = V10 to V12, V15 to V23, V27 to V30, V34 to V37, V41 TO V44, V47 TO V49 & V52 TO V56. (Scores range from 0 to 10,000)
Currently I have been copying this data from the 200 (multiple) spreadsheets and pasting (Transpose) this info to a master spreadsheet,
so i would then have the respective 200 row of information.
I have tried to look up similar questions online, but they offer no relation to what i need to do. So therefore I hope someone here can be of some assistance which would be very grateful.
Kind Regards
Sanj
|
Linear Mode
