Hi,
All Forum family and members,
I have one problem. The problem is given below:
I have a workbook and that has 3 sheets, names: Accounts, Customers Entries, General Ledger.
In the General Ledger sheet (Column A3) has a Dropdown Menu from the accounts Sheet.
When I select any Account Name from drop Down menu then extrect Given Data.
Now, I Want that Extrect Data between two Dates also by extrecting with names.
File Attached and Solve the problem please,
Thanks,
Reehan Saeed
Hi,
G3=MIN(C5:C107)
H3=MAX(C5:C107)
Hi,
Chris Yap,
Thanks for Reply, but this is not a correct way.
Kindly understand my Question.
can anyone solve the problem please.
Thanks
Reehan Saeed
I always wonder when i file is named 1-5 that its homework.....
Anyway, this is not perfect due to the way you are doing the vlookups based on the SR# (i think)
But a helper column at the end to decide if each record is within the dates
=IF(AND(IFERROR(VLOOKUP($A5&"-"&$A$3,Journal[[Helper 1]:[Credit]],2,0),"")>=$G$3,IFERROR(VLOOKUP($A5&"-"&$A$3,Journal[[Helper 1]:[Credit]],2,0),"")<=$H$3),TRUE,FALSE)
then a
=IF(K5=FALSE,"",
In front of every iferror/vlookup-using-dates
Then hide column K
as a side tip - i would avoid merged cells at all costs, nothing good will ever come of them
Hi,
Purfleet,
Thanks for the reply ASAP.
You solve the problem but one problem again showing that when I delete Dates G3 and H3 then does not show any record by zafer or any other account name.
Thanks
