MY Problem is to add formula before buttons clears totals i need to copy in sheet 5 "DAY" H2:H280 and paste special into sheet 2 "Variances" Starting from B2:B280 as well as copy from sheet 5 "DAY" D2:D280 and paste special into sheet 3 "Sales History" starting from B2:B280, but every new day needs to paste special into next Open column for both pastes and so on ....
Bookmarks