i need to pull information from two columns and end of up with a customer number, VBA?

i have to pull the first four characters from a cell (has to be characters; must exclude dashes and "&" symbols) and also must sequence the results at the end with a "-1" or "-2" .... and so on; depending on how many times the first 4 numbers have recurred in the previous above cells, must decide if its a -1 or a -2, or -3......


ie ; A B C
ref # CUSTOMER ID customer name

33 BALL-1 Ball packaging europe
33 BALL-1 Ball packaging canada

IE#2

A B C
ref # CUSTOMER ID customer name

1 BALL-1 Ball packaging europe
234 BALL-2 Ball packaging canada

NOTICE THAT EVEN IF THE FIRST 4 LETTERS IN COLUMN C ARE THE SAME IF THE NUMBERS IN COLUMN A DONT MATCH THEN COLUMB B NEEDS TO COUNT UP



WHO CAN DO THIS I NEED TO ENTER 11,000 FILES BY HAND IF NO-ONE CAN HELP

PLEASE PLEASE HELP!!

I HAVE PICTURES IF YOU NEED THEM

Hi and welcome to the forum

We would love to help you with your question, but 1st, in accordance with forum rules, please rename your thread to something more meaningful, that actually describes your problem.

Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

Many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertise, they might only open those threads.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

Also, Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

I started but have run out of time. Hopefully one of the experts will come through and help you out.

My inital gut (assuming goal is in fact <from screenshot> to analyze strings in D and render them as you have defined in C) says to load every company name into an array, build a collection of the unique 4-letter instances, and then test each array item as being equal. If yes, increase counter and append array item + "-" + counter value.

This loads all data into an array and then creates the collection. Like I said, someone may or may not choose to take this direction. Good luck.

Please Login or Register  to view this content.

May be this...

Formula:

Please Login or Register  to view this content.

Hi,

there were times in this forum when Rule 7 was regarded by senior members:

7. Don't ignore requests by Administrators, Moderators, or senior members of the forum. If you are unclear about their request or instructions, then send a private message to them asking for help. Do not post a reply in a thread where such a request (e.g., title change, code tags) is pending.

Ciao,
Holger

@ HaHoBe,

Thanks for pointing it

In fact I have not read FDibbins post I just seen his long reply and I thought he is requesting for File. I never give attention to long and lengthy passage messages even if the question is big passage I just simply close that thread.

It is my mistake I should have paid attention to that thread

AlvaroSiza & SS,

Both of you being senior members, i am sorry but i have to give you the infraction as Holger pointed out.

No issues it's my mistake

One request from my end, Whenever something goes against forum rules please add those text with some formatting like Bold/Underline/Different Font Color/In CAPS so that it capture other eyes easily.

As far as I seen FDibbins writes lot of informative passages to OP's by describing what are all the methods are available to get the solution and how the data needs to be structured with lot of tips in his posts and by mistake I thought the post is something like that...

Because I wont read all the texts since it take more time for me to read it so just requesting the formatting to the texts whenever something goes against forum rules which will help me to stay away from infractions

redsab...
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Nate you have been repeatedly asked to change you're thread title. I am now closing this thread - you can start another - with a more descriptive thread title!!