Extract data from other spreadsheets in the same document

Closed
luigi206 Posts 2 Registration date Wednesday May 1, 2013 Status Member Last seen May 2, 2013 - May 1, 2013 at 12:47 PM
luigi206 Posts 2 Registration date Wednesday May 1, 2013 Status Member Last seen May 2, 2013 - May 2, 2013 at 06:27 PM
Hello,

I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet. I also want to match the name of the spreadsheet with the name in the summary sheet. I am starting using macros so I cannot figure it out.

I really appreciate your help

2 responses

sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
May 2, 2013 at 03:17 AM
Hi

Is it possible to upload a sample file

Thanks

Patnaik
0
luigi206 Posts 2 Registration date Wednesday May 1, 2013 Status Member Last seen May 2, 2013
May 2, 2013 at 06:27 PM
I want to perform the following operation:

=IF('Veh304'!$C$51=0,"No action required",IF('Veh304'!$C$52=1,"Convert to CNG","Replace with CNG"))


in 'Veh304' , 304 is the number that I want to use as a variable. The macro that I am trying to do is change the number 304 that is a number that I have in the master sheet and replace it with the other numbers that are located in the same column. Also 'Veh304' is the name of the sheet where the data that I am trying to analyze is located.

Thanks
0