Data Transfer between workbooks based on cell

Data_Analyst

New Member
Joined
Jun 21, 2011
Messages
12
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.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Data_Analyst

New Member
Joined
Jun 21, 2011
Messages
12
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,005
Messages
5,526,233
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top