Insert Row Below and Copy Values from Row Above

Does anyone know how do I modify this so it takes the values from the above row (the row of the active cell) and inserts them into the new row below. I need it to only copy the values from Columns A, B, C, J, K, and L. Is this possible?

Please Login or Register  to view this content.

Any help would be excellent. Thanks in advance for any help you can provide.

Anyone with any idea?

Project_Manager (Test).xlsm

I have attached my workbook. You will see that when you click on any cell within a row and hit the 'Insert Row' button, a row is inserted below. I want that row to be populated with values from the above row. You'll see that it's a project manager in the making. I have projects and tasks below. I want to be able to click on a cell within a project and click insert row and have a new row with values populated. I am comfortable having it 'ActiveCell', but it can't happen that way, I'm open to anything else.

Let me know if you need anything else.

You'll notice a bunch of other macros. Disregard those, please. They pertain to the master file.

Thanks! How can I modify that to copy only the values from fields 1, 2, 3, and 8? I tried modifying your code, but I don't understand it :-I can you help?

It isn't pulling the value from field 3. I would modify the code to do this normally, but I'm not that advanced in VBA, and I still don't know how your code works exactly. Pardon my lack of knowledge.

xladept,

Sorry to confuse you. Mixing up table columns with sheet columns didn't help my understanding. I'm glad you were able to see through my misunderstanding.

Thank you very much!!