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
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
I am still having trouble trying to figure this out.
Any help would be much appreciated,
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.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
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
Last edited by BC TIPPING; 08-16-2015 at 09:53 PM.
Here some VBA code that will place that information in the correct location (next blank rows) when you close the file.
Open the VBA editior (Alt +F11)Please Login or Register to view this content.
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.
Thanks ALan,
It has a script error at
lr = sh.Range("P" & Rows.Count).End(xlUp).Row
Was having some issues with the Before Close Event, so I changed this to a straight Macro.
How to install your new codePlease Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Works perfectly, Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks