Macro to pull data from 3 other worksheets, plus filtering help

**Thunderer** · 12-13-2013, 04:34 PM

Hi. This is my first time posting in an excel forum. I've been searching for help on my macro/vba problem but have had little to no luck. What I want to do is pull data from columns A,B,C,D in 3 other closed workbooks (export.csv, export1.csv, & export2.csv) to my main workbook (Thunder.xlsm)and append that data in columns A-D on my main workbook. In addition I created a list of 10 names (but need to expand or delete from this list as personnel change) in Column O that I would like to filter the data in A-D. The names in the list must find the data I want to keep in column D, the rest I want to delete (not the entire row, just A-D for that particular row that does not match the criteria in column O, and shift those cells up). I hope I explained that well enough.

I've attached a sample spreadsheet that will hopefully help clarify what I am asking. I'm preferrably asking for 2 macro's, one for the pull of data, and the other for the filtering.

Appreciate the help!

Tim

**p24leclerc** · 12-20-2013, 04:46 PM

Here is a macro that will answer your second request to delete names not in your column O.

Please Login or Register  to view this content.

**Thunderer** · 12-20-2013, 04:52 PM

Thanks P24,

I've been trying to learn VBA on my own while playing in Excel. I'll give this a shot and let you know how it worked out for me.

Tim

**p24leclerc** · 12-20-2013, 05:13 PM

Here is a macro that will answer your first request to upload data from the 3 files into Thunder.xlsm
I assumed the 3 csv files will be located in the same folder as Thunder.xlsm. If they are not, you'll have to change the p_ath variable to look at the proper place.

Please Login or Register  to view this content.

**AB33** · 12-20-2013, 05:35 PM

Thunderer,
The code does the same for part 2 of your question, but instead of deleting and shiting the cells, it copies the 4 columns only. You can extend column O as you wish.