More Excel

[fish]

Thank you to everyone that commented earlier on my problems and there is no way I'm going to now do the spreadsheet the way it was intended.

However I do now need to use a few drop down boxes (60,000odd) so I need to know hoe to copy them but allow the cell links to be relative. If you do a copy they remain the same as the copied ones thus you would have to manualy chaneg them, which isn't an option.

Any help appreciated...

[TheGroover]

fish said:

Thank you to everyone that commented earlier on my problems and there is no way I'm going to now do the spreadsheet the way it was intended. However I do now need to use a few drop down boxes (60,000odd) so I need to know hoe to copy them but allow the cell links to be relative. If you do a copy they remain the same as the copied ones thus you would have to manualy chaneg them, which isn't an option. Any help appreciated...

Short answer - you can't.
But Sixty thousand of them ?
Are you Sure ?!?!?!
There really must be a simpler way of doing what you want to do. If you want you can mail it to me with a description of what you want to do and I'll see if you're using completely the wrong application, or alternatively let you know what you need to do.
It will be over the weekend though ...
(I'm on broadband so size of file not really an issue)

[fish]

Solved it I think... I'll give you an e-mail anyhow as I'd be interested in your thoughts.

Cheers

[fish]

Grouver

You don't have e-mail enabled in your profile but the sheets is as follows:

We are a housebuilder, I want to set a sheet up to log all incidents. I think it will now look like a freeze pane on the left with the house address name etc and completion dates. On the right will be upto 40 incident which are copied columns whhich allow you to imput nature of problem subcontractor date date cleared and a comment for the notes...

The probelm started when I want to only allow certain options for incident nature which was why I wanted drop down menus However I can do it with cell validation.

I can then report based on the cells and do logic formulas to produce info such as highest incident plot, worst subcontractor etc etc.

A bit of conditional formating and protection and it should be nice and usable.

[TheGroover]

Mail enabled. Send it if you want me to give it the once over.

[chim_girl]

You wouldn't need to go to all this effort if you built the houses properly in the first place.

[fish]

We have very few problems compared to certain major housebuilders. Unfortunately their will always be problems when the product is made from natural materials produced in all weathers and everyone is different.

[atom290]

The easiest way to use multiple drop down boxes are to creat some name list ranges, then use data validation to access the lists, you can click whole columns to speed up the process

[t1grm]

Wouldn't you be better off doing this in Access? It sounds a bit big and too variable for Excel.