Copy range of data from one sheet into predefined table in another sheet

vsc90

New Member
Joined
Jul 2, 2018
Messages
1
I have a problem with which I can't find a good solution. I can't code VBA per se, but I'm usually pretty neat at finding codes online and stitch them together to something that works for my intended use.


I haven't found anything usefully for my current problem.


Currently, I have a workbook with two sheets. Sheet "Data" and sheet "Table".


In sheet "Data" I post a raw data string in column A, which is then divided into column A: H by a script, starting with row 2 (Row 1 has headers for identification). That works just fine. This is done once a week.


In sheet "Table" I have a predefined table with headers in Column A: H in which the data from Data"A: H" is inserted. The new data from "Data" is added ad the bottom of the table, adding to the existing table.


What I'm trying to do, is make a script that runs through Column A:H in sheet "Data", starting at 2nd row and ending at the last line, that copies the data and inserts it in the predefined Table in sheet "Table", starting at the last line of the existing table.


I've been searching around for some code that can do this, but I haven't figured out how just yet. I hope somebody here can help me out :)
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

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