Send to end of list

saibb

New Member
Joined
Aug 24, 2004
Messages
13
Hello All,
I have a row of information on an "Input sheet" and I want to send it to another sheet, to the end of the line of existing information using a macro. I know this can be done as I have seen it before but now I cannot find the posting. Please make it relatively simple as I am relatively new at this.

Thanks

Bilal :cool:


Thanks Norie for the reply. Here is what I mean. I have a sheet titled "Input page" and it has 16 balnk insertion fields for my employees to place certain information. Once all of the information is placed, I want them to click on a button (Which I know how to create). This should run a Macro that copies the information from the list and send them to the end of the line of the "Master pt data" sheet, then to return to the "Input page" again and to automatically save the program.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,219
Office Version
  1. 365
Platform
  1. Windows
Can you give more information?

To get the last row of data in say column A you can use something like this.

Code:
Dim LastRow As Long

       LastRow = ActiveSheet.Range("A65536").End(xlUp)
 

saibb

New Member
Joined
Aug 24, 2004
Messages
13
OK, I have no Idea what is supposed to happen. I simply need a25 through v25 to be copied then pasted on another sheet named: "Master pt data" on the last line starting from a(row number) to V(row number).

Can this be done?

:oops:
 

Kundepuu

New Member
Joined
Sep 29, 2004
Messages
46
Code:
Sub Makro1()
Dim LastRow As Long
Sheets("Master pt data").Activate
LastRow = ActiveSheet.Range("A65536").End(xlUp).Row
Sheets("Input page").Activate
Range("A25:V25").Copy Destination:=Sheets("Master pt data").Range("A" & LastRow + 1)
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,123,079
Messages
5,599,636
Members
414,326
Latest member
kfg1287

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