Find Excel Row Number

[DMT Dave]

Hi guys, is there a way of updating records on an existing excel worksheet from a recordset but each row in Excel has got the same detail as my recordset ? ie;

Excel column (1)
Row 22 is SO-123
Row 19 is SO-345

Row 37 is SO-678

Row 14 is SO-890

Excel column (6) (delivery Date)
Row 22 = 02/01/19 (SO-123 taken from my recordset)

Row 19 = 03/01/19 (SO-345 taken from my recordset)

recordset finds the SO number row and adds the delivery date taken from recordset ?

Is this easy to achieve ?

Would I need to add a check box to database and tick each SO number to find the Excel row ? as I may need to update 30 per day ?

Or can I loop through and still update the relevant excel row with one click ?



Thanks in advance

[June7]

Can probably use Find to activate row.

Loop through recordset, Find row, set cell value.

Use macro recorder to generate some VBA for the Find. Modify code as needed.