Hello all,

I'm hoping you can help me on a commercial project I'm working on.

The first issue I am having is Macro 'Auto Generation' I am trying to create a system whereby a Business User can click on a function called 'Create New User' - On clicking this function it should automatically create a series of personalised workbooks (by name - for eg. JD_Q1_BCS, ZB_Q1_BCS) (There are approximately 15 Worksheets for each user) On clicking on the new function it should also create and format a series of 'navigational functions' on the 'Master Navigation Worksheet' The issue I am currently having with this at the moment is that I can get it to add new data/ format the cells but cannot get it to increment this data over the right and thus currently it keeps overwriting USER's A Data. We are trying to get this finished ASAP so any advice and or guidance on this would be fantastic. A lot of this may sound confusing so I am more than willing to send what we have done so far over to anybody if it helps.

Kind regards,

James

worksheets?
is this an Excel question?
have you considered using a template?

My first advice is to post questions like this in the right forum.

You need a Microsoft Excel forum, not a Microsoft Access forum!

Many thanks.

Unfortunately the Excel Forum Post Submit was not working this morning.

I will re post this as soon as the service becomes available.

As a side note Trekker - You happen to have the worst website I have seen in a very long time indeed! It is truly horrifying. I nearly had an epileptic fit whilst looking your early 90's use of Flash for the 'Grand Presentation' Far too much text, and a background image - Are you actually being serious?

Thanks again,

James

No need to repost, I'll move this one for you

Oh and James, ever heard the saying
?

Ahh of course. But I think on this occasion he deserved it. Many thanks for reposting. Very much appreciated.

Hey, at least he's got one

Especially from one who comes to the trough so very often, usually pitifully bleating "Help!!!!!!!!!!