Sir Babydum GBE
10-10-2005, 05:20 AM
In the attached example, I have a "control panel" that contains some named ranges: "Areas", "Start Date", "End Date", (they?re all actually just single cells ? named for making it easier to read formulae).
You?ll notice that changing the number in cell C3 ("Areas") increases the number of areas accordingly. I?ve done this with formulae and conditional formatting. The problem with this method is that ? whilst it is a relatively sexy method to get the desired result ? it is a tad long-winded and takes up a fair amount of space. But it has a bigger, more fundamental flaw:
If I have started populating this sheet with information, then I need that information to move relative to the new position of the "areas". So I think I need to scrap the formulae. I think I need a worksheet_change event that physically adds rows (populated with "area", "day", and "date") when the user increases the number of areas in the control panel ? but the problem there is that if the rooms are decreased ? then a warning message informs the user that if he continues ? he will delete all records from the rows that are about to be deleted.
Any help greatly appreciated :)
You?ll notice that changing the number in cell C3 ("Areas") increases the number of areas accordingly. I?ve done this with formulae and conditional formatting. The problem with this method is that ? whilst it is a relatively sexy method to get the desired result ? it is a tad long-winded and takes up a fair amount of space. But it has a bigger, more fundamental flaw:
If I have started populating this sheet with information, then I need that information to move relative to the new position of the "areas". So I think I need to scrap the formulae. I think I need a worksheet_change event that physically adds rows (populated with "area", "day", and "date") when the user increases the number of areas in the control panel ? but the problem there is that if the rooms are decreased ? then a warning message informs the user that if he continues ? he will delete all records from the rows that are about to be deleted.
Any help greatly appreciated :)