Need auto update

%3CLINGO-SUB%20id%3D%22lingo-sub-2955413%22%20slang%3D%22en-US%22%3ENeed%20auto%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955413%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Team%2C%3C%2FP%3E%3CP%3ECan%20any%20one%20help%20me%20here%20I%20have%20attached%20a%20spreedsheet%20Where%20I%20have%20multiple%20sheets%2C%20and%20one%20main%20sheet%20when%20I%20update%20in%20that%20sheet%20it%20should%20automatically%20update%20in%20the%20K%20Coulomn%20of%20required%20sheets%20with%20same%20Date.%20Please%20help%2C%20Thanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2955413%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-2955826%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20auto%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1215484%22%20target%3D%22_blank%22%3E%40Shanmukhvarun%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDIRECT(ADDRESS(2%2CROW(B2)%2C%2C%2C%22Rawsheet%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20this%20formula%20for%20Sheet1%20and%20it%20seems%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Team,

Can any one help me here I have attached a spreedsheet Where I have multiple sheets, and one main sheet when I update in that sheet it should automatically update in the K Coulomn of required sheets with same Date. Please help, Thanks in advance

2 Replies

@Shanmukhvarun 

=INDIRECT(ADDRESS(2,ROW(B2),,,"Rawsheet"))

 

I tried this formula for Sheet1 and it seems to work.

@Shanmukhvarun so it depends on which sheets you will enter the information.  based on your description you are entering on the Rawsheet tab so the basic formula would be:

cell K3 on sheet1 would be ='Rawsheet'!B2

cell K4 would be =Rawsheet!C2

and so on

If you have Excel 365 here is an array formula that fills in the whole column:

=INDEX(Rawsheet!1:999,MATCH("Sheet"&(SHEET()-1),Rawsheet!A:A,0),MATCH($A3:$A33,Rawsheet!1:1,0))

it assumes the sheets are inserted/added in order and named Sheet1, Sheet2, etc...

here is the same for an older version of excel but will need to be filled/copied down the column:

=INDEX(Rawsheet!$1:$999,MATCH("Sheet"&(SHEET()-1),Rawsheet!$A:$A,0),MATCH($A3,Rawsheet!$1:$1,0))

Note, you can highlight multiple tabs and when you enter formula(s) into a particular cell on 1 tab it will be entered into the same cell on EVERY other tab that is highlighted.