Load, aim, update! - Matching records and updating

[Flick]

I'm incredibly new to VBA and struggling to find a code online that'll help implement my idea.

I have records in sheet1 with ID's in column A, and at the end of the record I wish to add a button that says "Complete".
In sheet2, it contains the same records (sheet1 contains a list of records not complete), so I want this button to match the ID from sheet1 with the same ID in sheet2, then mark the cell in column I in sheet2 as "Complete".

It sounds very simple, but I can't quite get my head around VBA just yet! Your help would be much appreciated.

 

[Somendra Misra]

Hi Flick,

Can you upload your sample file, with say 10-20 lines of data of both the status.

Regards,

 

[Flick]

Hi Flick,

Can you upload your sample file, with say 10-20 lines of data of both the status.

Regards,

Here you are! Thanks.

 

[Somendra Misra]

Hi Flick,

Can you put a check box in front of each row marked as complete and a single button to mark on Sheet2?

Regards,

 

[Flick]

You mean, if I tick each complete task on sheet1, the button on sheet2 will then mark the corresponding record as complete?

 

[Somendra Misra]

No right now you have placed a button on each row on Sheet1, replace those button with a check box marked as complete on sheet1 and place a single button on sheet1, so when this button will be pressed it will mark all the id's on sheet2 as complete which are ticked on sheet1.

I hope this make sense.

regards,

 

[Flick]

That makes sense, I thought you wanted the button on sheet2, I misunderstood.

Like this, you mean?

 

[Somendra Misra]

@Flick

See the file, you need to make certain changes on formulas on column A of both sheets.

Regards,

 

[Flick]

This is beautiful! Thank you very much.