Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add a column to summary sheet if another worksheet i
I am using a pretty simple spreadsheet. One worksheet (estimate 1)
calculates a job cost by multiplying hours x labor rates. There are some text boxes where I can enter notes etc. In a separate sheet (summary) I summarize all the data from "estimate 1" by setting cells in "summary" = to specific cells in "estimate 1" A very simple transfer of data.... First Column is the Categories/Headings and 2nd column is the data from "estimate 1" Often, we are asked to estimate several jobs for the same client. To do this, I make as many copies of "estimate1" (before I add data) as I need for the number of projects we are estimating and name them "estimate 2, estimate 3 etc...." What I would like to see happen is that for each copy of "estimate 1", I would like a corresponding column to summarize the data in the sheet "Summary". Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add a column to summary sheet if another worksheet i
If you can ensure the following things happen in your "Non-Summary"
worksheets, this will work. Make sure that all data that is pulled from these "Non-Summary" worksheets is located in the same RELATIVE location on each sheet. This means for the data that is pulled to the SUMMARY sheet, it needs to be put in cells(Like A100:A200) on each "Non-Summary" worksheet. Then do as you normally do with the first project/estimate. On the summary sheet, make the cell function like =Sheet2!$A100, =Sheet2!$A101, =Sheet2!$A102 and so on. Make sure to use the $ symbols to lock in the column. Then copy and paste the formulas on the summary(I.e. Column A) to Column B. Select all of the new formulas in Column B and run the search and replace utility to replace "Sheet2" with "Sheet3" Repeat any steps needed. Dennis "Living Design" wrote in message ... I am using a pretty simple spreadsheet. One worksheet (estimate 1) calculates a job cost by multiplying hours x labor rates. There are some text boxes where I can enter notes etc. In a separate sheet (summary) I summarize all the data from "estimate 1" by setting cells in "summary" = to specific cells in "estimate 1" A very simple transfer of data.... First Column is the Categories/Headings and 2nd column is the data from "estimate 1" Often, we are asked to estimate several jobs for the same client. To do this, I make as many copies of "estimate1" (before I add data) as I need for the number of projects we are estimating and name them "estimate 2, estimate 3 etc...." What I would like to see happen is that for each copy of "estimate 1", I would like a corresponding column to summarize the data in the sheet "Summary". Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add a column to summary sheet if another workshe
Short of the columns automatically adding themselves each time there is a new
sheet, this is the shortcut I was looking for. Thanks Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Summary Sheet Automatically | Excel Discussion (Misc queries) | |||
Help Automatically Populating A Summary sheet | New Users to Excel | |||
How do I automatically rename a sheet from the summary page? | Excel Worksheet Functions | |||
automatically updating summary worksheet | Excel Worksheet Functions | |||
automatically updating a summary worksheet | Excel Discussion (Misc queries) |