Data extraction using a a cell reference

[Noushad Vaidyar]

Hello

I have a canteen attendance sheet which will be marked with "x"for the corresponding date if the Staff Member has utilized the facility irrespective of actual consumption the fixed menu charges are applied and the canteen operator has to send a daily report as in the attached sheet.
A maximum of 20 Staff will use the facility on any given date
I would like to generate a PDF report and mail it to the finance from the given work book. What is the VBA code ?

What is the excel formula to get data based on date cell -" H3"

Please help

Noushad

[newdoverman]

This doesn't use VBA but it should get you started. The attendees are taken from the Attendance sheet where an X is filled in for the date. The X is also entered in column H of the same worksheet. You can probably record a macro to blank the meals data and then fill in what each person had.

The macro if you record it will look something like this:

Please Login or Register  to view this content.

[Noushad Vaidyar]

Hello newdoverman
Thanks for the VBA code.
It clears the meals from the cells. But that is not the purpose.
By entering the day number in H3 , I should be able to populate the data in the "Daily Report" sheet.
For instance on if the date is 8 th , H3 will have "8" and all "X" marked in "Attendance" sheet O3:O27 should be brought to the Daily Report sheet along with corresponding data A3:G27 in attendance sheet. May be Index or ISNA function ?
Regds
Noushad

[newdoverman]

That isn't a problem except that someone going to a canteen would have exactly the same thing every time. That is very unlikely. This file version will however do as you ask.