Copy Data, Insert Row, Paste Data into inserted row via Macro or other possible means in Excel sheet

[MrBeardley]

For simplicity's sake, I will be using basic titles and information for an excel workbook, i.e. Sheet1, Sheet2.

Background information for the sheets: Columns A will contain parts numbers on both sheets. Sheet2 contains all parts numbers possible for the given assembly. Sheet1 displays the part number based on if it has been revised in the past year. If it has not, the part number will not appear on Sheet1. Sheet1 may display the part number multiple times based on how many revisions have been made. The revisions are identified in Column C with further details on the revision expressed in Column D-G.

I am trying to automate a process of searching Sheet1 for the part numbers listed on Sheet2 and if found, copying all data from Column C to Column G of the matched row on Sheet1, inserting a new row underneath the part number on Sheet2, and inserting the information into Columns C - G on Sheet2. If there are multiple revisions, as expressed in the paragraph above, I would like each revision to be displayed below the part number. This would mean there may be 1 row, there may be 10 rows below a single part number, based on how many revisions performed in a given year. If the part number is not found on Sheet1, I would like simply for the comment "No revisions found" to be displayed underneath that part number, such that there is only one row beneath the part number. I have some knowledge of writing macro codes for excel documents, but fairly limited. Is there anyone who could design a macro to perform these needs, or tell me the proper code commands for the IF statements or whatever else may be necessary? I would greatly appreciate it.

 

[noidea_77]

Load all the data into a database of your choice (MS Access , MySQL, ..) and create your report as a select statement. You can do that out of Excel by defining a data source.