Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

Thanks so much...!..

Brian,
This will just copy the data value ...right?...and not any formulas that may be in those cells ?
Thanks, fordraiders.

Yes, just the values.

Regards,
Brian.