Macro to update table based on multiple conditions

[Eric111]

The following code looks at a data table ("Emp Data Behav Comp"), matches column ("V3:V7") and row ("U3:U7") and then pastes values from Activesheet range ("W3:W7"). The problem that I can't figure out is that it finds the columns but only pastes the first value from ("W3") into each cell. I need it to post each of the corresponding values("W3:W7") into the appropriate cells.

See attached example.

Test1.xlsx


Any help would be appreciated.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Eric111]

Thanks for reminding me about the code tags, I was in a rush submitting this post.

[Eric111]

I figured out the problem, the following code correctly posts each value to the corresponding column in data table.

Please Login or Register  to view this content.