Hello, Everyone!
I have searched through the forums but haven't been able to find a solution to the specific need that I have so I'm hoping someone can point me in the right direction.
I have a sheet in a master workbook that contains a Project Name in column A, Account Status in Column B, Country in Column C, PM name in Column D and then revenue amounts broken out by month in the subsequent columns. It is constantly being updated with new Project Names that are inserted alphabetically by PM.
I also have a report that I painstakingly pull the data into manually that is a subset of the data from the master. It contains the Project Name in Column A, the PM name in Column B, a Loss/Gain formula in Column C and the revenue amounts broken out by month in the subsequent columns.
What I need is a tool that will look through the Master sheet and compare it to the report. It will copy all matching data to a new sheet. It will also copy the new data from the master to this new sheet. Somewhere in this operation, I need the current month added to this new sheet with the current revenue amount included. For example, the May report had all of the projects with January through May revenues with the Loss/Gain formula calculation. The June report should have all of the projects and revenues for January through May, add the new projects and add a column for June with the June revenues for the old projects as well as the June revenue for the new projects.
I apologize for being so wordy but I want to be as clear as possible. I have searched the forums and found several examples of code that will look at two worksheets and extract matching data but I haven't found anything that will find new data and insert the row in the appropriate place. This thread is close to what I need but not exactly, if this helps at all:
http://www.mrexcel.com/forum/showthread.php?t=553805&highlight=copy+rows
Thank you for taking the time to read my post!
I have searched through the forums but haven't been able to find a solution to the specific need that I have so I'm hoping someone can point me in the right direction.
I have a sheet in a master workbook that contains a Project Name in column A, Account Status in Column B, Country in Column C, PM name in Column D and then revenue amounts broken out by month in the subsequent columns. It is constantly being updated with new Project Names that are inserted alphabetically by PM.
I also have a report that I painstakingly pull the data into manually that is a subset of the data from the master. It contains the Project Name in Column A, the PM name in Column B, a Loss/Gain formula in Column C and the revenue amounts broken out by month in the subsequent columns.
What I need is a tool that will look through the Master sheet and compare it to the report. It will copy all matching data to a new sheet. It will also copy the new data from the master to this new sheet. Somewhere in this operation, I need the current month added to this new sheet with the current revenue amount included. For example, the May report had all of the projects with January through May revenues with the Loss/Gain formula calculation. The June report should have all of the projects and revenues for January through May, add the new projects and add a column for June with the June revenues for the old projects as well as the June revenue for the new projects.
I apologize for being so wordy but I want to be as clear as possible. I have searched the forums and found several examples of code that will look at two worksheets and extract matching data but I haven't found anything that will find new data and insert the row in the appropriate place. This thread is close to what I need but not exactly, if this helps at all:
http://www.mrexcel.com/forum/showthread.php?t=553805&highlight=copy+rows
Thank you for taking the time to read my post!
