Populating Client wise Sub Table from Master Sales Table

[Vector82]

Hello All,

I am old member here and took many help from this wonderful website. This is my first post with questions. Actually I have workbook in which I want to maintain my daily sales data. This sheet have mainly 2 worksheets, first worksheet where I am having master table, in which I'll be entering almost all sales related information. Second worksheet is dedicated to clients, where I want to see which client purchased what items, quantity & amount.

I have tried working with Match & Index formulas but then it does not add cell in sub table, so is it possible, that the moment I add new sale entry (of existing customers, for new customer, I will make new sub table) in my master sales table, it also add entry in clients sub table?

There is also one more table on Daily Sales Table, where there is entry of Start Date & End Date, if I enter both dates, it will filter all entries from selected dates. Please note, that this is not that important. I am currently using Office 2007, so some of suggested formulas might not work.

Please find the attached file as an example.

Thanks in advance.

Vishal

Daily Sales.xlsx

[TMS]

Are you still using Excel 2010?

[Vector82]

Hello TMS,

No, I am still using 2007 but soon will upgrade to Office 2016.

Thanks

[AliGW]

Why does your profile say 2010? Please correct it.

[Vector82]

Hello AliGW,

Sorry for confusion and I will do it right away.

Thanks & Regards.