Here is a screenshot of what I'm working on. I thought the visual may
help explain what I'm trying to do.

On the left I have the pupils names and then next to each name their
attendance and marks.

However, as you can see I only have a few columns available and if I
want to insert additional columns I have to go through the procedure of
selecting where the columns should be inserted, insertting them and then
formatting them to match the layout. This is what I want to automate
using a macro.

However, when the macro is run will it insert the columns from the
current active cell? Or will it run and insert the columns according to
whichever cell was selected when the macro was recorded? If this is the
case I will be unable to continue adding new columns to the right of
the data.

Any help would be great....bearing in mind that I'm a complete novice
with macros!

Thanks,

Mark.


+-------------------------------------------------------------------+
|Filename: screenshotnew.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4078 |
+-------------------------------------------------------------------+

--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488798