protegeone
10-17-2005, 12:43 AM
Hi,
Greetings from a newbie.
Now as I've said, I'm a real newbie and not just here, but VBA wise as well.
I'm trying to sort of collect data from several workbooks into a single workbook ( source would be roughly 200workbooks ).
Both source and destination workbooks have only a single sheet in.
What I'm trying to accomplish is to have all workbooks open in the given folder and then copy value to destination workbook.
Source: A8 cell has a name and F31 has its value ( this is always static ).
Somehow the name in A8 should be matched to the name in destination workbook ( all names are in column B ) and then the value from F31 copied to cell in the same row in column F.
I've enclosed an example, where
csomor gabriella.xls is the source
zaras.xls is the destination
Taking the example,
Source A8 = Csomor Gabriella
F31 = 0 Ft should be copied to F39 in destination
I've googled my head off, but couldn't find solution.
Hopefully someone here would be kind enough to help.
Protege
Greetings from a newbie.
Now as I've said, I'm a real newbie and not just here, but VBA wise as well.
I'm trying to sort of collect data from several workbooks into a single workbook ( source would be roughly 200workbooks ).
Both source and destination workbooks have only a single sheet in.
What I'm trying to accomplish is to have all workbooks open in the given folder and then copy value to destination workbook.
Source: A8 cell has a name and F31 has its value ( this is always static ).
Somehow the name in A8 should be matched to the name in destination workbook ( all names are in column B ) and then the value from F31 copied to cell in the same row in column F.
I've enclosed an example, where
csomor gabriella.xls is the source
zaras.xls is the destination
Taking the example,
Source A8 = Csomor Gabriella
F31 = 0 Ft should be copied to F39 in destination
I've googled my head off, but couldn't find solution.
Hopefully someone here would be kind enough to help.
Protege