not sure if it's possible without a macro to move a row from one worksheet to the last row of a table on another worksheet

mwamsley

New Member
Joined
Apr 27, 2016
Messages
4
As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows. Ideally I want to do this without VB, but I don't think that's possible. I have tried to get this to work a dozen ways, but this in my 1st time to use VB. So far I was working on this:


Code:
Sub Macro1()
'
' Macro1 Macro
'




'




Dim lastrow As Integer




lastrow = Worksheets("server").ListObjects("server_dc_a").ListRows.Count




Worksheets("Input").ListObjects("server_dc_a_input").Range.Copy Destination:=Worksheets("server").ListObjects("server_dc_a").ListRows(lastrow + 1).Range
lastrow = lastrow + 1
End Sub
But anything that will accomplish this is fine. also on the original "Input" worksheet I was wanting the entries to clear after it ran
to help make it easier to see what I'm trying to do, I went ahead an scrubbed the file and uploaded it to drop box:
https://www.dropbox.com/s/t92d7owfbw...bbed.xlsm?dl=0
 

Forum statistics

Threads
1,085,580
Messages
5,384,565
Members
401,909
Latest member
dlo1503

Some videos you may like

This Week's Hot Topics

Top