Copying specific cells from one work sheet to paste to the last row in a table

sashol3

New Member
Joined
Jun 7, 2021
Messages
6
Office Version
  1. 2019
Platform
  1. Windows
I have two seperate sheets. Sheet 1(CALCULATOR) has values that are entered in cells scattered on the sheet. I want to be able to copy values from specific cells on sheet 1.

On Sheet 2(Calclogs), I have a table. I first make a new row. And on that row, I want each cell that is copied from sheet one to be pasted in each column on the new row.

I have successfully made a new row on the table and then I figured out how to copy a specific cell from Sheet 1, however I dont know how to select the last row and specific column in the table on Sheet 2 so i can paste the value in the correct column of the last row.

VBA Code:
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Dim Calclogs As ListObject




Set Calculator = Sheets("Calculator")
Set Calclogs_sht = Sheets("Calclogs_sht")



Dim CalclogsTable As ListObject
Set CalclogsTable = Calclogs_sht.ListObjects("Calclogs")

Calculator.Select
Range("B1").MergeArea.Cut

lastrow = CalclogsTable.ListColumns(1).Range.Rows.Count
CalclogsTable.Range(lastrow, 1).Select
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

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
Back
Top