Inputing data of multiple rows/columns from one sheet into a database on different sheet on same workbook

sperrow

New Member
Joined
Jul 23, 2014
Messages
1
To start, I am very unexperienced in VBA. I have an excel workbook with two sheets "Input" and "Database" I need to create a code so that I have a command button on the "Input" sheet that will transfer the data that will be inserted into a "table"(just a 24 row by 13 column section) as shown below (sometimes the table will not always be filled all the way with data but I want to transfer whole table each time), and the data will be inserted into "Database" in the excel workbook so that somebody can look at all of the "tables" of data lined up vertically with one blank row of separation between each table. The command button needs to be able to when pressed take the data from "Input" and put it into "Database" so that new tables are put below the last table that was entered and then the data entered in the "Input" needs to be cleared (without removing the table template) so that somebody could enter in another tables worth of data.
This here is the table template (24 rows by 13 column section in excel) from the "Input" sheet of excel workbook:
Load #12345678910
Time In
Time Out
Load Sec
DateShop / Lot Number of parts that were dewaxed

<COLGROUP><COL style="WIDTH: 48pt" span=13 width=64><TBODY>
</TBODY>
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,392
Messages
5,769,816
Members
425,574
Latest member
grimeslisa

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