Transfering of data from 1 worksheet to another

  • Thread starter Thread starter nandosuperstar
  • Start date Start date
N

nandosuperstar

Is it possible to copy a figure from a cell over to a new worksheet without
having to do it manually over every sheet?
i.e i want the figure in cell g24 in sheet 1 to appear in cell b2 in sheet
2,and the figure in cell g24 in sheet 2 to appear in cell b2 in sheet 3 etc
etc.
 
Select the first worksheet and then ctrl-click on the sheet tabs for all the
other worksheets that get this.

Then select B2
Type this:
='Sheet 1'!g24
or
=if('Sheet 1'!g24="","",'Sheet 1'!g24)

Then rightclick on any of the grouped sheet tabs and choose Ungroup Sheets.

B2 in each of the selected sheets will have a formula that points back to Sheet
1 G24.

This is a nice way to do headers, but it's not a good way for data that will
move around (don't sort Sheet 1).
 
Back
Top