I have a workbook with 2 Tabs (Pivot; Archive)
On the Pivot tab (which I update daily) I have a Date in P1 and then data in Q4:Q7 and X4:X8.
On my Archive tab, I have a table with the Date from now till the end of the year (Column A), and then Columns B:J which match the rows from Q4:Q7 and X4:X8 on the Pivot Table. (essentially converted rows to columns)
When I run the VB script, I'd like to copy the data on the Pivot Tab (Q4:Q7 and X4:X8) using the Date in P1, then match that date on the Archive Tab in Column A, then paste the values (NOT FORMULA) across B:J.
.... so take q4 go to archive tab, match the date and then paste in lets say b12 which matches the date for that day, then repeat with q5>B13 etc...
How would I create the VB script to first match the dates and then copy each row to its respective column?
On the Pivot tab (which I update daily) I have a Date in P1 and then data in Q4:Q7 and X4:X8.
On my Archive tab, I have a table with the Date from now till the end of the year (Column A), and then Columns B:J which match the rows from Q4:Q7 and X4:X8 on the Pivot Table. (essentially converted rows to columns)
When I run the VB script, I'd like to copy the data on the Pivot Tab (Q4:Q7 and X4:X8) using the Date in P1, then match that date on the Archive Tab in Column A, then paste the values (NOT FORMULA) across B:J.
.... so take q4 go to archive tab, match the date and then paste in lets say b12 which matches the date for that day, then repeat with q5>B13 etc...
How would I create the VB script to first match the dates and then copy each row to its respective column?