Copy data from different worksheet to a master worksheet but no duplicates
- by sam
hi all,
i want to clarify my initial question for a possible solutions from any savior out there. Say i have 3 excel sheets one for each user for data entry located in separate workbooks to avoid excel share workbook problems. I also have a master sheet in another workbook where i want individual data enter on those sheets precisely sheets 1 should copy to the next available row of sheet 1 in the master sheet as the users enter them. i need a vba code that can copy each record without copying a duplicate row in the master sheet but highlight the duplicate row and lookup the initial record in a master sheet and return the name of the Imputer looking up the row say column ( I) where each user sign there initials after every row of entry like below.
All 4 worksheets are formatted as below:
lastname account cardno. type tran amount date location comments initials
JAME 65478923 1975 cash 500 4/10/2010 miles st. this acct is resolve MLK
BEN 52436745 1880 CHECK 400 4/12/2010 CAREY ST Ongoing investigation MLK
JAME 65478923 1975 cash 500 4/10/2010 miles st. this acct is resolve MLK
I need the vba to recognize duplicates only if the account number and the card number matches the initial records. So if the duplicates exist a pop up message should be display that a duplicates exist and return the initial Imputer say MLK in COLUMN( I) to any user inputting in the individual worksheets other than warehouse sheets (master).
So please any idea will be appreciated.
