| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple sheets (categories) into one master sheet
Thank you very much. I will give this a shot.
"Shane Devenshire" wrote: Hi, If you are just trying to update the title of item, this can only be done in one direction. That is you can build a linking formula from the master to the category sheets or visa versa, but not both ways. To handle both directions you would need VBA (programming). If you entered =Sheet3!A5 In the Master sheet it will pick up that value. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "NickySams" wrote: I have several sheets in my workbook that have solutions to common problems we encounter here in the office. What I want is to have the separate categories as sheets, which I currently do, and one that has all of the categories together on one sheet, which I also have. My problem is that if I change one of the solutions either on the master list or in the category, it doesn't update in the other location. How would I make this possible? I apologize if the question is confusing. Heh. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i combine data from multiple sheets into one sheet? | Excel Discussion (Misc queries) | |||
| Pulling information from master sheet to multiple sheets | New Users to Excel | |||
| How Do I Combine Rankings for Multiple Categories? | Excel Worksheet Functions | |||
| combine multiple sheets, each sheet has info in different cells | Setting up and Configuration of Excel | |||
| Combine multiple sheets into one sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
