Ok, I am just getting into the macro aspect of excel, so please be patient with me. I basically am trying to create a macro that creates a new row of data under existing data in a table (not really a table but just a range as of now). Here is my main two criteria:
1) I have used some data validation in some of the cells and formulas (vlookups), so I would like to copy these same validation lists in the new row, however, I don't want them to be populated. I also have some cells which just have text in them (symbols such as @ and =) that I would like copied down into the newly created row.
2) I want the row to always be created after the last row of data.
I have tried using the macro recorder and looked everywhere online but I am not experienced enough in VBA to get the syntax down quite right. I have attached the workbook for reference. In summary:
- I want to create a Macro that adds a row after the last row of data in the table (in the worksheet this would be under row 22.)
- I would like it to copy the formulas and data validation in cells C22, D22, E22, and I22), but not show anything when the new row is created - the cells with data validations (D22:E22) drive the vlookup in C22 so as long as these are clear C22 will not return anything.
- I would like it to copy the contents from cells F22 & H22.
Thanks for the help!!
Bookmarks