Log in

View Full Version : Formating a Report



jimbob
11-20-2008, 09:13 AM
Hello

I am stuck working on a macro where I take a report from the web and try to clean out all un-wanted data, and sort it by the data that is need to exclude all blank characters.

Couple of problems -- this report is always different from Day to Day so I can not use specific cells as it will not work this way from one day to the next. Also it is a sectional report with the headers repeating over and over. I can get it to work for the first section but then it dies out on the other sections.

I can paste the report and the worksheet if needed.

Any help is appreciated.

Jimbob.

stanleydgrom
11-20-2008, 08:17 PM
Jimbob,

Welcome to tbe 'vbax board.

Please post a sample workbook - see "Manage Attachments".


Have a great day,
Stan

rbrhodes
11-20-2008, 10:17 PM
hi jimbob,

A sample would help the helpers for sure!

jimbob
11-21-2008, 10:47 AM
Okay sorry about that -- I have attached a test of the file and instructions on what I am looking to do -- I really appreciate all the help

stanleydgrom
11-24-2008, 04:31 PM
jimbob,

It would help if you could manually complete sheet "Terminal" from "Raw Data".

Then post another example workbook.


Have a great day,
Stan

rbrhodes
11-25-2008, 12:19 PM
Didn't I post this?

jimbob
11-26-2008, 11:43 AM
Sorry guys here is my work book with the results attached

I have listed what I was trying to do on one tab -- my current results on another and what I am looking for on one more.

I appreciate all feed back and help in this matter.