• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match data on source and destination sheet and change value

C

Cammandk

Member
I have extracted data from multiple sheets and now want to mark this data as "Paid" and for the macro to go back and change the value in the original sheet on a row in column "AR" to "PAID.
All the columns have the same data type in.

The extracted data contains the original sheet name and each row has a unique ID No to it.

I know I probably need to use INDEX and MATCH and then Offset to post value.

Attached worksheet shows the data and columns.

Thanks
DK
 

Attachments

  • ExtractedData Paids.xlsx
    10.9 KB · Views: 9
You must log in or register to reply here.
Back
Top