VBA Index Match type function

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

option for the button on Sheet1 code:

Sub test()

On Error Resume Next
Sheets(2).UsedRange.Find(Range("b1"), , xlValues, xlWhole).Offset(, Application.Match(Range("b4"), Sheets(2).Rows(1), 0) - 2).Resize(4).Value = Application.Transpose(Range("d9:g9"))

End Sub

Hi,

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

Thanks

Hi,

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

Thanks