getting data from one sheet to another

J

Just me

I am working on a labor chart. The first sheet has the names and day of the
week. I have them formatted to just put in the number of hours and it
figures pay.
There are 4 different job descriptions and at the bottom of each day, it
totals the dollars spent for labor on that day.
My second sheet has sales and will divide the cost of labor by sales and
give me a percentage.
On the second page, how can I get the total dollars in labor for each
catagory from sheet one to a certain cell on sheet 2 without manually
entering it. I know it can be done as I have seen it before
 
G

Guest

Assuming the data you want to copy to Sheet2 is held in cell A1 of Sheet1,
then the formula =Sheet1!A1 will do what you want, of course you will need
to change the Sheet and cell names to suit your situation.

HTH

Neil
www.nwarwick.co.uk
 
J

Just Me

Works like a champ. Thanks


Neil said:
Assuming the data you want to copy to Sheet2 is held in cell A1 of Sheet1,
then the formula =Sheet1!A1 will do what you want, of course you will need
to change the Sheet and cell names to suit your situation.

HTH

Neil
www.nwarwick.co.uk
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help gathering data from various files 1
can you look up info from a validated drop down menu in excel 2007 1
Monthly Summary and SUMIF 6
locate a column, sum specific columns to the right of that column 3
Formula to sum up customers totals from other sheets 2
Formula to sum up customers totals from other sheets 1
I have a bar graph and want to move a bar around within the graph. 1
Copy Data from One sheet to Different Sheets 1

Top