+ Reply to Thread
Results 1 to 1 of 1

Macro for extractiing a continous list of data from multiple sheets based on criteria

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro for extractiing a continous list of data from multiple sheets based on criteria

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1