| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer information cells between spreadsheets
Easiest way is to use simple links
to extract the source cell/range contents in the other sheet Something like this In Sheet2, You could place this in any start cell, say in B2: =IF(Sheet1!A1="","",Sheet1!A1) then copy B2 across/fill down to C3 to dynamically link it to Sheet1's A1:B2 -- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "jimeeabaohe" wrote: How do I transfer information in one spreadsheet to another and have the second spreadsheet automatically update? Jim Parson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up information on one worksheet and transfer to another | Excel Discussion (Misc queries) | |||
| Transfer information | Setting up and Configuration of Excel | |||
| how do I transfer information from one sheet to another? | Excel Discussion (Misc queries) | |||
| How do I transfer formulas but not the information? | Excel Worksheet Functions | |||
| HOW DO I TRANSFER EXCEL SPREADSHEETS WITH QUERIES AND MACROS? | Excel Discussion (Misc queries) | |||
Hybrid Mode
