Running a Macro that pulls data from a different file

Hello!

I have a very large file, a master file if you will, which includes a lot of data, and is updated regularly. I would like to create a separate file which pulls details from this large file to consistently provide a filtered list of this data which is easier to view, and can allow me to put more detailed data on it as well.

See attached a condensed mock version of my master file, called 'Master File'.

So, in the new file (let's say it will be called 'Gold Members'), I'd like to have a list of just 'Gold' member types which includes all the other data from the master file. Ideally, I'd like this file to update from Master File without having to open Master File.

I've got the following code which puts it into a different sheet in the Master File (which sadly isn't useful for what I need):

Please Login or Register  to view this content.

Aside from this being in the same file, the other problem I have is any rows with non-Gold members are copied as blanks. Ideally I'd like it to just copy Gold members and have no blanks between them

Both files will be saved in the same folder / location.

Is anyone able to help me with creating a new code to get this done?

Create a new Excel workbook and run the code from it.

Please Login or Register  to view this content.

Amazing, this is perfect - thank you!

As a quick follow up to this; if I wanted to create a file which had two types on there - say Gold and Silver - how would I go about this?

I originally thought it would be a simple addition to the following line:

Please Login or Register  to view this content.

But that didn't work. Neither has:

Please Login or Register  to view this content.

Where am I going wrong here?

You could do

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

That's done the trick - thanks again for you help!

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.