trying to make a button on summary page to make new working sheet

A button on the summary sheet which adds a new sheet when you click on it and it lets you name the sheet and the sheet name appears on the summary under "breakdown"

Please Login or Register  to view this content.

When the new sheet appears and has been named the summary sheet will automatically log the information from it such as"labour hours, labour cost, material cost, total"

Too confusing to understand what you want done.

the quantity of breakdowns in the summary will only go down the column in white with number from how many sheets you choose.

Too confusing. You want more than 1 sheet at a time? You need to clarify.

Hi Stnkynts,

sorry, what i am after is my summary sheet there when I open up a new tender spreadsheet and then on that spreadsheet i might want 5 breakdown sheets for that summary. so i want

to be able to click a new sheet from the summary page 5 times, and be able to rename that sheet automatically. so when i click on new sheet, and it gives me the choice to name it Main switchboard, the summary

sheet will automatically list it as number 1 under breakdown, then i click new sheet from the summary again and name it Distribution boards, and the summary sheet will list it number 2.

there is also my totals from each sheet which i need put in each row of the summary breakdown, if you look on my example they are. Labour hours, Labour Cost, Material cost and Total.

It is not hard. You want to create individual tabs(sheets) for each name in summary sheet column C. What is hard to follow is your summary sheet is designed in a table format, so difficult to know which heading/columns you want to copy.
You already have a MAIN SWITCHBOARD sheet which comes from row 9 of the summary sheet. You need to clearly label it and show us which heading/columns you want to copy from each name. For e.g. you have heading, such as page and breakdown, but these heading are not copied in to main switchboard sheet.

Hi there AB33,

sorry, If i explain my background it might be easy, I am an electrical estimator, and when i receieve a tender to price, its broken up into usually 14-25 different breakdown headings such as "main switchboard, Earthing,
Communication"etc etc. so what i want is to see there breakdown sheet on how the builder wants the quote priced, and i write those components under breakdown.

I want to be able to write those components that i mentioned and they always change with each workbook, and click a button and it will make worksheets with the tabs titled those breakdowns.
so i can start going to each sheet and start pricing. when i work on each sheet, the labour cost, labour hours, material cost and total adds up, i want those totals to transfer to the summary sheet.

does this help

This is a duplicate post

http://www.excelforum.com/excel-prog...71#post3187371

i wrote the post once, and they deleted it i thought so i wrote it again,

Now i dont know which one i should ask the question on,

Can someone help me, AB33?

I do not know how to do it if the heading keeps changing. I probably did not understand your request. I thought you have a master sheet and want to create tabs extracted from the master sheet. The master sheet is like a template with fixed data format. If your components keep changing with each sheet, it is not a template to me.

Hi AB33,

https://www.dropbox.com/sh/vitpemocpz555ha/pWaUsNRHuE?m

this is the link to my tender sheet, The heading "breakdown" will not change, what changes is the titles which will be the tab sheet names, they are the tender
breakdown components needed from the builder, if you check out the macro, type anything down the column from C9.

and then click the button, and it opens all the tabs i need.

I need the information out of each sheet though to automatically be stored in the summary sheet which is "labour hours, labour cost, material cost and sell.

We have the spread sheet, but I still do not get it.
Earlier I wrote
"You already have a MAIN SWITCHBOARD sheet which comes from row 9 of the summary sheet. You need to clearly label it and show us which heading/columns you want to copy from each name. For e.g. you have heading, such as page and breakdown, but these heading are not copied in to main switchboard sheet".

Your wrote
I" need the information out of each sheet though to automatically be stored in the summary sheet which is "labour hours, labour cost, material cost and sell".
On the video you had attached(YouTube) The person on the clip had created a code which creates sheet names based on column A. That was my understanding, now you want from each sheet in summary sheet which is the opposite code.

TENDER SPREADSHEET DEMO.xlsx

Hope this helps,

sorry

Fdibbins,
The download is the same book as attached post #1. Do you understand the OP's request?

EXCEL FORUM.xlsm

Hi Guys,

ok Im going to start from the start, the spreadsheet shown now is updated.

If you look on the summary page without pressing any buttons, the purple highlighted cells are where i need information stored from each sheet.

If you look at the sheet 2"Main Swb" the highlighted purple cells are the information which i need copied over to the summary page, I know the numbers arent correct

everywhere as it is my newly edited spreadsheet.

Now if you look in the summary page you will see under breakdown the titles "Earthing, Communications, Distribution Boards and underground"

now click the button on the spreadsheet and see how it makes new sheets.

as soon as it makes those new sheets i will start storing information in each sheet and i need the summary sheet updated with the total cells in purple.