VBA code to copy and paste certain cells into a year to date sheet

[MOpenshaw]

Hi All,

I've been working on this for some time now and am totally stuck.


I have a WSOB (weekly statement of businesses) which accounts for all of sales and costs and gives me a flash P&L. I already have one code which resets all the data (reverts closing stocks to opening stocks etc) so I can create a new document each week.

I have another sheet called YTD (year to date) which has all 52 weeks worth of budgets in the same rows/column format as the flash P&L (just 52 of them and a totals column). I need to feed the weekly sales information into the correct week on the YTD via a macro but to make it even more complicated it's only a handful of the cells that need to be copied as the rest are formulas and budgets which are already in the table.

Is this even possible?

Thanks for any help

Matt

[Fettertiger]

HI Matt,

sure, that sounds simple. Unfortunately you would need to provide us with some dummy data to ensure which fields need to be copied into which cells.

Theo