Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique copy
Hello All (I apologize in advance for the wordiness)
I need some direction please. I have a sheet where users fill out 21 cells in a particular row in a worksheet that is dependant to their dept. There are 12 department worksheets and one master in the workbook. I would like to periodicaly update the master with the inputs that were done since the last update. Each sheet will have, among many criteria, a department and a project number. The project number will never repeat by dept, but may repeat on a different worksheet. (I would concantenate the dept name and project number to create a unique ID). I guess on each update, I would need to check the master then each worksheet and copy and paste what was not present on the master. The only way I know to check is row by row, I know there is a faster way out there, please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Sort Unique | Excel Discussion (Misc queries) | |||
Copy Unique Entries | Excel Worksheet Functions | |||
copy unique data | Excel Worksheet Functions | |||
copy only unique values | Excel Worksheet Functions | |||
Copy unique data to a different WS | Excel Discussion (Misc queries) |