get values from one sheet and add to another
 

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?

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?