Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-766657%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766657%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20a%20nightmare%20and%20require%20help.%20I%20have%20made%20a%20task%20tracker%20for%20work.%20I%20have%20a%20main%20page%20with%2012%20other%20sheets%20which%20are%20the%20different%20departments.%20I%20would%20like%20all%20the%20sheets%20to%20be%20linked%20to%20the%20Dept%20part%20on%20each%20sheet%20so%20which%20ever%20dept%20name%20is%20inputted%20into%20it%2C%20it%20will%20also%20show%20on%20their%20sheet%20tab.%20I%20hope%20that%20makes%20sense.%20I%20have%20attached%20the%20file%20so%20you%20can%20take%20a%20look%20and%20hopefully%20if%20I%20don't%20make%20sense%20you%20can%20figure%20out%20what%20I%20mean.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-766657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-766845%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379828%22%20target%3D%22_blank%22%3E%40Ste_greeny%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20to%20be%20clear%2C%20if%20I%20input%20ROG%20in%20Dept%20column%20of%20BHQ%20sheet%2C%26nbsp%3B%20what%20should%20happen%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-766889%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766889%22%20slang%3D%22en-US%22%3EIt%20should%20show%20the%20entire%20row%20on%20the%20ROG%20sheet%20as%20well%20as%20been%20on%20the%20BHQ%20sheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-766956%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379828%22%20target%3D%22_blank%22%3E%40Ste_greeny%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMoving%20rows%20from%20one%20sheet%20to%20other%20could%20be%20accomplished%20using%20a%20simple%20VBA%20script.%26nbsp%3B%20But%20then%20it%20might%20add%20more%20complexities%20around%20what%20happens%20when%20that%20row%20is%20edited%20in%20one%20of%20the%20two%20sheets(ROG%20and%20BHQ%20in%20this%20example).%3C%2FP%3E%3CP%3EIf%20your%20purpose%20of%20moving%20to%20another%20sheet%20is%20just%20to%20report%20(no%20edits)%2C%20then%20it%20is%20best%20to%20consolidate%20all%20the%20sheets%20in%20to%20single%20tab%20for%20a%20Dept%20in%20read%20only%20mode.%20For%20example%20for%20ROG%20dept%2C%20the%20there%20can%20be%20new%20tab%20called%20%22all%20ROG%20items%22%2C%20the%20data%20for%20this%20will%20come%20from%20a%20query%20that%20looks%20up%20all%20the%20editable%20tabs%20for%26nbsp%3B%20ROG%20dept.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767116%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767116%22%20slang%3D%22en-US%22%3EIt%E2%80%99s%20a%20tricky%20one%20for%20me.%20I%E2%80%99d%20like%20them%20to%20update%20together.%20Even%20thinking%20of%20getting%20a%20pro%20to%20do%20all%20the%20coding.%20Maybe%20it%E2%80%99s%20simple%20enough%20for%20them.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm having a nightmare and require help. I have made a task tracker for work. I have a main page with 12 other sheets which are the different departments. I would like all the sheets to be linked to the Dept part on each sheet so which ever dept name is inputted into it, it will also show on their sheet tab. I hope that makes sense. I have attached the file so you can take a look and hopefully if I don't make sense you can figure out what I mean.

4 Replies
Highlighted

@Ste_greeny 

Just to be clear, if I input ROG in Dept column of BHQ sheet,  what should happen? 

Highlighted
It should show the entire row on the ROG sheet as well as been on the BHQ sheet.
Highlighted

@Ste_greeny 

Moving rows from one sheet to other could be accomplished using a simple VBA script.  But then it might add more complexities around what happens when that row is edited in one of the two sheets(ROG and BHQ in this example).

If your purpose of moving to another sheet is just to report (no edits), then it is best to consolidate all the sheets in to single tab for a Dept in read only mode. For example for ROG dept, the there can be new tab called "all ROG items", the data for this will come from a query that looks up all the editable tabs for  ROG dept.       

Highlighted
It’s a tricky one for me. I’d like them to update together. Even thinking of getting a pro to do all the coding. Maybe it’s simple enough for them.