Greetings
I have 10 different workbooks having data entered weekly. All the data is entered in Sheet2 in all the same columns. I need to roll these into one (Master) to provide reporting weekly. One column is "Completion Date" and if that column has a date in it, the record can remain in the Master and be deleted from the feeding sheet. The record needs to remain in the feeding sheet until there is a Completion Date. I need to report on both "Completed" and "Not Completed."
What is the best way to append the next data weekly into a master worksheet and insure I have no duplication. A record may go through several weeks without being completed and I do not want a different row in the Master for each week it is "not completed".
Thanks
I have 10 different workbooks having data entered weekly. All the data is entered in Sheet2 in all the same columns. I need to roll these into one (Master) to provide reporting weekly. One column is "Completion Date" and if that column has a date in it, the record can remain in the Master and be deleted from the feeding sheet. The record needs to remain in the feeding sheet until there is a Completion Date. I need to report on both "Completed" and "Not Completed."
What is the best way to append the next data weekly into a master worksheet and insure I have no duplication. A record may go through several weeks without being completed and I do not want a different row in the Master for each week it is "not completed".
Thanks