Software

Ask something
Discussion Locked

Formatting in Excel using Macros

0 helpful
3 replies

by jena

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am currently on student placement within a company and have been asked to produce reports from their existing Information System which holds sales figures etc. I have to export data from the I.S. into Excel - however much formatting is required each time. Is there some way of doing this automatically? Type of formatting= cell width adjustment etc, as well as calculations / sub-totals...
Thanks.

3 replies

by dklippert

Import your data and then go to Tools>Record Macro
Walk through your formatting and the stop the recorder.
You will now have a macro that will play back your actions.

by theohkm

Hello Jena, it depends on the format of your original data. It is better that you give some example so that we know how to deal with it.

This discussion is closed to new replies.