Bulk update with cell references?

[Adam_P]

Hi all,

My first question on here - so go easy!

I have a sheet with over a million data elements (1000s of rows by around 100 columns).

I've been given another sheet with the references of the exact cells that need updating, along with the new data that needs to go in to those cells. i.e.

[TABLE="width: 215"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 215"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]C28[/TD]
[TD]new data 1[/TD]
[/TR]
[TR]
[TD]D55[/TD]
[TD]new data 2[/TD]
[/TR]
[TR]
[TD]CD2029[/TD]
[TD]new data 3[/TD]
[/TR]
[TR]
[TD]AA2022[/TD]
[TD]new data 4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Is there a way to update each of those specific cells with the new data? If there was a small population of changes i'd do it by hand, but unfortunately changes often run in to hundreds at a time.

Please help!

 

[Fluff]

Hi & welcome to the board.
How about

Sub UpdateData()
   Dim Cl As Range
   
   For Each Cl In Range("A1", Range("A" & Rows.count).End(xlUp))
      Sheets("[COLOR=#ff0000]Data[/COLOR]").Range(Cl.Value).Value = Cl.Offset(, 1).Value
   Next Cl
End Sub

Change sheet name to suit.
The sheet with the updates needs to be active when you run this.
Assumed the the cell ranges are in col A with update in col B

 

[Adam_P]

Thanks so much!! - IT works a treat!

Is there a way I can tip you a coffee or something? You literally saved me hours!

 

[Fluff]

Glad to help & thanks for the feedback.

Is there a way I can tip you a coffee or something?

You just have