Macro & filters

[Toxicca]

Hi All,

I'm trying to create a simple macro that will in essence will filter by a specific name and then copy that data into a new tab. From previous experience writing MACROs like this I encounter the problem that if what I want it to filter by isn't on the least it will return a debug instead of moving onto the next one. EG: Data holds Months, however month data for July is missing so I want it to look for the filter it's not there so it then tries, August for example.

My Macro knowledge is very basic so any guidance would be appreciated.

Hope this makes sense?

[stnkynts]

You gave very vague detail with no specifics. Impossilbe to accurately answer your question without guessing on 90% of it.

[Toxicca]

Wasn't sure if there was just something I could add to the end of the Macro after detailing what to filter on to say if not there move to next one, Hence not putting a great detail of information. Full details below:

Card Number First Name Surname Transaction Date Posting Date Merchant Name Merchant City Transaction Amount Foreign Currency Foreign Currency Amt Foreign Currency Rate


Above is the columns heading I have. I want to be filtering by Surname, taking the data from "Trans Date", "Merchant Name" "Transaction Amount" and pasting this into a tab which is already set up with the persons name.

I will have for example 20 tabs with names on, however these may not always appear in the data.

Does this help?

[Toxicca]

Please Login or Register  to view this content.

Above is example of what I have. As I say I'm very basic with Macros.

[stnkynts]

I think I know what you are wanting to do and it shouldn't be too complicated. Could you by chance submit an example workbook with a little bit of data, fake data would be best, for me to test the code on. Please make sure it mimics as close as possible to your real sheet.

[Toxicca]

Hi I have attached a sample sheet.

The tab's labelled, Cat, Dog, Fish, Rabbit are what I want to filter Data 3 (c) with and if not in data to move onto the next one.

I want it to copy data from the columns in Yellow so Data 4, Data 6 & Data 8.

Many Thanks

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Toxicca]

Sorry was unaware. Not used this forum that often. Have amended

[stnkynts]

give this a try:

Please Login or Register  to view this content.

[Toxicca]

That works perfectly.

I need to make a slight change to where the data is copied to. eg I would like Data 4 to be moved into cells B3 and down, Data 6 in C3 and down, and finally Data 8 to go into Cell N3 and down.

Sorry to be a pain.