macro to paste certain cell formats based on wksht name

[Guest]

VBA newbie here ...

I'm trying to find a way to programatically insert/copy certain cell content
and formats based on wksht name. For example, given wkshts:

#1 Summary
#2 A
#3 B
#4 C

On wksht Summary, column A contains headings (Name, Title, Organization).
For wkshts A,B and C, there are entries for each heading, each entry being to
the right of the previous one. With "Name" being the name of the wksht, in
this case A,B and C entries would be to right of the previous one.

So ideally, when I insert wksht #5, "D," on wksht Summary to the right of
the entry for wksht C, the Name, Title, Organization info from wksht D would
populate on wksht Summary.

Not sure if this is doable but thanks in advance for any assistance.

 

[David McRitchie]

Hi ......,
Your summary worksheet will have to know the names of the other worksheets.
You can find an example on my page
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
which is not very elegant but it makes adding sheets in the same format
easy to work with at the summary page, and you know what addresses you are
working with..

Please remove the word wrksht from your spelling checker, the time you save
leaving out letters is probably wasted several times over by each person
reading your posting.