Re: [Summary-Talk] Excel macros

[Jason Linhart <jason@xxxxxxxxxxx>]

That is why I suggested importing the report to a different sheet in
your workbook. You can then write some simple formulas to copy over only
the columns you are interested in and the formatting in the primary
sheet will not be affected.

Also, are you using the reports in Excel format? Importing HTML versions
of the reports is far more likely to affect the formatting than when you
are using the Excel versions.

Excel is incredibly powerful and just about any kind of formatting is
possible in Excel with enough work. You might want to ask an Excel
expert or Excel users forum for more detailed advice on using Excel as
that is really outside the subject area of this list.

Jason


Donald Radlund wrote:
> Ok I got it bringing in the data perfectly but now I want to keep my
> formatting in the excel file. How do I do that or am I just SOL? Is there a
> way to only select certain columns to import or would I have to set up my
> report to only give me those columns?

-- 
Jason@xxxxxxxxxxx
--
Dr. Seuss books . . . can be read and enjoyed on several levels. For
example, 'One Fish Two Fish, Red Fish Blue Fish' can be deconstructed
as a searing indictment of the narrow-minded binary counting system.
   -- Peter van der Linden, Expert C Programming, Deep C Secrets
-------------
Go to <http://summary.net/list.html> to update subscription info.