Home

Formula or Function help

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