VBA to input/delete row and copy data

jlucky44

New Member
Joined
Jan 5, 2017
Messages
5
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!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

MisterProzilla

Active Member
Joined
Nov 12, 2015
Messages
263
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

New Member
Joined
Jan 5, 2017
Messages
5
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,696
Messages
5,626,361
Members
416,175
Latest member
LavendarRabbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top