Macro to create new week spreadsheet

HELLO All,

I’m creating a workbook for a cash flow statement that will link(via cell formulas – mostly sumproduct) to various data sources. In addition every week they want the header to show if it’s Actuals or Flash and do a bunch of formatting based on the specific week and/or day. Also I would like it to copy/paste special/values (Freeze data and remove links) over the previous week’s Actuals (no need to update they should be frozen). I would like to do this as a macro, that they can push at the beginning of a new week. I can’t change the worksheets within the book because this is sent to corporate so that they may consolidate all the sheets into one. I’m part way there but I can’t figure how to create the comparison to a date then find that specific column before it starts copying and pasting for the new week.

I hope this is clear, if not let me know …. Does anyone have suggestions?

Thanks so much in advance!

Hi

Think we need a bit more on your structure.

1) Where are the dates being compared
2) What is the date format
3) What is this date being compared against

Perhaps attach an example workbook that shows your structure, with representative data and explain what you would like to happen.

rylo