If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple sheets
is it possible to copy a section (example A5:M9)of sheet 1
that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2? |
#2
|
|||
|
|||
multiple sheets
Yes select A5:M9 and copy the range. Go where you want to
paste it and right click, select paste special/values. -Nimit -----Original Message----- is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2? . |
#3
|
|||
|
|||
multiple sheets
how do i link the activity that takes place on the first
sheet to give me just the value of a cell from sheet 1 and send it to where i want it on sheet 2. so as the number changes on sheet 1 it changes on sheet two. basically sheet one is where all of my work is being done and sheet 2 is the good copy to be handed in. -----Original Message----- Yes select A5:M9 and copy the range. Go where you want to paste it and right click, select paste special/values. -Nimit -----Original Message----- is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2? . . |
#4
|
|||
|
|||
multiple sheets
To link Sheet1 A5 to Sheet2 A5 select A5 on Sheet2 and enter an = sign then
switch to Sheet1 A5 and hit ENTER key. Sheet2 A5 will now have the formula =Sheet1!A5 Drag/copy this across to M5 and down to M9 Gord Dibben Excel MVP On Mon, 12 Jul 2004 17:21:51 -0700, wrote: how do i link the activity that takes place on the first sheet to give me just the value of a cell from sheet 1 and send it to where i want it on sheet 2. so as the number changes on sheet 1 it changes on sheet two. basically sheet one is where all of my work is being done and sheet 2 is the good copy to be handed in. -----Original Message----- Yes select A5:M9 and copy the range. Go where you want to paste it and right click, select paste special/values. -Nimit -----Original Message----- is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2? . . |
#5
|
|||
|
|||
multiple sheets
in cell where you want the values to be displayed,
=reference where reference is the path of the cell of whose vlues you want to display. -Nimit -----Original Message----- how do i link the activity that takes place on the first sheet to give me just the value of a cell from sheet 1 and send it to where i want it on sheet 2. so as the number changes on sheet 1 it changes on sheet two. basically sheet one is where all of my work is being done and sheet 2 is the good copy to be handed in. -----Original Message----- Yes select A5:M9 and copy the range. Go where you want to paste it and right click, select paste special/values. -Nimit -----Original Message----- is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2? . . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula across multiple sheets | Dave | Worksheet Functions | 1 | March 18th, 2004 10:50 PM |
Password protecting multiple sheets | Allison | Worksheet Functions | 1 | February 27th, 2004 02:15 AM |
Fuctions across multiple identical sheets | Tore Aa | Worksheet Functions | 1 | February 2nd, 2004 04:03 PM |
protect / unprotect multiple sheets | Lisa Williams | Worksheet Functions | 3 | January 31st, 2004 06:31 PM |
COUNTIF single criteria across multiple sheets?? | Earl Kiosterud | Worksheet Functions | 1 | October 29th, 2003 06:17 PM |