How to make split weeks feed into one week - finance reporting

[elroberts1999]

Hello, I am trying to condense an excel file down for a finance reporting pack. in our company we have split weeks - so for example this week (W/C 30th September) is week 40. We count the 30th of September as week 40 A and the remainder (Oct 1st-6th) as week 40 B. The issue I am having is that when I am reporting weekly finances we need it to feed into an overall week on another tab so week 40 cannot be two separate entities. It is taking a lot more manual work to do this, was wondering if anyone knew an easier way to do this? Thank you!

[Dturazza]

If you know the range to copy you can try something like this:

Please Login or Register  to view this content.

[Dturazza]

oh sorry, I wrote in the wrong post