Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding columns based on new worksheets
Hi, I need a lot of help from the experts.
I have a workbook with 3 worksheets: 1- GENWS - is to generate worksheet based on how many the user needs, the user also has the capability to enter the names for this new worksheets. 2 - MSTWS - is the master worksheet that is being copied/duplicated. Once the user made their inputs on GENWS, a macro will run to copy this worksheet and rename the new worksheet for example: 101, 102, 103, 104 3 - GRTOTAL - contains all the total from each worksheets and calculate the average, etc. ---- What I want to accomplish is to add a column in the GRTOTAL worksheet from each total column on every worksheet. Additionally, i want the header of this new columns in GRTOTAL to correspond with the worksheet names. Ex. once 101 worksheet is created, GRTOTAL worksheet will automatically add a column named "101" and the total column on 101 worksheet will be copied to the "101" column in GRTOTAL worksheet. If anyone could help me on this or direct me to where I could find an answer, I greatly appreciate it. Thank you, Sharon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding columns based on new worksheets
disregard. I found a solution.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding columns on different worksheets | Excel Discussion (Misc queries) | |||
Adding up various columns based on the value of one changing cell | Excel Worksheet Functions | |||
Comparing Two Columns on Two Worksheets and then Adding New Info. | Excel Programming | |||
Adding total over two worksheets based on date values | Excel Programming | |||
adding columns based on lists | Excel Programming |