Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro's - inserting a worksheet and having upload data
I have a template worksheet that has data on it that a user is required to
input. I also have a macro that makes a copy of the template worksheet. For arguments sake, the copy of the template worksheet may be named "Bob", and the user can then input information relating to Bob. An example may be, how much money Bob has. I then have a summary worksheet that summarises all of the data in the individual worksheets that are created from the template. One of the cells may sum the same cell on all of the worksheets in the spreadsheet that have been created from the template worksheet. I want to have the flexibility to create a new worksheet from the template worksheet and have the summary worksheet automatically link in the information from the new worksheet. So, the question is, once i have created the new worksheet from the template and input the data relating to that particular person, how can i have it link directly into some sort of summary worksheet without having to go and change the formulas in the summary spreadsheet each time a new worksheet is added. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro's - inserting a worksheet and having upload data
What you need is a loop that is triggered by ,say a button that is on your
Summary sheet - I'll call it Master. In the Master sheet lets say you want cell A1 = the sum of cell A1 in all other sheets. Try this: Sub AddEmUp() Dim Sh as Worksheet Dim Total as Long For each Sh in Worksheets If Sh.Name<"Master" then Total = Total + Range("A1") End if Next Sheets("Master").Range("A1") = Total End Sub "Can't work it out" wrote: I have a template worksheet that has data on it that a user is required to input. I also have a macro that makes a copy of the template worksheet. For arguments sake, the copy of the template worksheet may be named "Bob", and the user can then input information relating to Bob. An example may be, how much money Bob has. I then have a summary worksheet that summarises all of the data in the individual worksheets that are created from the template. One of the cells may sum the same cell on all of the worksheets in the spreadsheet that have been created from the template worksheet. I want to have the flexibility to create a new worksheet from the template worksheet and have the summary worksheet automatically link in the information from the new worksheet. So, the question is, once i have created the new worksheet from the template and input the data relating to that particular person, how can i have it link directly into some sort of summary worksheet without having to go and change the formulas in the summary spreadsheet each time a new worksheet is added. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting data from one worksheet to another | Excel Worksheet Functions | |||
How to run Multiple Macro's in Worksheet? | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
automated macro's? and macro limitation to a worksheet | Excel Programming |