VBA to input/delete row and copy data

[jlucky44]

Hello,

I'm trying to create Two Macros but I'm completely lost since I have not much experience building them. Those macros will be linked to different buttons.

First Macro (Add Row/Copy Data)
Two different sheets I create a function which returns "c" at the last row I would like to add a row on top of, I also would like the information from the last row copied into the new row.

Second Macro (Delete Row)
Basically this macro is supposed to delete the row on top[ of the C

I appreciate any input on this!

 

[MisterProzilla]

Hi,
this should be possible but I don't really understand the part in the first macro about a function returning a C at the last row you would like to add a row on top of. Could you explain a little further?

 

[jlucky44]

Yes of course, the "C" is just a variable created with the normal offset function in excel. The "C" would be located in column C and always be in the last row where I want to add a Row on top of with all formulas copied over.

Does that make any sense, I would provide pictures but I don't know how to add them to the discussion.