sum based on multiple variable

[SURYA2016]

I want macro with an automatic update as per the attached excel format

1. Sales detail year-wise (sheet separate)

2. customer detail consolidate detail (sheet separate)

Following should be variable

1. card no. (if possible multiple numbers)
2. customer name (partial search)
3. year

The result should be – Summary Sheet

Fill data based on invoice type month-wise total

 

[maabadi]

Please Upload Example file & Desired Results with XL2BB ADDIN (Preferable) or upload at sites www.Dropbox.com , GoogleDrive OR OneDrive and Insert Link here.

 

[SURYA2016]

Please Upload Example file & Desired Results with XL2BB ADDIN (Preferable) or upload at sites www.Dropbox.com , GoogleDrive OR OneDrive and Insert Link here.

sum formula.xlsx

drive.google.com

Pls note summary sheet B1, B2, B3 Both findable required

 

[maabadi]

I created Formula Based Worksheet.
I create Name Manager and Use them as Dropdown to create Changeable Customer NO. , Customer Name & Year. For range of Sales Detail , I supposed to row 1000 you have data, if exceeded that range, you should change range at formula.
if you have more Customer NO. , Customer Name & Year, only Drag down tables at Customer Detail sheet to fit to your all Customer NO. , Customer Name & Year.

Sum Formula