Is it Possible to pull data from a column and place in a separate sheet based on a week.

Thanks for your reply, i have attached a Test Book, this has 3 sheets. "Daily Totals" "Week Totals" & Test Sheet.

Again the idea is to be able to pull up a userform (shown in my "Test Sheet" Sheet) That displays the current weeks totals.

The daily totals are inserted with a userform i already have in place ( not on the workbook) They are submitted daily, i am however stuck with collating the daily totals . I would like the Formula i use to be specific to the system date so that it will dynamically change depending what day and week we are in.

I guess i need a formula that looks at the colum data then based on the current date only adds values that lie on a specific day within a specific week within a specific year? But all this has to happen automatically within the cell on "week Totals"

I hope i have made this clear?

Good morning, any thoughts on this as I've been trying now for 3 days and can't get anywhere? Thanks in advance

Add this formula to cell F2 of your Daily Totals sheet:

=IF(A2="","-",WEEKDAY(A2,2))

then copy this down as far as you like. You can call the column Day_num in F1.

In the Week Totals sheet you should insert a new column A, call this Week_num in cell A3, and then fill the column with a sequence 1, 2, 3, 4 etc., starting in A4. Then in B4 (under Monday) you can use this formula:

=SUMIFS('Daily Totals'!$D:$D,'Daily Totals'!$E:$E,$A4,'Daily Totals'!$F:$F,COLUMNS($B:B))

Copy this across and down, as required.

Hope this helps.

Pete