Home

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

@Ste_greeny 

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

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

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

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies