Fordraiders
asked on
get specific cell values from several workbooks and place in new workbook sheet
excel 2010
vba
I need a routine that will:
Look at any workbook in a folder..
Open each workbook:
Get the file name of the workbook.
and look for 3 worksheets.
CompanyData
CorporateData
DSNData
From: CompanyData
Gets cell value from :
D3, D10, F22, R23
From: CorporateData
Gets cell value from :
B4, D11, G21, S12, D34
From: DSNData
Gets cell value from :
B2, W12, G21, S12, F45
Put all this data into its each row with the name of the worksheet first
A B C D E etc...
<filename> D3 D10 F22 R23 etc,....
Thanks
fordraiders
vba
I need a routine that will:
Look at any workbook in a folder..
Open each workbook:
Get the file name of the workbook.
and look for 3 worksheets.
CompanyData
CorporateData
DSNData
From: CompanyData
Gets cell value from :
D3, D10, F22, R23
From: CorporateData
Gets cell value from :
B4, D11, G21, S12, D34
From: DSNData
Gets cell value from :
B2, W12, G21, S12, F45
Put all this data into its each row with the name of the worksheet first
A B C D E etc...
<filename> D3 D10 F22 R23 etc,....
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, fordraiders.
Yes, just the values.
Regards,
Brian.
Yes, just the values.
Regards,
Brian.
ASKER
Brian,
This will just copy the data value ...right?...and not any formulas that may be in those cells ?