Data Transfer between workbooks based on cell

[Data_Analyst]

Hello,

I need some VBA help to accomplish the following -

I have 3 files.

workbook 1: has the vba residing in it
workbook 2: has the data
workbook 3: where I would like to put the data (one of each account below)

(workbook 2) data document has a bunch of accounts and corresponding info in column B, for example:

Column A

101010
111111
222222
334234

Column B

1
2
3
4


I would like the program to run through this list, so when it hits 101010,
it opens up the 3rd workbook (workbooks.open) which has that account number for the file name - "101010.xls" enters the information from column B which is associated with that account (for 101010, it would be 1), saves it and closes it, goes down the list in workbook 2 and continues until it reaches the end.

Thank you for your help with this matter. I greatly appreciate it.

 

[wigi]

Cross-posted at Ozgrid:
http://www.ozgrid.com/forum/showthread.php?t=159105

 

[Data_Analyst]

If anyone here has an alternative method than the one posted on the other forum, I would appreciate it.

Thank you all for your efforts!

 

[Data_Analyst]

I modified the code here a bit to work for me...

http://www.ozgrid.com/forum/showthread.php?t=159105

Thanks for all the effort!