Hey guys,
Reasonably new to Excell, but think i hve a pretty solid basic understanding.
I'm looking to create a file where i can paste a new days worth of data in every day and pull specific parts out of it for the sheet im trying to make.
I want to create a sheet that will update relevant to what day of the week it is. ( I Want To Send An Update Every Day - Week To Date ) e.g. if it is Friday i want the data to be pulled up until thursday (as friday, business hasnt closed yet) and for the fri,sat,sun cells to remain blank etc.
I need to report to pull data from a 28 date period, but from a possible 31 different sections of data.
I need to have the individual 28 days of data, plus a section for the combined 28 days, Week to date (Monday to current day) and Last week to same day (Monday to same day last week that yesterday was, if today is friday, to be last week monday until thursday)
Id like it so i can literally just copy and paste todays data and it would auto populate the cells with the correct info etc.
i dont know if id need to have like 31 sections to paste the 28 days and the 3 multi day reports to, then i just update the 3 multi day reports manually and copy and paste a new days data and the old 28th day would drop off (i delete it) or if it would be better to have like a rolling template that with every day that passes, the information that the cells take from move down to a new day ( so that after 500 days etc, id have 500 days of pasted data, and it just keep rolling on etc.
I hope this makes some sort of sense? its really hard to try and explain what im looking for.
Thanks in advance for you help.
Peace,
Milk
Bookmarks