What is the Excel Formula to move a certain range of cells to another sheet?

copy and paste?

if you want sheet 2 to pull from sheet 1

maybe sheet 2 can use a formula like this

=Sheet1!A1

just change A1 to whetever cell you want.

might need need more info on what you are trying to do..

If you want to copy these values in Sheet2:

- In Sheet2 , click on the cell you want the values to start (equivalent to A1 in Sheet1).

- Type in ' = '

- At the bottom of your screen, look for the tab with the names of the worksheets. Click on Sheet1.

- Click on the starting cell (A1)

- Hit enter. The value has been copied to cell F1 in Sheet2

Now to copy the rest of the cells, starting on Sheet2:

- Select the starting cell, F1

- Mouseover the bottom right corner of the cell, where you see a black square. Your mouse will change from a white cross to a black thinner cross.

- Left click and hold the button, dragging the selection either horizontally or vertically. You will all the values appearing in your sheet.

- Do the same thing in the other direction

- Done

Tags: certain, excel, Formula, move, What