Copying rows of data between worksheets

Highlighted
New Contributor

I have three worksheets of data that I need to combine into one worksheet based on the data in column A, the ID column. In my example, If there's an ID row with data in worksheet 2016, those 4 rows of data need to be copied over into the 2016 section of the Combined worksheet. I think I can do this with vlookup, but I'm not sure how to tell Excel to copy the entire row over as opposed to just one cell. I need to do this for every year sheet.

 

Thanks for any guidance!

1 Reply
Highlighted

@michelle_sc98 , apply VLOOKUP or INDEX/MATCH to every cell in the row