Moving data based on dates

[BC TIPPING]

Hi team,

I am trying to store a daily report as historical data under each queue.

Please see example for more details.
Matching date data.xlsx

[BC TIPPING]

I am still having trouble trying to figure this out.

Any help would be much appreciated,

[alansidman]

I'm guessing you have no responses because you have not indicated what your report should look like. I would urge you to explain in simple language using your worksheet as an example what you want to happen specifically. I am sure it is clear in your head, but unfortunately, we here at the forum are not mind readers. Tell us simply what is on your mind.

[BC TIPPING]

Thanks Alan,

I have adjusted the example to show more clearly where I want the data to go but I'll try & explain it as well. Matching date data.xlsx

I currently have a daily report which we run every morning similar to the format on sheet 1. Once a new report is generated all the information from the previous day is lost.
What I would like is for the information from the daily report "Before" to be transferred to each of their queues in another tab "After" and for them to go under the date that is shown on the daily report. If this is not possible a button that just moves the data to the next available row in those queues.

Thanks again

[alansidman]

Here some VBA code that will place that information in the correct location (next blank rows) when you close the file.

Please Login or Register  to view this content.

Open the VBA editior (Alt +F11)
In the left window, double click on the item listed as ThisWorkbook
In the new right window, paste in the above code.
Close the window.

[BC TIPPING]

Thanks ALan,

It has a script error at
lr = sh.Range("P" & Rows.Count).End(xlUp).Row

[alansidman]

Was having some issues with the Before Close Event, so I changed this to a straight Macro.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[BC TIPPING]

Works perfectly, Thanks