#16
|
|||
|
|||
I wondered why an item from the tabs was being copied twice..... now I know.
Fixed this in the macro of the hidden BLANK sheet, will exist for sheets created from now on. Did the changes to B39 and K27. For any changed you want to appear on all sheets ---> unhide the BLANK sheet ---> make the changes and hide the sheet again. It won't do anything to the existing tabs but from then on all sheets created from the BLANK will include those changes. The thing to watch here though is if you change a cell to a formula that is being copied to the summary it won't copy over without altering the macro to accommodate it. Quote:
I've used summary column A to hold the sheet index (ie:sheet location in the tab lineup) and then sorted based on that. Think this should look after everything you've mentioned. Be sure to mark this thread as solved when you think it is. Thanks. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about auto-fill form | Dsp581 | Word | 3 | 04-04-2013 11:27 PM |
How-TO format cells (FILL) by comparing cells | zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Unwanted tabs in table cells | deltaskye | Word | 5 | 01-27-2012 11:58 AM |
How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |