Home

Formula or Function help

%3CLINGO-SUB%20id%3D%22lingo-sub-774459%22%20slang%3D%22en-US%22%3EFormula%20or%20Function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774459%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20building%20a%20database%20of%20environmental%20information.%26nbsp%3B%20I%20have%2024%20hour%20values%2C%20that%20I%20condense%20into%20Max%2C%20Min%2C%20Ave%20Daily%20values%20(all%20positive%20numbers)%20which%20are%20then%20copied%20from%20one%20sheet(1)%20into%20another%20sheet(2).%26nbsp%3B%20What%20function%20can%20I%20use%20to%20make%20the%20copied%20cells%20on%20sheet%20(2)%20automatically%20change%20when%20I%20make%20changes%20to%20the%20original%20cells%20on%20sheet(1)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20specifically%2C%20I%20have%20570%20cells%20on%20sheet(1)%20that%20have%20the%20formula%20%5B%3DL24%2B(K25*G25)%2C%20%3DL48%2B(K49*G49)%2C%20%3DL72%2B(K73*G73)%2C%20%E2%80%A6..%5D%20etc.%20etc.%20Notice%20they%20are%20skipping%20down%20the%20sheet%20by%2024s.%20They%20then%20shift%20to%20the%20next%20year%20which%20starts%20at%20%5B%3DX24%2B(W25*S25)%2C%20%3DAJ24%2B(AI25*AE25)%2C%20and%20so%20on%20and%20so%20forth.%26nbsp%3B%20These%20are%20skipping%20to%20the%20right%20by%2012%20letters.%26nbsp%3B%20I%20have%20been%20holding%20the%20CTRL%20key%20and%20selecting%20all%20570%20cells%2C%20then%20copying%20and%20pasting%20these%20onto%20a%20new%20sheet(2).%26nbsp%3B%20However%2C%20if%20I%20make%20edits%20to%20sheet%20(1)%20the%20only%20way%20for%20me%20to%20know%20which%20cells%20were%20changed%20is%20to%20recopy%20and%20paste.%26nbsp%3B%20Is%20there%20a%20better%20way%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-774459%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774570%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20or%20Function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382440%22%20target%3D%22_blank%22%3E%40biancaisla1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20should%20be%20able%20to%20achieve%20this%20using%20indirect()%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20provide%20a%20better%20solution%2C%20it%20would%20help%20if%20you%20can%20upload%20a%20sample%20data%20with%20formulae.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
biancaisla1
Occasional Visitor

Hello there,

 

I am working on building a database of environmental information.  I have 24 hour values, that I condense into Max, Min, Ave Daily values (all positive numbers) which are then copied from one sheet(1) into another sheet(2).  What function can I use to make the copied cells on sheet (2) automatically change when I make changes to the original cells on sheet(1)? 

 

More specifically, I have 570 cells on sheet(1) that have the formula [=L24+(K25*G25), =L48+(K49*G49), =L72+(K73*G73), …..] etc. etc. Notice they are skipping down the sheet by 24s. They then shift to the next year which starts at [=X24+(W25*S25), =AJ24+(AI25*AE25), and so on and so forth.  These are skipping to the right by 12 letters.  I have been holding the CTRL key and selecting all 570 cells, then copying and pasting these onto a new sheet(2).  However, if I make edits to sheet (1) the only way for me to know which cells were changed is to recopy and paste.  Is there a better way?

1 Reply
Highlighted

@biancaisla1 

I think you should be able to achieve this using indirect() formula. 

To provide a better solution, it would help if you can upload a sample data with formulae.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies