Macro to enter totals into columns on dates

Hi, i have a range of data in one sheet which has a reference number and amount & dates, so i wrote a push button macro to arrange the data into a pivot table and total by the reference numbers and the month the spend incurred.

Next on my forecast sheet the reference numbers are on the far left array and now i'm stuck because i want these totals by ref number and date (month)to go in my forecast sheet by month (obviously at the top of the sheet) searching by reference number on the far left and looking at the month at the top on the sheet and been entered into the corresponding columns on the spreadsheet

I.e

Month Column
Jan Feb March April May Jun July

Ref Number 1234
Ref Number 4567

How would i go about doing this shoudl i use =if statement by referencing the pivot table results which seems easy, but how would i write a forumula to take into account the dates the costs came in a double vlookup??

please help!

Hi D, i'll try to make a sample sheet and send it over, the data is sensitive so i clean it up, but thanks for your suggestion the GETPIVOTDATA function sounds viable but there is a vast amount of data which changes month by month,

The pivot Groups the total spends by the Ref: No, then by Month

But thank you for your advice and i'll see if i can get a sample sheet over to you.

The only reason i created a pivot table as there is alot of data and the pivot helps capture the totals easily and if i could capture these totals again into the forecast that would be supreme.

Thanks Again will be in touch