Hello all,
Here is the situation.
I have a report that has four columns A, B, C, & D. On a different workbook named job entry. I have a button which lets a person input information on the sheets related to columns a, b, c, & d. I.E.
As of right now the macro populates both sheets by adding new rows to each. My problem is that person might want to update an entry by changing either B, C, or D so ie #127 5 FP YES. Now I want the macro to find entry #127 & 5 and update the columns C and D on both workbooks.
(For your information) Both workbooks are identical except the first is a masterworkbook and the second is a monthly report that i coded the master to create a new report each month. Let me know if you need more information to help you.
Here is the situation.
I have a report that has four columns A, B, C, & D. On a different workbook named job entry. I have a button which lets a person input information on the sheets related to columns a, b, c, & d. I.E.
Code:
A B C D
#127 5 RED NO
#128 6 FP NO
#129 2 RED Yes
As of right now the macro populates both sheets by adding new rows to each. My problem is that person might want to update an entry by changing either B, C, or D so ie #127 5 FP YES. Now I want the macro to find entry #127 & 5 and update the columns C and D on both workbooks.
(For your information) Both workbooks are identical except the first is a masterworkbook and the second is a monthly report that i coded the master to create a new report each month. Let me know if you need more information to help you.