VBA Index Match type function

[Simon.xlsx]

Hi All,

I have a Spreadsheet I would like to copy some cell values from 1 sheet and paste into another sheet

However where it is to paste the information, depends on 2 cell values on sheet 1, the employee name, and the date.

So I need the code to look at the cell on sheet 1 with the employee name, and look for that value in column A of sheet 2. That will return the initial row where I want to paste.

But I also need it to look at the cell on sheet 1 with the date selected, and look for that value in Row 1 of sheet 2, thus returning the Column of where I want to paste

This will hopefully give a cell to paste into. I've attached an Example workbook to help try make sense. The Values I want to copy are Sheet 1 D9:G9, and the paste on sheet 2 depending on the above criteria

However the 4 values will be pasted down the way; ex. B2:B5

Hope somebody can help with this issue, Im not the worst at VBA but would still be a noob

[JosephP]

maybe

Please Login or Register  to view this content.

[watersev]

option for the button on Sheet1 code:

Please Login or Register  to view this content.

[Simon.xlsx]

Hi,

Sorry about the slow reply, was travelling. Those codes worked a treat. Rep added

Thanks

[Simon.xlsx]

Hi,

Sorry about the slow reply, was travelling. Those codes worked a treat. Rep added

Thanks