VB Macro to display data

[rizmomin]

Hello:

Please refer to attachced sheet.

Sheet2 is the employee ClockIn-Clockout info
Each day will have 4 columns and data will start from Cell O46

I would choose the date from drop down list in cell C3.

I need a VB macro to display the data for a chosen date.

I have manually pasted the data for 4/3/2013.

Please let me know if any questions.

Thanks in advance fro your help.


Riz

[ChemistB]

Here's a formula solution. I put the formula results next to your manual ones. So in J4
=INDEX(Sheet2!$O$47:$AL$83,ROW(A1),MATCH($C$3,Sheet2!$O$47:$AL$47,0)+COLUMN(A1)-1)
copied across and down. You may need to reformat some cells the first time.

[Fotis1991]

Hi Riz

Do you want to do this only using macro, or formulas are also ok for you?

[rizmomin]

Hello:

Thank you ChemistB...the formula would work Great.

Love it

Riz