Thread: Autofill a row from sheet 1 to a column on sheet 2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janet Janet is offline
external usenet poster
  
Posts: 49
Default Autofill a row from sheet 1 to a column on sheet 2
I want cells D2, E2, F2, G2, H2, etc on sheet one

to autofill onto columns on sheet 2

="Sheet 1'!D2
="Sheet 1'!E2
etc.

Is this possible?
Reply With QuoteReply With Quote