Gingertrees
12-11-2009, 02:42 PM
I get reports from our state database with long annoying irrelevant column headers. Can I have a routine that goes through and changes A1 from
"Long_annoying_header_321_other_uselessness"
into
"Employee"
B1 from
"Another_annoying_one"
into
"date"
etc. (There's 10 columns I'd like to change; the headers are always worded the exact same way.)
I already cooked up a little subroutine to trim out extra garbage, so I was wondering if I could just add that in.
"Long_annoying_header_321_other_uselessness"
into
"Employee"
B1 from
"Another_annoying_one"
into
"date"
etc. (There's 10 columns I'd like to change; the headers are always worded the exact same way.)
I already cooked up a little subroutine to trim out extra garbage, so I was wondering if I could just add that in.