That sounds like a great idea. I'll try it and let you know.

"Michael" wrote:

Is it possible to try pasting the original data onto a worksheet and then
having a second worksheet that picks up the relevant data through various
formulae. Then each month just overwrite the original data sheet and the
formulawe should still work?

"Ray S." wrote:

There is one set of data I process monthly in Excel that becomes very
tedious. First, the source is from a Crystal report accessible to me through
a web link. I can export the report data to either Excel or as a pdf. The
latter is pretty useless for processing, but the Excel export always requires
me to unmerge and unwrap the cell formatting; then I have to delete rows, cut
and paste headings, and change one row to text formatting to retain leading
zeros in apparently numeric data. I always wind up having to do what we call
the "monkey maneuver" - copying and pasting row data into Notepad and
re-pasting it into the cells. Is there a way to "automate" the tedious and
repetitive tasks? I thought of using macros, but the amount of data always
changes. I'd appreciate any help on this. I'm pretty good with VBA coding in
Access, but almost never code in Excel.