Adding columns based on new worksheets

A

azu_daioh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Duplicating worksheet based on range and changing worksheet name 3
Need help with VBA - complicated copy and paste 2
VBA - retrieve data on last create named range from previous inserted named range 0
Combine contents of a column 2
Copy and paste to other worksheets 2
Copying and Adding Values 1

Top