Copying Cells from One Workbook to Another Based on Specific Criteria

[mdschuetz]

Hi,

I'm new to VBA. I'm intermediate in Excel. Here is what I hope to accomplish.

I have two Workbooks.

Tracker and Balances.

Tracker captures 4 relevant columns all within one worksheet.

1. Control Number ( a unique number to each row )
2. Date ( the date the information was captured )
3. Amount ( the total cost of a transaction )
4. Purchase Order Number ( a number associated with a specific worksheet in Balances)

Balances contains multiple worksheets each named after a Purchase Order Number.

Now, the goal is in Tracker, in any given row, if the data in the column Purchase Order Number is the same as the name of a worksheet in the workbook Balances that the data from that row contained in columns Control Number, Date, and Amount be copied to the next available row in its corresponding worksheet on Balances.

I am not sure if this is even possible, but if it is, this is probally the best place to ask.

So, if anyone knows anything that can help me, I would greatly appreciate it.

Thanks,

Marty