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.
|