LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting data from one worksheet to another jmholt Excel Worksheet Functions 1 July 9th 09 12:45 PM
How to run Multiple Macro's in Worksheet? Ben Dummar Excel Discussion (Misc queries) 6 May 25th 06 05:16 AM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet Aster Excel Worksheet Functions 3 March 12th 06 09:58 AM
automated macro's? and macro limitation to a worksheet FAM THEUWS Excel Programming 1 November 5th 03 10:23 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"