View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre De Cat Pierre De Cat is offline
external usenet poster
 
Posts: 1
Default Automated sheet copying and naming

Hello all,

I am sure some of you will be able to help me.... but would you also like to
help?


I have a workbook for keeping track of competitions.
On the first worsheet I have an overview of results from the other
worksheets.
The second worksheet is a model for all other sheets.
In worksheet 1, cell a1 is the name (or date) of an event. Worksheet 3
should get the name of the event in that specific cell.
In worksheet 1, cell a2 is the name (or date) of enother event. Worksheet 4
should get the name of the event in cell a2.

In this way, I have to make a copy of the model worksheet and then give the
name in worksheet 1, cell a2 and next time of course, a3... and so on.
It would be terrific if Excel could make a copy of the model sheet and give
it the name of the event in ce a2, a3.. and so on, at the moment I give a
name in that cell.

I hope you understand my idea.

Also it would be very neat if it also works on Pocket excel (windows Pocket
PC 2003).


Thank you all,
Pierre