View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Formula to combine 2 spread sheets into one

Hi,
I suppouse that you headers are in column A starting in row 1 so in B1 enter

=Sheet2:Sheet3!A1 copy the formula down

if this helps please click yes, thanks


"dramon" wrote:

Is it possible to combine sheet 1 and sheet 2 into sheet 3? If it is what's
the formula?