Hi Everybody,



I have an issue i am trying to solve for the past week un-successfuly

I have a document with 3 sheets -
Sheet 1 - Display all Clients orders, and the order numbers and vale
Sheet 2 - Display all Clients Invoices, and Invoice numbers and value
Sheet 3 - Payments sheet, here is where i need your help:
i have the following scenario -
A. Choose Client name (From droplist) - no issue
B. Choose Document Type - Orders or Invoices (From Droplist) - no issue
C. Show the relevant Order numbers or Invoice Numbers (in a drop list) according to the Client & Document type - Issue!!!

I managed to get the entire Orders number or the entire Invoices numbers according to the Document type, but didn't manage to get the related numbers per client...

Would be more then Happy to get your assistance!

Hi and welcome
posting a sample file would really help ( no pics please)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hey Pecoflyer! Thank you for the responds!

I attached a sample, please note -

Sheet 1 - Display all Clients orders, and the order numbers and vale
Sheet 2 - Display all Clients Invoices, and Invoice numbers and value
Sheet 3 - Payments sheet, here is where i need your help:
i have the following scenario -
A. Choose Client name (From droplist)
B. Choose Document Type - Orders or Invoices (From Droplist)

C. Show the relevant Order numbers or Invoice Numbers (in a drop list) according to the Client & Document type - Issue!

So in sheet 3, i trying to get the relevant numbers (in droplist) based on Client name in cell A2 + Type in cell E2.

if Type = "PI", then i would like to get all the PI numbers of the relevant client from sheet 1.
if Type = "Invoice", then i would like to get all the Invoice numbers of the relevant client from sheet 2.

Hope i am clear enough

Thank you in advance for your help!

Link to sample file -
https://www.dropbox.com/s/fe55zl98wx...file.xlsx?dl=0

Here is the file embeded

Attached Files

Payment Tracking- Sample file.xlsx (15.1 KB, 25 views)

Possible? Anyone?

Hi,

Any idea how to solve?
Thanks!