I'm using excel 07, and I need to copy 2 columns from a Dynamic Named Range to new rows in an existing sheet in the same book. I need the inserted rows to copy formulas/format from the rows above, and insert the First and Last names from Sheet1's dynamic named range.
I've been able to somewhat achieve this by vlookup, but I would prefer a macro loop that goes through the dynamic named range and finds new entries and inserts a new row in sheet2.
I have attached the workbook with dummy values. Sheet2 is where all the action happens. To give an idea of the process, a technician exports values from the web into an Excel file. They then "copy" the Last Name & First Name columns from the export file and "paste" them into Sheet1. I need a macro that, when executed, compares Existing Last Name & First Name from Sheet2 to Sheet1 and creates new formatted rows for the new names (the rows will be blank, but will have the same format as the row above).
I've been researching this for days, trying different variations, etc., and have all but given up. I can feel that it is just out of reach, but all of the different function terms are starting to confuse me. I have some experimental sheets in the book, but all I care about are Sheet1 and Sheet2. You can see what Sheet2 should look like, it just needs to be automated.
In the book I attached, there is a new client in Sheet1 that is not in the Sheet2. I have a "manual" insert row macro that keeps the same format, but doesn't compare to the other list to find "new" names.
Also, if Sheet2 could expand and contract as needed by adding rows for new clients on Sheet1, and deleting names no longer on Sheet1, then I wouldn't have to "pre-format" 500 rows. End-user simplicity is preferred, and I will be hiding all sheets other than Sheet1 and Sheet2, so, anything we can do to automate as much as possible is the way to go.
If someone knows how to do it, but is only willing to write this up for a fee, please inbox me with what it would take for you to do the code. I am doing this as part of my internship, so I can't really afford to pay for it. But, if it's the difference between getting the macro and "TLDR", then I'll do what I have to.
Thanks in advance for any advice you can offer. I will check back frequently to see if there are any questions or suggestions.