Index/Match formula into VBA code

[Justmegan93]

Hi I currently use the following formula;
=IFERROR(INDEX(Table5,MATCH(1,(Table5[Date]=$D$288)*(Table5[Pay No.]=G2),0),13),0)

Which checks a table on a different page for the matching day and employee's pay number and pastes their start time into the cell

This seems to work but I have to translate it into vba code as I would like to add more to it
I think this would work best as a function so I could change the dates and pay no.

Can anyone help ?
I am a still quite new to VBA

[Norie]

Formulas can't paste into cells.

How/where exactly are you using that formula?

Also, what more do you want to add?

[Justmegan93]

The formula is in the cell which I want to show the employees start time

I currently have a tab of all employees start/finish times ect. which is updated daily and I want to paste the start times into a separate master tab to save time manually entering the times every day

I use the formula (ABOVE) to paste the start times but if the times are marked red I also want this to show on the master tab.

[Norie]

So what do you actually want to do in code?

If all you wanted to do was to get the result of the formula you could use Evaluate.

Please Login or Register  to view this content.

You could then put the result into a cell on the master sheet.

Please Login or Register  to view this content.

[Justmegan93]

Thank you this works, although is there a way to replace the cell references with the ranges

So $D$288 would be RDate
and U2 would be RPay ?

Please Login or Register  to view this content.