Adding/Deleting rows, columns, and more automatically.

BlondOIverBlue,

Welcome to the Excel Forum.

Thanks for the workbook.

Please attach another workbook or a sample workbook that accurately portrays your current workbook raw data on one sheet, and what it should look like 'After' on another sheet. This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

BlondOIverBlue,

I assume that your raw data is already sorted/grouped by Tech.

Detach/open workbook BlondOIverBlue - EF744797 - SDG13.xls and run macro CreateReport.

The macro will create a new worksheet Report.

BlondOIverBlue,

Detach/open workbook BlondOIverBlue - EF744797 - V2 - SDG13.xls and run macro CreateReportV2.

BlondOIverBlue,

You are very welcome.

Come back anytime.

For my own personal information: How much time in hours do you think my macro will save you per day/week/month?

Stan:

Honestly, the what the macro saves in frustration alone is immeasurable. You wouldn't believe how the report was generated before, manually. If you need an actual figure, it'll save 4.5 hours a week or about 18 hours a month. The biggest benefit is the report can be released on-time at the start of the day versus hours later; by the time it got out, it was afternoon, defeating the idea of a "Morning Report".

BlondOIverBlue,

Detach/open workbook BlondOIverBlue - EF744797 - V3 - SDG13.xls and run macro CreateReportV3.

I'm back. I wasn't sure whether to open a new thread or reuse this one.

I'm faced with a new challenge. I hope I can explain this without too much confusion.

I'm switching from a morning report to an End of Day (EOD) Report. I'd like to have daily EOD Report tabs with the date of each report like this: EOD Report - 10-08-2010 at the bottom.

However, I need to add some more data which come off the default tabs, mainly the R&D Jobs tab (I renamed it in the example sheet that is attached to NEW EOD Report - 10-08-2010)

When I run the CreateReportV3 macro, I need the following done:

• Add columns "First Name" and "Last Name" from R&D Technicians tab to R&D Jobs tab in between "Tech" and "Job Id"

• Add calculations for "Total Units" for each tech

• Add calculations for "Total Hours" for each tech

- Based on lowest "Start Time" and highest "End Time"

• Add calculations for "Units per Hour" for each tech

• Resize columns to fit

• Delete the following columns: Zip Code, JS, DS, RteC, Reason, EST, ETA, Time ETA Entered, Company

• Format text using "Center Text" and "Middle Align"

• Freeze rows 1, 2, 3, 4 so header info shows when scrolling.

• Rename the R&D Jobs tab to EOD Report - 10-08-2010 (or the current date the report is being run)

Now, the big question is the creation of the Week ending 10-16-2010 tab.

Is it even possible to have that tab auto-update as each daily report is run? It's going to be a pain already having to run the daily reports, run the macro, and paste each new daily EOD into the template.

The software I glean the raw data from only opens Excel as a new separate file, so that's why I have to keep that part manual, unfortunately. Ultimately, I am trying to keep manual data entry down to a nominal minimum if I can.

Attached is the file, with the macro, as how I envision it, minus the highlighted columns. The highlight can be removed. I hope I made some sort of logical sense here. I apologize if not and will clarify any and all questions.

I also uploaded a file straight from the software program so it's easier to see what the actual data look like pre-macros or other editing.

BlondOIverBlue,

I have exceeded the normal amount of time I allocate for solving problems/requests on web sites like Excel Forum.

Your requirements are quite complicated, but doable.

I would suggest that you start a completely new post with a new title, and someone else will assist you.