| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking (?) fields from one worksheet to another?
Hi Rajat!
thank you so much for your reply-- I knew this could be done more efficiently! I will try it when I get into work on Monday and let you know what the results are. Thanks again! KJ Rajat wrote: Hi Kateapotomous i am not an expert but as per as my understanding you want to call data from another Excell file or worksheet to an seperate sheet or file. Am i correct? open your summery sheet, select the cell where data from Sales Orders sheet will show press F2 and put '=' (without quote) and after that select the cell from Sales Orders sheet and press "Enter". Data from that sheet will be shown there. when you chage in the Sales Orders sheet the summary sheet will be updated automatically. Am i able to solve ur problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking one worksheet to another worksheet? | Excel Discussion (Misc queries) | |||
| Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
| Linking worksheet to Access Tables | Excel Worksheet Functions | |||
| linking one worksheet to lots of workbooks(worksheets) | Excel Discussion (Misc queries) | |||
| Linking to a tab in another worksheet | Links and Linking in Excel | |||
Threaded Mode
