View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default 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.