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