Date and Time Format

[adamswalwell]

I would like to put in an equation which will automatically (dependant on how my computers date and time is set) update itself.

I have tried =Now() but that only brings up the time and unless you re-calculate nothing else happens. I was thinking that maybe in control panel i could set it up but I have tried it and it won't happen.

Therefore if anybody knows anything about this please help!!

 

[adamswalwell]

I'm sorry!!

I don't have a clue what is going wrong but the code won't execute properly I don't know whether there is anyother way you can explain what has to be done but at the moment i'm really confused!!!!!!!!!!!!!!!!

SORRY!!

 

[GlennUK]

The code loops through the entries in the RestockLevels sheet. For each cell text entry ( say "Cod" ) it fetches the value of the name of that text + "StockTotal" ( say "CodStockTotal" ), and compares that value to the amount in the cell to the right of the text entry.

The text entries are processed according to what ranges are covered by names such as AllFish and AllKebabs ... the ranges covered by such names should cover the cells containing the text entries for the category.

 

[adamswalwell]

so i can just add in my sheets the other sheet names and the other range names on the my ranges section

in the sheet where all my desired stock levels are shown do i need to give the target levels a cell name?

i think i may have done it wrong

 

[GlennUK]

Yes, just add more entries the sheet names and range names I had.

In the stock levels sheet, the code runs by looking at the cell text entries in the range names, and picking up the cell value ( for the target level ) from the cell to the right of each text entry, so no you don't need to name the target level cells.

This was my test sheet:

stocktotal.xls
	A	B	C	D	E	F	G
1	AllFish		PastiesandPies		AllKebabs
2	Haddock	15	Steak	9	Doner	25
3	Cod	20	Mince_Onion	5	Shish	35
4	Plaice	8	Steak_Kidney	15
5			Chicken_Mushroom	12
6
RestockLevels

Can you see what I mean?

 

[adamswalwell]

i think i understand.

i'll have a go and see what happens.

thanks for your help and be sure if there is any further help i may need i will be sure to ask.

thanks again

 

[adamswalwell]

do i have to put in any information into the code that you have supplied!!!!

 

[GlennUK]

Put in the required entries for myrange and mysheets, and change the reference to sheet RestockLevels to whatever your sheet is called.

 

[adamswalwell]

i guess that the second column in your test sheet is the desired stock levels?

 

[GlennUK]

That's right. Well, it's the column to the right of whatever defined name is there, like AllFish.

 

[adamswalwell]

and where exactly do i have to put this code?

do i put it on a macro button called stock check or will it be possible to put it after the passworded macro button?