Insert/append data from Sheet A to Sheet B

[evenings]

Hello all, I am wondering if I can copy data from one sheet and append to another in order to create an archive of data. Please see attachment.

In the Weekly Totals sheet I will keep track of daily sales of Tools. When the week is over and the sheet is full of sales data, I would like a macro to import the data according to Date and Tools to the Database sheet. Once the data is imported or copied to Database sheet, I will then begin a new week. This is where is gets tricky.

After starting a new week, I want the macro to know I began a new week and append to the Database sheet the new Weeks dates and values for each Tool. In theory after a few months of data values from Weekly Totals sheet I would be able to see all the Daily sales of Tools displayed in the Database sheet. Also, lets say I run the macro two times at the end of the week, I do not want the same information imported or copied over to the Database sheet. Would there be a way for it to identify say by date? If the same date has already been imported then do nothing else insert new information.

I am trying to avoid making a new sheet for each week. I think this works better. Thanks in advance.

[teylyn]

Hello,

this is not what you want to hear, but I think your tackling this the wrong way round.

Create a simple, three column data entry table on one sheet, with columns for Date, Tool, Units. Enter data into this table. One row for each date/Tool combination, or even several rows for a date/Tool combnination.

Then use a pivot table to create a layout like the one you currently have, to report on a weekly basis using the filters in the pivot table to display the desired week.