Hi,
I have reports I do that are output as csv type. I then must do quite a bit
of formatting and then copy the data into a template.An example of what I
do: Open csv in excel, in col a replace all 2's & 3's with text (same word)
and replace 5's with a different word. col A contains ONLY one of these 3
numbers. then I format 4 cols as $, 2 as numbers. I then sort descending by
col A, ascending by Col B. Their are a few more things but all have to do
with formatting and/or sorting.Can something like this be automated with a
macro or something?
Thanks
Frank