• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drop Down List should show Vehicles for the particular day only.

S

Shabbo

Member
Dear Sir,

One Final Change I wanted to do in my Cash book is that only those vehicle number should show which are there in AH for that specific dates.

Eg : If Vehicles are loaded on 1st February 2018 YZ04 JK 1251 and YZ43 E 9144.

If I put Date in Column B 1st February the Column C drop down List should show only YZ04 JK 1251 and YZ43 E 9144. But now I can See all vehicles in drop down list.
 

Attachments

  • Cash Book 24022018 (1).xlsx
    171 KB · Views: 4
Like this perhaps?
-> see in name manager to see the actual formulas.
 

Attachments

  • Cash Book 24022018 (1).xlsx
    181.7 KB · Views: 8
Shabbo
... or something like this?
No need to make new dropdowns to 'Vehicle's and
there will be always the 1st line as 'Vehicle'.
 

Attachments

  • Cash Book 24022018 (1).xlsb
    51.1 KB · Views: 8
Shabbo
Last time You used 'Cashbook (2)'-sheet.
There were those named ranges with formulas.
Now, You have taken other sheet for use
and there are not same named ranges with formulas.
That's why it's not working.
 
You must log in or register to reply here.
Back
Top