I’m trying to develop a workbook which holds monthly data on cost information of different cutomers catering to different services. I have different files for different months.The main data file contains many columns but all are are not relevant therefore I have selected a criteria on the basis of which I want to extract data. The criteria is in a different sheet (which is also my output file) and for each combination ( i.e Customer 1 Service 1) the data should be extracted from the different monthly sheets.
If I type Customer1 Service1 in my criteria sheet it should populate the expense for all the months in the output file in a different sheet. If I type Customer1 Service2 in my criteria sheet it should populate the expense for all the months in the output file in a different sheet but in the same output file.
Now, if a preexisting customer name and the service line (example:- Customer 1 Service 1) is in my criteria sheet it should already go into the expense of the same output file which was created earlier.Therefore for a new combination( Customer 2 Service 3) the expense should be in a different sheet in the same output file.
Bookmarks