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