picking data from one list to populate another

I want to have one sheet dedicated to reading a CSV form. Want i want from that is that, on other pages, there will be a list that reads the data from that first sheet to populate itself, but only if a certain criteria is met (based on the tag in the first column of the master list).

Therefore, each time the mast list is refreshed from the CSV (new entries made vertically), the lists on the other pages will go through that master list and recognize that there are new entries, and display those entries that have the proper tag.

ie, Sheet1=master list. On Sheet2, the list will only entries with the tag "tag-A", and on Sheet3 the list will only contain entries with the tag "tag-B", etc.

I tried using various combinations of vlookup and IF statements, but i cant seem to figure something out that functions properly. Every time i felt like i got close (albeit with a sometimes cumbersome cleanup process) i realized a glaring fault.

Any/all help appreciated

thanks
dan

How is the Master sheet populated? Is the new data added to or create a new list in master sheeet. Meaning when importing does the data get overwriten or does the data get added to the bottom of master sheet. Why not when importing the data add the new data to sheet1 and sheet2.

Can you upload the csv file and your master workbook?

Are there heading's in the csv file?

---------- Post added at 04:49 PM ---------- Previous post was at 04:47 PM ----------

Also from your example its hard to tell what the fields are. Could you put it into a xl file and upload.

nope, it shows up in excel just as you see it (with the item descriptions and $$ being the actual amounts).

thanks


edit: i added the column labels before uploading, otherwise it will show up without those in actual usage.

Also from your example data I dont see Tag A or Tab B

the list will only entries with the tag "tag-A", and on Sheet3 the list will only contain entries with the tag "tag-B",

Ok what about vis? Do you need to separate these out too?

Dan,

Without knowing exactly what to due, I put this together. To test, place the attatched csv and TestFile.xlsm file's into the same folder. Everytime you import the csv file it will add the entire csv file to the Main sheet, at the same time it will break out the Cash, Mas, and vis records into there respective worksheet.

Hope this helps

Test.zip

@mustang_1,

If you lived near I might take a beer but anyway dont worry about any money, this site is not setup for coders to make money its to help others.

@mustang_1

I assumed that the csv file would be populated with all new records? Is that not the case?

If you do by deleting the file and creating a new vac file it will work without any modifications. I will be out of town til Saturday.