Vba if then statement with multiple cases and wildcards

https://drive.google.com/file/d/0B9D...ew?usp=sharing

^ this is the link to the spreadsheet so you can visually see what is going on.

What I need:

A code that searches (RPA!D5 to last row) against the numbers in (Feature Report!Q to last row), giving me the value if contains one of these values. (First Instance only) 65, 64.99, 40, 45, 30, 35, 15, 20, 10, 50 then put that number in (RPV!)

A code that searches (RPA!D5 to last row) against the numbers in (Feature Report!Q to last row), giving me the value if (Feature Report!AI2 to last row) contains a wildcard such as (*EPTT*) so if it is EPTT05 give me the value next to it (Feature Report!AM) put that number in (RPAA!) I need this to add all the values up. Since one phone number can have multiple instances of the feature MRC.

A code that copies all the phone numbers from (Smart Report:Q2 to Last Row) and paste them in (RPA:D5 to Last row).






Below is a code that I Have at the moment. The issue with it, is that it doesn't do Wildcards, and has the static range of 5-3004 rather than 5-last used row. The last used row is still being judged by column D. Once I have the code done once, I will use it as a template to complete the project.

Please Login or Register  to view this content.

Upload your workbook to this forum.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


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

Originally Posted by LightKerosene

Fixed, I think

You missed the first request.
Upload your workbook to this forum.

ViewPic.

Originally Posted by LightKerosene

I tried. That's why I posted the google doc. The workbook is 6mb. This site allows 1mb.

Try zipping it and uploading the zip folder.

What does this mean, it's confusing?

giving me the value if contains one of these values. (First Instance only) 65, 64.99, 40, 45, 30, 35, 15, 20, 10, 50 then put that number in (RPV!)

Then, what is RPV?
I don't see a sheet named RPV.

A code that copies all the phone numbers from (Smart Report:Q2 to Last Row) and paste them in (RPA:D5 to Last row).

What about the phone numbers and other data that maybe be in RPA already?

As for RPV. it is a typo for RPAV! My apologies.

I don't see a sheet named RPAV either.


Okay, well if you want me to help you, then read my posts carefully and understand that it's not apparent what you want, at least to me, and where you want it, hence that is why I said your explanation is confusing, "What does this mean". I don't want to go back and forth with you. Details and more details. Use sheet names cell addresses etc. to explain what you want. If you were expecting only the one wildcard match make that apparent if you were expecting more than one, then we need to know the whole of what you expect.

RPA!V5 to end row. gosh I suck today.

Example *EPTT*

Will return EPTT05, EPTT05FMS, EPTT030, EPTTBlah, BlahEPTT.

It will add the value from AM for each found case. And put the added value of the EPTT's found into Column RPA!V whatever phone number it is associated with.

Explaination of tabs, incase it helps
Feature Report = Report of all features on said phone number
Smart Report = Basic report of lines that are on an account.
RPA = The Rate Plan Analysis that we help make for customers.
Macro information = Macro stuff.
Macro Settings = Incase you need to put a variable on another sheet temporarily.


Example below (Ranges aren't set correctly, but it gives you an idea of what I mean)

Please Login or Register  to view this content.

I don't know how to get you on the same page as me.
Again go back to post #8, I say what does this mean and below that is a quote from your post with a bunch of numbers 65, 50, etc.
What does that mean, explain where those numbers are, what you want to do with those numbers, are they in the phone number, can they be in the phone number, beginning end anywhere? Details.

Example *EPTT*

Will return EPTT05, EPTT05FMS, EPTT030, EPTTBlah, BlahEPTT.

Yeah I get that part, otherwise I don't belong here.

If you were expecting only the one wildcard match make that apparent if you were expecting more than one, then we need to know the whole of what you expect.

Meaning *EPTT*, you have a bunch of other possibilities in that column, for instance you have 10APL, do you want *10APL* or any other possibilities, so I may decide how to code this.