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.
|