Hi All,
I posted a question yesterday but I realised that my description of the what i'm trying to do wasn't very clear, so here's a new post with 2 workbooks as examples.
I have one workbook named "open projects", which contains the details and current status of all projects that are open or have only recently been completed. There are typically 2 to 4 worksheets in this file containing project records, with different worksheet for each 2-month period such as "Mar & Apr" or "May & Jun". Other than these, I have 2 other worksheets in the same workbook containing charts and other information.
I am looking for a macro solution which can be run from this "open projects" workbook to do the following:
1. Open the "All Projects" workbook (or i can manually open this file before running the macro)
2. Go through each record in the currently active sheet (example "Mar & Apr") and attempt to find a matching record in "All Projects"'s "data" sheet by comparing the project no. which is the unique 4 digit number in column A of each record.
3. If a match for the project is found, the entire record for that project would be copied over with the current record from the "Open Project" workbook. If not, it would be added to the work sheet as a new record in the next blank row.
4. I can then go to the next worksheet (say "May & Jun") and run the macro again to update the changes / addition in that particular sheet. After this, the "data" sheet in "All Projects" would contain the most updated information on all new and existing projects.
One thing to note is that the macro should only transfer data from a fixed range (such as column A to AB) and not the entire row as additional information may be added to those parts of the "data" sheet.
The actual records that i work with run into the thousands so a macro solution would be really very helpful. Hope someone has a solution...
In any case, thank you so much for taking the time to read my post.
Have a nice day!
Bookmarks