Word links 3 to 4 to 5 to 6

[makinmomb]

I am looking for a summary of words that has links
Attached is a workbook that has 3 4 5 and 6 letter words

Back Hook

I need on sheet 2 results as follows on b1 c1 d1 and e1

ABA ABAC ABACA ABACS
And all the words with these

Front Hook

I need on sheet 3 results as follows on b1 c1 d1 and e1
RIN BRIN ABRIN

Summary should be pulled even if the fourth level of word in 6 letters is not available e.g. ABRIN does not exist as ABRINS

[Richard Buttrey]

The workbook was not attached. The paperclip icon doesn't work - no don't ask!

You'll need to use the Go Advanced button and look underneath your post for the Manage Attachments option.

[makinmomb]

Okay sir , re attaching , looks it is not attaching as file size exceeded , let me chop away some columns

[makinmomb]

Okay it looks as follows after delete some columns of no use

[Richard Buttrey]

Hi,

It's not at all clear to me what you're getting at here, and whether the data you show is original data or which may be results dependent on the data.

In any case this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

[makinmomb]

This is a real work book , all the total words of the whole dictionary are extracted

I am looking for letter add on to a word from 3 to 4 to 5 to 6 , called , BACK hook
If the add is in front it is called back hook

[makinmomb]

Thus the programming logic should be based on search the words , column a e i and m , find the common ,
common is ABA with adds to right

ABA
ABAC
ABACA
ABACAS

[Richard Buttrey]

Sorry, but it's still not clear to me which are the result sheet/cells and which are original data.

Can I suggest you take us through your thought process that takes you from a starting point and step by step explains how you move on and obtain the final result.

Remember that whilst you are entirely familiar with the system you're trying to handle, we are all new to this.

[makinmomb]

Raw data is sheet 1 , words on column a e i m that is 3 letters 4 letters 5 letters and 6 letters
Result sheet 2 , back hook search
Result sheet 3 , front hook search

The result required is search 3 letter words from a and look into e i and m , and see if they connect any words to right , paste them on sheet 2
The result required is search 3 letter words from a and look into e i and m , and see if they connect any words to left , paste them on sheet 3

[makinmomb]

Here is another example , where JIN is common is all

JIN
JINN
JINNI
JINNIS

[makinmomb]

They should appear on sheet 2 as follows

JIN JINN JINNI JINNIS on columns a b c and d

[makinmomb]

Any modification to raw data is invited too , for example pasting all words in one columns all letters and sort by alpha to see if any logical macro will pull what is desired

[makinmomb]

They will look as follows if clotted as one column

AAH
AAHED
AAHING
AAHS
AAL
AALII
AALIIS
AALS
AARGH
AARRGH
AARTI
AARTIS
AAS
ABA
ABAC
ABACA
ABACAS

[makinmomb]

In case the macro will handle that easier , not sure

[karedog]

5B:

Please Login or Register  to view this content.

[makinmomb]

Karedog this was just beyond awesome , wow , it did the task as required.

I will close the thread , but i need one additional request , what would be modified macro ,
for one more level , if letter words are on column Q

[karedog]

Thanks for marking the thread as solved and rep.points.

The code should be :

Please Login or Register  to view this content.

[shg]

Another way, via UDF:

	A	B	C
1	AAH	AAHED, AAHING, AAHS	B1: =BackHooks(A1, A2:A50)
2	AAHED
3	AAHING
4	AAHS
5	AAL	AALII, AALIIS, AALS
6	AALII	AALIIS
7	AALIIS
8	AALS
9	AARGH
10	AARRGH
11	AARTI	AARTIS
12	AARTIS
13	AAS
14	ABA	ABAC, ABACA, ABACAS, ABACI, ABACK, ABACS, ABACUS, ABAFT, ABAKA, ABAKAS, ABAMP, ABAMPS, ABAND, ABANDS, ABAS, ABASE, ABASED, ABASER, ABASES, ABASH, ABASIA, ABASK, ABATE, ABATED, ABATER, ABATES, ABATIS, ABATOR, ABATTU
15	ABAC	ABACA, ABACAS, ABACI, ABACK, ABACS, ABACUS
16	ABACA	ABACAS
17	ABACAS
18	ABACI
19	ABACK

Please Login or Register  to view this content.

[makinmomb]

Thank you karedog on the modified macro it did pull the words successfully as needed

ABA ABAS ABASE ABASER ABASERS
AME AMEN AMEND AMENDE AMENDED
AME AMEN AMEND AMENDE AMENDER
AME AMEN AMEND AMENDE AMENDES
AME AMEN AMENT AMENTA AMENTAL
AMI AMID AMIDO AMIDOL AMIDOLS
AMU AMUS AMUSE AMUSER AMUSERS
ANT ANTA ANTAR ANTARA ANTARAS
ANT ANTI ANTIC ANTICK ANTICKE
ANT ANTI ANTIC ANTICK ANTICKS
ARC ARCH ARCHI ARCHIL ARCHILS
ART ARTI ARTIS ARTIST ARTISTE
ART ARTI ARTIS ARTIST ARTISTS

[karedog]

You are welcome, glad to help.

Regards

[makinmomb]

Karedog small modification , word lists added letters and 8 letters

I need two macro , one where the link ends at 7 letters and the other one upto 8 letters connect

Please do your magic

Thank you

[makinmomb]

Attached is the file

Thank you in advance

[makinmomb]

I was not able to paste too many words since it was crossing the limit of attachment

[makinmomb]

Added 7 letters zip file for testing purposes

[makinmomb]

And the final adds of 8 letter lengths

[makinmomb]

Thread to be handled by Karedog likely

[AliGW]

You really should know better by now! Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[makinmomb]

Macros is not my cup and I have no time for this , I am busy into something else ,
provided I am not in a hurry so I will wait

[makinmomb]

Can anyone else edit that macro before karedog sees it , I wont mind

[AliGW]

This thread is open to anyone to respond. You have been asked to be patient. Please do not bump this thread again until a day has passed. If you have had no response then, you may bump it again.

[makinmomb]

Karedog has not seen it looks like , just bumping the thread for it to be seen again , since 2 days past

[makinmomb]

Anyone re bumping at 3 days

[AliGW]

Maybe you have not stated your requirement with enough clarity. Either that, or helpers would like to see what you have tried: you should be able by now to adapt what you have learnt here to each of the new scenarios you ask about, but you show no sign of having tried to understand the solutions offered. Maybe that's why there is an apparent reluctance to help?