Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 04-23-2009, 12:05 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Cell formatting Cell formatting Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by Niko View Post
Now, if you are constanty adding in Y's and N's to the sheet, and then copying the tables each subsequent week and only changing the dates....does it also copy the rules for the new table??
It should indeed do!

As to all these hundreds of rules - if you are only using the rules you have just made, then delete the rest! I would suggest that you save a copy of the original document, then in the copy you can delete ALL the rules and add back in your new ones - does it effect the working of the workbook? if NO - go for it, if YES, start again and delete a handful at a time - that way you can work out needed vs unneeded.
Have extraneous rules floating around in your workbook can clog it up as it is trying all the rules, therefore wasting time.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM
Cell formatting Autosizing picture to fit a cell Lor66 Excel 1 12-05-2008 07:33 PM
Drop down box in a cell Grapejuice Excel 0 10-22-2007 07:40 PM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM
click a cell to go to a worksheet victor Excel 0 10-27-2006 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft