• 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.

Update Values in a table based on specific values

1981gkr

New Member
Hi All,

What im trying to do is build a copy and paste macro, using a loop, match and offset.

Basically in the Update sheet.

I have a table where a user will update values

ABCDE
1PrimaryKeyLineNew Value 1New Value 2UpdateValue
2XY.11ABCD12341
3XY.22ZXCV98761
4

What i need this macro to do is the following.

1. Search Sheet2(Table1[PrimaryKey]) and match based on cell A2 value
2. Copy value in C2 in Sheet 1(eg ABCD)
3. Paste.Values in Lx (where x =row id found in step 1)
4. Copy value in CD in Sheet 1(eg 1234)
5. Paste.Values in Ox (where x =row id found in step 1)
6. Paste today() in Wx
7. Loop for all cells where Column E = 1

Hopefully this is clear.

Cheers
 
Top