Copy data from cell in Sheet 1 to cell in sheet 2

Microsoft Excel 2010 (academic)
February 12, 2013 at 20:14:18
Specs: Windows 7
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)


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

See More: Copy data from cell in Sheet 1 to cell in sheet 2

February 13, 2013 at 13:14:20

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?

Report •
Related Solutions

Ask Question