Microsoft Excel 2010 (academic)

Hi, I have a Time table that calculates the specific number of hours per shift, I need these numbers to be copied to a different sheet in the same workbook to allow that sheet to calculate total cost so my account department can invoice, but I must show the total hours per day. So it would be (Sheet1)

Start Finish Total Km's

- -this goes across for 31 days. I need to get each coloum with Total copied to a different sheet (sheet2)

28-Feb

-again this has the same 31 days - so data on sheet 1 at Feb 28th Total would need to be copied to coloum 28-Feb in sheet 2

Hi There isn't enough information in your question to provide a specific answer. We would need to see your data on both sheets and get an explanation of your expected results - for example, it's not clear what you have on sheet 1 - is it 3 or 4 columns per month? do you want every rows data or a sum of the rows for a column?

Can you post examples of your data and the expected results being clear about rows and columns and sheet names?

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History