trying to create a report

Originally Posted by BudS

I have a library check in/out program. One colum has days an item has been checked out. I am trying to create a report in a seperate sheet, that gets all items that are overdue (60 days) and puts them in the report sheet. The colums are A. item# B. Book Title C. Author D. Checkout Date E. Library Card# F. Library Patron's Name G. Days Checked out.
The report only needs to have the info from colums B,F & G. I am at a loss as to how to make this happen. Can anyone help me?


Bud S

Hi,

One possibility, record a Macro which clears a spare sheet, applies a formula to the current sheet to show, for outstanding items, the days overdue (ie, checked-in = "" AND Today() - checked-out >= 60), Filter on that column, copy and Paste to the spare sheet, hide the columns not required on the report, and print.
Make any other adjustments and Print etc.

Stop recording, and see how that fares.

Be interested to see how you go,.
---

Originally Posted by BudS

Thanks Bryan,

I never gave the macro idea a thought. I recorded a macro, did a little tweeking, put an update button on the reoprt sheet, and it works great. I recorded a seperate macro for printing and also put a print button on the sheet.

Bud S

Great thoughts, and glad to see that it works for you.

Thanks for your response.

---