single entry across multible sheets in workbook

[George]

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

 

[Spiky]

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

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.

 

[ShaneDevenshire]

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.