automatic cell filling

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

I know how to autometicall fill in cells with reference to
the same worksheet and the f4 function but how do I make
excel automatically look at the same cell in a number of
worksheets. i.e. on my analysis sheet I can manually get
excel to look up 40 values on sheet A but how do i get it
to automatically look up the same 40 cells on worksheet B
etc.?
 
If you assign a RangeName to a VLOOKUP table, it will work across all the
worksheets in a workbook.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top