Unable to find a formula that helps to send data into a different sheet for workday EOM

[delboy1616]

the formula in monthly totals tab A6 works for first month only i.e. March only but I need to define working day month end for all months listed in the Daily tab. Also what would be the easyest way to copy the end of month totals into the monthly totals sheet. Thank you.. sample attached

[Bo_Ry]

Please try at A6 and drag down
=WORKDAY(EOMONTH('Daily '!$E$7,ROWS(A$6:A6)-1)+1,-1)

[delboy1616]

Hi Bo_Ry, I have tested the formula that you sent me. I thought that the date listed in Monthly Totals column 'A' would have been able to picked up from nominated date in the Daily sheet and copied into the Monthly Total columns, this has not occurred. I have attached another test xls for clarity. Would you be able to assist me please.

[Bo_Ry]

Please try at
C6:F6
=SUMIFS('Daily '!A:A,'Daily '!$E:$E,"<="&$A6,'Daily '!$E:$E,">"&EOMONTH($A6,-1))

G6:K6
=SUMIFS('Daily '!F:F,'Daily '!$E:$E,"<="&$A6,'Daily '!$E:$E,">"&EOMONTH($A6,-1))

[delboy1616]

Thanks for the fast responce. I have tested the formulas and noted that it appears to be summing the column down to the date nominated. Perhaps I am confusing you as this not what is required. It is much simpla than that. Only the data in the row 18 minus the date is required this would enable me to capture the EO Month figures for that day only. Then I could copy the formula down so I capture the EO Month data for the year as it occurrs.

Sorry I lead you up the wrong path.

[Bo_Ry]

No problem, for sum only 1 day

C6:F6
=SUMIFS('Daily '!A:A,'Daily '!$E:$E,$A6)
G6:K6
=SUMIFS('Daily '!F:F,'Daily '!$E:$E,$A6)

[delboy1616]

Bo_Ry thank you so much for you kind assistance today. All is working as planned now, you are a star.......

Thanks
Del

[delboy1616]

Hi Bo_Ry, thanks for your help previously. I have found an issue that you may be able to help me with.

Here is some background info, data is imported via a web page, and copied into column A and the column that contains the date where when the data is produced.

Now when the data in Column A has been added to ( the new data is not always added from the last entry, it can appear at any point) When fresh company names appear, it throws out of sync all rows after the new entry. This is a problem as I have to alter all the data in the rows after the new entry in column A. Is there a way of locking together the company name and the remaing row.
So when the sheet is saved the contents in column A and its row are locked together.

[AliGW]

Please start a new thread for this new query. Thanks.