Hi all,
I am new to the forum and have done basic looping and achieved success, however, my current project has me stumped. I have two workbooks, one lists the Project Manager, Customer name, Customer number and Totals for that specific customer. the other workbook is a total summary of all the Project managers, their customers, customer numbers and totals.
I am trying to open the first workbook, remember the data, activate the second workbook, find the matching PM, Customer number and Customer name, if those three criteria are met...paste the customer total into the correct column. if the customer doesn't exist I have it adding it to the last row, then sorting them all by PM at the end.
My problem is that I can have multiple PM's that could have the same customer, as their jobs do cross over sometimes.
I'm trying to open WORKBOOK 1, "remember" the PM, customer number and customer name in the first row,activate WORKBOOK 2, find the information, if they all match, paste, THEN return to WORKBOOK 1, move to the second row of that worksheet, remember the data, activate WORKBOOK 2, again, match the criteria, and paste or add to bottom etc. ..that's not working...grrr.
WORKBOOK 1
<tbody>
</tbody>
WORKBOOK 2
<tbody>
</tbody>
I am new to the forum and have done basic looping and achieved success, however, my current project has me stumped. I have two workbooks, one lists the Project Manager, Customer name, Customer number and Totals for that specific customer. the other workbook is a total summary of all the Project managers, their customers, customer numbers and totals.
I am trying to open the first workbook, remember the data, activate the second workbook, find the matching PM, Customer number and Customer name, if those three criteria are met...paste the customer total into the correct column. if the customer doesn't exist I have it adding it to the last row, then sorting them all by PM at the end.
My problem is that I can have multiple PM's that could have the same customer, as their jobs do cross over sometimes.
I'm trying to open WORKBOOK 1, "remember" the PM, customer number and customer name in the first row,activate WORKBOOK 2, find the information, if they all match, paste, THEN return to WORKBOOK 1, move to the second row of that worksheet, remember the data, activate WORKBOOK 2, again, match the criteria, and paste or add to bottom etc. ..that's not working...grrr.
WORKBOOK 1
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>
WORKBOOK 2
|
<tbody>
</tbody>