If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expanding Data As Needed
I am wondering if there is a way to automatically expand a list of data that varys with clients, as needed. For instance, I have an Input Worksheet, where all information is entered on this page and every other worksheets is linked to the Input Worksheet. As the number of accounts that clients hold varies, is there away to add the acounts to the Input page where it will expand the information of the other worksheets automatically. I would like to prevent the need of having extra spaces to cover the amount of accounts that clients may have. That way if one client has three accounts and the next have ten, it will automatically have enough spaces only for the amount needed, without extra blank cells.
MT |
#2
|
|||
|
|||
Expanding Data As Needed
Hi,
The answer is probably "yes", but can you give us some more information? It's not quite clear when you say "expand a list of data" and "have enough spaces" what your sheets look like. How do you get the data from the input sheet to the details? via formulae or a (button &) macro? jeff -----Original Message----- I am wondering if there is a way to automatically expand a list of data that varys with clients, as needed. For instance, I have an Input Worksheet, where all information is entered on this page and every other worksheets is linked to the Input Worksheet. As the number of accounts that clients hold varies, is there away to add the acounts to the Input page where it will expand the information of the other worksheets automatically. I would like to prevent the need of having extra spaces to cover the amount of accounts that clients may have. That way if one client has three accounts and the next have ten, it will automatically have enough spaces only for the amount needed, without extra blank cells. MT . |
#3
|
|||
|
|||
Expanding Data As Needed
I don't think I'd even try. There's just too much that can go wrong.
Even just typing the wrong client name would mean that you have to have a way to delete that invalid entry from where ever it went. I like to keep all my data in one worksheet. I can do nicer things with it--sort/filter/pivottables/charts--really easily. If I need to have separate sheets per client, then I'll have a run-on-demand macro that creates each sheet from scratch each time. You can see how Debra Dalgleish approaches it at: http://www.contextures.com/excelfiles.html Look for: Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- creates a list of unique items, creates a sheet for each item, then replaces old data with current. AdvFilterCity.xls 46 kb and Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm MT wrote: I am wondering if there is a way to automatically expand a list of data that varys with clients, as needed. For instance, I have an Input Worksheet, where all information is entered on this page and every other worksheets is linked to the Input Worksheet. As the number of accounts that clients hold varies, is there away to add the acounts to the Input page where it will expand the information of the other worksheets automatically. I would like to prevent the need of having extra spaces to cover the amount of accounts that clients may have. That way if one client has three accounts and the next have ten, it will automatically have enough spaces only for the amount needed, without extra blank cells. MT -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Data Validation assistance desperately needed | laura | Worksheet Functions | 2 | May 14th, 2004 06:32 PM |
Too many data points in Excel Chart | Jo | Charts and Charting | 1 | April 5th, 2004 03:53 PM |
Generate new document with data | Jon Barchenger[MS] | Worksheet Functions | 0 | November 18th, 2003 03:30 PM |
Multiple Charts from single instance of data | dvt | Charts and Charting | 1 | September 21st, 2003 01:45 PM |