excel loop to copy data from sheet 1 to sheet 2 based on matches

[vpan]

hi all, returning here after quite some time and as a result of not having coded in VBA for 4-5 years, ive seemed to have lost a lot of my prior basic coding knowledge... hoping this will help jog my memory

I have two tables where i am trying to copy data from one sheet to another based on matches

Table1:

Col A Col B Col C Co D Col E
Company Name Week1Data Week2Data Week3Data Week4Data

XYZ 22% 15% 43% 55%
ABC 25% 63% 36% 83%


Table2:

ColA ColB ColC
Company Name Week% Week Reference

XYZ 22% Week1Data
XYZ 15% Week2Data
XYZ 43% Week3Data
XYZ 55% Week4Data
ABC 25% Week1Data
ABC 63% Week2Data
ABC 36% Week3Data
ABC 83% Week4Data


How can i copy the % from table2 to populate the week1-week4 %s based on the company name and week reference into Table1 via some sort of loop?

Thanks!

[maniacb]

Welcome back to the forum!

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

That being said, you may be able to do this with a formula, match-index combination formula comes to mind.