| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| Assign values to a cell in sheet A, from worksheet_change event of sheet B | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Linear Mode
