Forum Discussion
Vehicle Management help required
Thank you very much for your response Sir.
and Thank you very much for your suggestion to use that 'Full Text Editor'. I did not get that option as i was using the phone. got it when i switched to my laptop
Here is my file (seems i don't have the permission to load images)
1) I intend to use 'conditional formatting to colour the cells, that - as soon as they type something, the cells are highlighted
2) No problem- All users will use the same green. Because i am making the file here, now. after i am successful in programming all this, i will distribute the file to my staff. So, everything is automated, they will not have the need to meddle with the colours.
I will give the following colours- for the red- among the Cell highlight colours of Excel, there is a colour called "ORANGE, ACCENT 2, LIGHTER 60%"
For the Green- "GREEN, ACCENT 6, LIGHTER 60%"
3) Double click, single click, button anythig is good. as long as it serves the purpose
4) When a car (row) with a colour green is found, that is it. that is the end of it all. The staff will know, what all cars are available on that particular date. They will take their own specific action while discussing with the customer.
The case is that: A customer will call in asking for a vehicle, on a particular date / a set of dates. So, my staff, as soon as they click on that date, they should be able to EASILY find out, what are all the available SUVs / Sedans, etc on that date without having to look for it in each column and row. and that will be easy if all the available cars are automatically highlighted in green / whatever colour.
This is just my idea. Am open to any more suggestions to make things easier for the staff.
FWIW, your post was sent at 3:00 pm and I rec'd it at 7:00 pm (USA west coast).
I am going to assume you want the worksheet to scroll up so that the first green row with available auto is in the 3rd row below the frozen two row header.
Also, I assume the staff will use the shortcut Ctrl + Home to return the worksheet to the top.
And, what row is the double-click row: first or second row.
What I don't understand is how this works if the potential custom asks for a Honda sedan on Oct 10. Do you just give him his choice of what is available on that date?
Also, please resolve this: "If it is not highlighted means that vehicle is available.
That available vehicle and its number should be highlighted in green."
More: please identify the column numbers or letters to be double-clicked.
Finally, if the worksheet is shared none of this will work.
(I see two people trying to scroll to different rows on the same worksheet)
There will probably be more questions.
Something to look at would be helpful.
'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
There is only one staff and he will use this file. So no worries about sharing 😁
As soon as he clicks on a date, the arrangement need not go to the first column. I have frozen the headings- first two rows and first three columns. So they will be visible all the time.
It is just that the available vehicles need to be highlighted so that it is easier for him to identify them readily (the human eye will immediately be drawn to highlighted cells, right).
If a customer asks for a particular honda, etc-
I have grouped the vehicles based on class- SUV, CUV, Sedan (among sedan mid size, compact). And among each class, all accords will be one below the other. All civics will be one below the other. So, u see i have grouped them. He will be able to easily trace them.
He will click on 10 october and go to the sedan section. In that sedan section, he can look for all the accords which are highlighted green.
I really hope i could insert that file or atleast pastr an image here, so that it'll be easier for u to understand the layout of the file.
Can u give me an email address sir. I will send it to u personally. You need not display ur emaul address here, just watsapp me. My watsapp is- +968 - 93 218 278
The cell to be clicked is the 4th row of each column. Eg: E4, F4,G4, ETC. Each column denotes one date. For eg: e4 is 26 september. F4 is 27 sept. G4 us 28 september.
The rows are each vehicle. B5 is land cruiser.. c5 is its number.
B6 is land cruiser. C6 its number.
B7 is prado. C7 its number
Go to my OneDrive and download "USA Lottery Numbers".
My email address is on the first worksheet...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHUIf you highlight booked autos in Red? - That would mean that autos in white cells are available? Why would green be an advantage?
Nothing Left to Lose- apologies for the delay in response Sir.
I could not find a file called USA Lottery Numbers among the files.
I would not be highlighting the vehicles in RED. it will be like this.
let us say- a honda civic is in cell B24.
It needs to be booked from the (1st - 10th Oct). 1st Oct is in cell K4. 2nd Oct is in cell L4. 3rd Oct is in M4.... so on and so forth till 10th Oct is in T4.
The cells i will highlight in red will be k24 to T24 (all the cells in between will be highlighted red).
So, when i click on any date between 1st and 10th oct, this particular civic should not be showing green.