| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
import data between worksheets
If I have 5 worksheets in a file and want to have the data in cell C5 of one
sheet displayed in a cell in another worksheet how do I get this done? -- Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
import data between worksheets
Select the "sending" cell
Edit|copy Select the "receiving" cell edit|paste special|paste link You'll see a formula that looks like: =Sheet2!$C$5 If that sending cell is empty, you'll see the formula returns a 0. You may want: =if(Sheet2!$C$5="","",Sheet2!$C$5) to hide the 0. Kurt MN wrote: If I have 5 worksheets in a file and want to have the data in cell C5 of one sheet displayed in a cell in another worksheet how do I get this done? -- Thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i import worksheets from multiple workbooks | New Users to Excel | |||
| Amalgamate Several Worksheets into one file thru Data import | Links and Linking in Excel | |||
| Amalgamate Several Worksheets into one file thru Data import | Excel Discussion (Misc queries) | |||
| How do I import data from lotus123 & maintain formulas/worksheets | Excel Discussion (Misc queries) | |||
| Import various Worksheets | Excel Worksheet Functions | |||
Linear Mode
