actually, btna, you don't even have to open a new workbook & paste the
code.
just insert a new worksheet
while on the NEW worksheet,
Tools, Macro, Macros
& choose the one you just recorded
the new worksheet will now be formatted the way you did the previous
one.
worked for me
hope this helps!
susan



On Apr 27, 3:47 pm, Susan wrote:
one of the best ways to learn to do what you want is..........

start a new, blank workbook
up in the toolbar, choose Tools, Macro, RecordNewMacro
save the macro in "this workbook"
then go thru the workbook & format everything the way you want it
column widths, coloring, putting in the formulas @ the top of the
headers: =sum(b2:b25) etc.
then stop the macro recorder
up in the toolbar, choose Tools, Macro, Visual Basic Editor
this will open up a new window, where the code you just recorded will
be written - look in Module1.
recording code is not the most efficient code, but it works & is good
to help you learn.

copy the entire code
open a new workbook
open the VB editor in the new workbook
paste the code in a new module (up in the top VB editor toolbar use
Insert, Module)
close the old workbook
VB editor toolbar = Run, Run Macro
look @ your new workbook - is it formatted the same way as the first
one?

:)
susan

On Apr 27, 2:47 pm, BTNA wrote:



Hi all,

I am looking for resources where I can quickly learn some basic
programming with Excel. If this is not the right group to ask this
question, please let me know. I am basically looking to create nice
reports out of a flat file with columns. I don't need it to be too
fancy but I need to be able to create nice columns with some nice
formatting. My flat file would look like:

header1;header2;header3
0;1;2
0;4;5
0;3;5

1;3;4
1;2;6
1;5;6
2;5;6

2;8;9

Header1 will alwys be either 0,1,2 and I would need to be able to sum
the second and third columns for each header1 and so on.

Can you point me to a good easy book and or web page resource where I
can learn to do this?

Thanks in advance,

BTNA- Hide quoted text -

- Show quoted text -