Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
single entry across multible sheets in workbook
I have a workbook with three sheets. Each sheet contains essentially the same
date just sorted by different columns. I would like to edit sheet 1 and have the edits pass through the entire workbook. How is this done. Thanks for any help -- George@Presley Creek |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
single entry across multible sheets in workbook
On Aug 26, 1:22 pm, George wrote:
I have a workbook with three sheets. Each sheet contains essentially the same date just sorted by different columns. I would like to edit sheet 1 and have the edits pass through the entire workbook. How is this done. Thanks for any help -- George@Presley Creek Select all the sheets first, then enter/edit your data. It will show up in the exact same cells on each sheet, so make sure that is what you want. Formulas can be tricky sometimes, but they should each refer to their own sheet normally. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
single entry across multible sheets in workbook
Hi,
Since the data is sorted differently on each sheet, you would either 1. Need to handle this with VBA (macros) or try VLOOKUP. If VLOOKUP works for you it means that all the data in the other sheets except a key column will need to be formulas. Those formulas will look something like this: =VLOOKUP($A2,Sheet1!$A$1:$Z$100,2,0) This means that on Sheet2 the key info you want to look up is in column A. You are looking at the range A1:Z100, looking up the value in A2 of the second sheet, within the range A1:A100 of the first sheet and returning the corresponding data from the 2nd column of that range. You may be able to replace 2 with COLUMN(B1) so you can easily copy the formula to the right. The value you are looking up must be unique for this to work in your example as you've described it. -- Cheers, Shane Devenshire "George" wrote: I have a workbook with three sheets. Each sheet contains essentially the same date just sorted by different columns. I would like to edit sheet 1 and have the edits pass through the entire workbook. How is this done. Thanks for any help -- George@Presley Creek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET | Excel Worksheet Functions | |||
Excel 2007: Create a pivot table where data is in multible sheets | Excel Worksheet Functions | |||
selecting a single sheet from a volume of sheets in a workbook | Excel Worksheet Functions | |||
Want to link several sheets in single workbook for searching purposes. | Excel Discussion (Misc queries) | |||
continuous page numbering multiple sheets of a single workbook? | Excel Worksheet Functions |