report creation

Hi all I'm trying to automate a monthly report and all the information I need is presented within a pivot table. The pivot table contains two columns, A is Customer, B is value. The pivot table has an additional row within the customer to subdivide them into categories. Essentially i'd like to...

I have software that generates an excel sheet of 62 columns and up to 65525 rows. In one of the columns the occurrence of failures (In-Fault / No-fault) is reported. I search in that row where I reported the failure column time and marked the previous row to this time and the time row of the...

My healthcare facility currently used a shared, password protected spreadsheet to schedule procedures for physicians. Is there a way I can create a user-generated report (basically a daily schedule) from the spreadsheet? I've attempted to link data to another workbook and/or create a linked...

Hi all, I'm making some changes to the images that go out on certain reports. I have a report that is tied to a combobox of client ID's and produces a single report but has an image I want to change. I need to produce a second report, with a different logo, if the client ID is equal to one of...

Dear community, I am pretty new to the world of VBA! I am currently working on an assignment and I would like to produce a regular report out of my analysis so that I can keep tracks of the changes. I would only like the report to look natural instead of being ckearly generated by a computer...

Morning all, I've been using a great piece of code given generously on this forum, however the structure of the file has now changed and Ive altered the code but the script keeps giving runtime errors. The file has the following user input cells: F1 = Date from H1 = Date to (so the user can...

Hi All, I am relatively new at creating programs for excel in VBA. I created the attached spreadsheet program for my company and wanted some input on how (if possible) this program could be written more efficiently to decrease file size and increase quickness. Thank you so much for your...