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.
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.