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

@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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies