Link multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1560241%22%20slang%3D%22en-US%22%3ELink%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560241%22%20slang%3D%22en-US%22%3EHi%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20excel%20workbook%20which%20has%2060%2B%20sheets.%20For%20reference%20I%20have%20shown%205%20sheets%20in%20that%20I%20have%20a%20common%20word%20in%20column%20A%20say%20name%20%22SAM%22%20in%20all%2060%20sheets%20but%20in%20different%20rows%20in%20different%20sheets.%20Example%20if%20Sam%20name%20is%20there%20in%20A4%20in%20sheet%201%20means%20in%20sheet%202%20it%20might%20in%20A3%20and%20in%20sheet%203%20it%20might%20be%20in%20A2%2Cetc..%3CBR%20%2F%3E%3CBR%20%2F%3EAgainst%20the%20column%20A%20in%20column%20B%20I%20have%20attendance%20value%20like%2050%20in%20sheet%201%2C%2060%20in%20sheet%202%2C%2090%20in%20sheet%203%2Cetc..%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20separate%20sheet%20of%20SAM's%20attendance%20value%20for%20all%2060%20sheet.%20So%20if%20I%20need%20to%20change%20the%20value%20of%20SAM's%20attendance%20in%20all%20sheet%20I%20need%20a%20formula%20by%20which%20I%20can%20make%20a%20change%20in%20single%20sheet%20which%20will%20make%20the%20change%20in%20the%20corresponding%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance%20!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1560241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560248%22%20slang%3D%22de-DE%22%3ESubject%3A%20Link%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560248%22%20slang%3D%22de-DE%22%3EMaybe%20it%20will%20work%20with%20the%20functions%20that%20Excel%20already%20has.%20%3CBR%20%2F%3E%20Go%20to%20%3CBR%20%2F%3E%20Start%20Search%20and%20select%20Search%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20pop-up%20menu%20appears%20with%20search%20and%20replace%20%3CBR%20%2F%3E%20from%20there%20select%20the%20desired%20changes%20and%20enter%20them.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20If%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20Like%20(click%20thumbs%20up)%20and%20as%20%22Best%20Answer%22%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20If%20you%20find%20this%20not%20helpful%2C%20please%20give%20a%20quick%20feedback%20and%20will%20try%20to%20find%20a%20solution%20that%20could%20better%20suit%20you.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560272%22%20slang%3D%22en-US%22%3EBetreff%3A%20Link%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560272%22%20slang%3D%22en-US%22%3EIt%20didnot%20work.%3CBR%20%2F%3EIf%20you%20review%20my%20excel%20I%20have%20a%20summary%20sheet%20.%20In%20that%20I%20need%20summary%20sheet%20B2%20value%20to%20be%20sent%20to%20sheet%201%20B3%20to%20sheet%202%20like%20that.%20Hope%20I%20have%20cleared%20my%20query.%20Please%20check%20and%20help%20me%20with%20a%20solution%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560384%22%20slang%3D%22de-DE%22%3ESubject%3A%20Link%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560384%22%20slang%3D%22de-DE%22%3EFor%20me%20it%20works%20with%20%22search%20and%20find%22.%20The%20only%20thing%20I%20can%20recommend%20is%20to%20start%20a%20repair%20in%20Office%2C%20or%20to%20bring%20the%20PC%20to%20service.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Windows%2010%20%3CBR%20%2F%3E%20Write%20on%20the%20magnifying%20glass%20%3CBR%20%2F%3E%20Control%20Panel%20and%20click%20on%20it%20when%20it%20appears.%20%3CBR%20%2F%3E%20Programs%20and%20features%20%3CBR%20%2F%3E%20Select%20Office%20and%20click%20the%20right%20mouse%20button%20Change%20%3CBR%20%2F%3E%20...%20Wait%20%3CBR%20%2F%3E%20Press%20repair%20It%20takes%20a%20long%20time%20to%20%3CBR%20%2F%3E%20finish%2C%20but%20if%20there%20is%20a%20problem%20in%20Office%20it%20will%20usually%20solve%20it.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20If%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20Like%20(click%20thumbs%20up)%20and%20as%20%22Best%20Answer%22%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560911%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560911%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746661%22%20target%3D%22_blank%22%3E%40Adhi_1%3C%2FA%3E%26nbsp%3BConsider%20gathering%20all%20attendance%20records%20for%20all%20names%20in%20one%20single%20sheet.%20Create%20a%20pivot%20table%2C%20as%20shown%20in%20the%20summary%20sheet%20in%20the%20attached%20example.%20If%20you%20insist%20on%20having%2060%2B%20sheets%2C%20you%20can%20then%20select%20the%20pivot%20table%20option%20%22Show%20Report%20Filter%20Pages...%22%20and%20then%20confirm%20to%20use%20%22Sheetname%22.%20This%20will%20create%20eparate%20pivot%20tables%20for%20each%20sheet%20name.%20I've%20done%20that%20for%20five%20sheets%20in%20my%20example.%26nbsp%3BChange%20a%20number%20in%20the%20summary%2C%20press%20%22Refresh%20all%22%20on%20the%20Data%20ribbon%20and%20all%20tables%20will%20be%20updated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20realise%20that%20you%20actually%20don't%20need%2060%20different%20sheets%2C%20as%20you%20can%20easily%20create%20an%20overview%20for%20the%20sheet%20you%20are%20interested%20in%20from%20the%20overall%20pivot%20table.%20Up%20to%20you%2C%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi ,

I have a excel workbook which has 60+ sheets. For reference I have shown 5 sheets in that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc..

Against the column A in column B I have attendance value like 50 in sheet 1, 60 in sheet 2, 90 in sheet 3,etc..

I have a separate sheet of SAM's attendance value for all 60 sheet. So if I need to change the value of SAM's attendance in all sheet I need a formula by which I can make a change in single sheet which will make the change in the corresponding sheet.

Thanks in advance !
4 Replies
Highlighted
Maybe it will work with the functions that Excel already has.
Go to
Start
Search and select
Search
pop-up menu appears with search and replace
from there select the desired changes and enter them.

If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here. If you find this not helpful, please give a quick feedback and will try to find a solution that could better suit you.

Nikolino
I know I don't know anything (Socrates)
Highlighted
It didnot work.
If you review my excel I have a summary sheet . In that I need summary sheet B2 value to be sent to sheet 1 B3 to sheet 2 like that. Hope I have cleared my query. Please check and help me with a solution
For me it works with "search and find". The only thing I can recommend is to start a repair in Office, or to bring the PC to service.

Windows 10
Write on the magnifying glass
Control Panel and click on it when it appears.
Programs and features
Select Office and click the right mouse button
Change ... wait
Press repair
It takes a long time to finish, but if there is a problem in Office it will usually solve it.

If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here.

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Adhi_1 Consider gathering all attendance records for all names in one single sheet. Create a pivot table, as shown in the summary sheet in the attached example. If you insist on having 60+ sheets, you can then select the pivot table option "Show Report Filter Pages..." and then confirm to use "Sheetname". This will create eparate pivot tables for each sheet name. I've done that for five sheets in my example. Change a number in the summary, press "Refresh all" on the Data ribbon and all tables will be updated.

 

Perhaps you realise that you actually don't need 60 different sheets, as you can easily create an overview for the sheet you are interested in from the overall pivot table. Up to you, though.