Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to paste certain cell formats based on wksht name
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to paste certain cell formats based on wksht name
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. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "aps1315" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st 2 rows of wksht show up @ top of each page of the wksht | Excel Discussion (Misc queries) | |||
If formula based on cell formats | Excel Worksheet Functions | |||
Macro to Copy/Paste Data into one wksht, skipp one row before past | Excel Discussion (Misc queries) | |||
a macro that Formats a textbox based on value in a cell | Excel Worksheet Functions | |||
Macro 2 Extract Data 2 Paste in New Wksht | Excel Programming |