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
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