Thread: get values from one sheet and add to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default get values from one sheet and add to another
in a cell on sheet3 put in the formula

=Sheet2!A2

then drag fill down as far as you need.

--
Regards,
Tom Ogilvy


"NuB" <CSharpCoder wrote in message
...
I have a spreadsheet and it has 3 worksheets. I want to get the values of
column A2 - A50 from worksheet 2 and show them on workseet 3, can that be
done and if so, how?




Reply With QuoteReply With Quote