Updating a List of Cells Based on Locations With a List of New Values

%3CLINGO-SUB%20id%3D%22lingo-sub-1331012%22%20slang%3D%22en-US%22%3EUpdating%20a%20List%20of%20Cells%20Based%20on%20Locations%20With%20a%20List%20of%20New%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331012%22%20slang%3D%22en-US%22%3E%3CP%3EI%20typically%20have%20to%20update%20a%20set%20of%20cells%20with%20a%20new%20value.%20I%20know%20the%20location%20of%20the%20cells%20I%20would%20like%20to%20update%20and%20also%20the%20new%20value.%20What%20could%20be%20an%20appropriate%20way%20to%20update%20a%20large%20set%20of%20cells%20with%20their%20new%20respective%20values%20quickly%3F%26nbsp%3B%20I've%20tried%20looking%20around%20and%20I%20would%20like%20to%20have%20the%20masterworkbook%20formula%20free.%20In%20short%20update%20a%20sheet%20based%20on%20a%20list%20of%20Cell%20locations%20with%20a%20new%20value%20which%20is%20located%20within%20another%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3C%2FP%3E%3CP%3EI%20would%20like%20to%20update%20cell%20K76001%20from%20its%20current%20value%20of%20%245.00%20to%20%2410%2C000.97%20based%20on%20a%20large%20list%20with%20the%20location%20K~~~~%2C%20and%20new%20value%20%24%20then%20cell%20K4200%20%2410%2C000.00%20to%20%2410%2C005.06%26nbsp%3B%20ETC.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1331012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1331032%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20List%20of%20Cells%20Based%20on%20Locations%20With%20a%20List%20of%20New%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331032%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F633658%22%20target%3D%22_blank%22%3E%40ErikMrll%3C%2FA%3E%26nbsp%3B%20Is%20there%20a%20reason%20for%20the%20change%20in%20the%20value%3F%20For%20example%2C%20is%20it%20due%20to%20a%20new%20report%20being%20generated%20or%20there%20is%20an%20update%3F%20Also%2C%20how%20often%20do%20you%20make%20the%20changes%3F%20Is%20the%20value%20you%20are%20changing%20getting%20its%20data%20from%20the%20sheet%20in%20the%20same%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%20can%20show%20us%20some%20examples%2C%20so%20we%20can%20follow%20better.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1331049%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20List%20of%20Cells%20Based%20on%20Locations%20With%20a%20List%20of%20New%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20the%20time%20to%20look%20into%20my%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20the%20cell%20needs%20to%20be%20updated%20is%20the%20workbook%20itself%20is%20a%20master%20record.%20However%20as%20new%20data%20if%20found%20the%20value%20within%20the%20maser%20record%20needs%20to%20be%20up%20to%20date.%20The%20master%20record%20does%20not%20have%20any%20formulas%2C%20it%20does%20not%20pull%20data%20from%20any%20other%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cell%20is%20that%20is%20being%20updated%20is%20a%20running%20total%20of%20money%20that%20is%20being%20determined%20within%20another%20sheet.%20The%20secondary%20sheet%20is%20not%20within%20the%20same%20workbook%2C%20it%20looks%20at%20the%20master%20record%20and%20adds%20the%20update%20with%20the%20value%20that%20is%20within%20the%20master%20record%20currently.%20The%20value%20added%20is%20determined%20in%20various%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%20frequency%20is%20daily.%20The%20Cell%20being%20updated%20is%20not%20known%20until%20the%20next%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20my%20question%20is%20there%20a%20way%20to%20update%20a%20list%20of%20cells%20within%20excel%20in%20this%20fashion%20or%20would%20there%20be%20some%20alternative%20method%20to%20update%20this%20large%20list%20other%20than%20manually%20updating%20the%20master%20record%20which%20has%20no%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaster%20Record%3C%2FP%3E%3CP%3E(Total%20would%20be%20Column%20K)%3C%2FP%3E%3CTABLE%20width%3D%22273%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22143px%22%3EMasterRecordDate%3C%2FTD%3E%3CTD%20width%3D%22125px%22%3EMasterRecordID%3C%2FTD%3E%3CTD%20width%3D%2247px%22%3ETotal%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22143px%22%3E4%2F22%2F2020%3C%2FTD%3E%3CTD%20width%3D%22125px%22%3E123456%3C%2FTD%3E%3CTD%20width%3D%2247px%22%3E100%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecondary%20Sheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22329px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2272px%22%3ELocation%3C%2FTD%3E%3CTD%20width%3D%22257px%22%3E%26nbsp%3BValue%20to%20be%20added%20to%20master%20record%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%3EK62136%3C%2FTD%3E%3CTD%20width%3D%22257px%22%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20351.13%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%3EK74867%3C%2FTD%3E%3CTD%20width%3D%22257px%22%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2040.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%3EK73696%3C%2FTD%3E%3CTD%20width%3D%22257px%22%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2040.00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1331095%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20List%20of%20Cells%20Based%20on%20Locations%20With%20a%20List%20of%20New%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F633658%22%20target%3D%22_blank%22%3E%40ErikMrll%3C%2FA%3E%26nbsp%3Bis%20it%20possible%20to%20link%20your%20master%20sheet%20to%20those%20secondary%20sheets%20so%20that%20the%20updated%20information%20are%20automatically%20fed%20into%20the%20master%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1331265%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20List%20of%20Cells%20Based%20on%20Locations%20With%20a%20List%20of%20New%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eunfortunately%20that%20wouldn't%20be%20possible%20to%20share%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I typically have to update a set of cells with a new value. I know the location of the cells I would like to update and also the new value. What could be an appropriate way to update a large set of cells with their new respective values quickly?  I've tried looking around and I would like to have the masterworkbook formula free. In short update a sheet based on a list of Cell locations with a new value which is located within another sheet.

 

Ex

I would like to update cell K76001 from its current value of $5.00 to $10,000.97 based on a large list with the location K~~~~, and new value $ then cell K4200 $10,000.00 to $10,005.06  ETC.

 

 

Any help would be much appreciated.

4 Replies

@ErikMrll  Is there a reason for the change in the value? For example, is it due to a new report being generated or there is an update? Also, how often do you make the changes? Is the value you are changing getting its data from the sheet in the same workbook?

 

Maybe you can show us some examples, so we can follow better. 

@wumolad 

 

Thanks for taking the time to look into my question.

 

The reason the cell needs to be updated is the workbook itself is a master record. However as new data if found the value within the maser record needs to be up to date. The master record does not have any formulas, it does not pull data from any other sheet.

 

The cell is that is being updated is a running total of money that is being determined within another sheet. The secondary sheet is not within the same workbook, it looks at the master record and adds the update with the value that is within the master record currently. The value added is determined in various sheets.

 

Update frequency is daily. The Cell being updated is not known until the next day.

 

I guess my question is there a way to update a list of cells within excel in this fashion or would there be some alternative method to update this large list other than manually updating the master record which has no formulas.

 

Master Record

(Total would be Column K)

MasterRecordDateMasterRecordIDTotal
4/22/2020123456100

 

Secondary Sheet

 

Location Value to be added to master record 
K62136 $                                                   351.13
K74867 $                                                      40.00
K73696 $                                                      40.00

@ErikMrll is it possible to link your master sheet to those secondary sheets so that the updated information are automatically fed into the master sheet?

@wumolad 

 

 

unfortunately that wouldn't be possible to share