Search results

Got both, I'll take a look. Many thanks. I'll let you know if it works or if I have any questions.

Yes, nothing there

Faseeh, haven't received anything. Could you resend or upload here. Thx

Faseeh, did you get me email regarding some of my concerns and questions?

I sent a few minutes ago, let me know if you didn't receive. Thanks again.

Thanks Faseeh, I have several questions which might be easier if I sent by email where I could inclose a picture (using snagit) what I'm asking about. Let me know if thats OK? I'm I mistaken or can I assume you just have a sample of what I earlier posted? Looks like 316 items and of course...

I don't know how to use VBA. Do I need any prior knowledge?

The file I downloaded earlier my have been read only. Will that infer with making changes on it?

Faseeh, I didn't mean I was frustrated with anyone who has helped. You guys have been great. I was frustrated at me for not being able to complete the instructions. I hope no one misunderstood my comment as being directed at them. I truely apologize if it was taken that way.

That's right. Seems simple stating that but I keep messing up when copying and pasting. Information can be put on another sheet as long as the information is there.

I am very frustrated. The information you have provided is probably correct but I keep coming up with errors. I have downloaded the file for preview. Again, what I am trying to do is eliminated duplicate routing numbers but retain the text. I was able to accomplish the first step; COLUMN F...

Faseeh, many thanks. Exactly what I wanted. Have a great week!

Goal is to cut down over 12000 routing entries (sheet 1) down to 4000 (sheet 3)by eliminating duplicate part numbers. Probably easier to understand starting from sheet 1 information. In column A, I have a list of routing numbers. Some numbers appear more than once (because of comments in...

Trying to figure out how to solve Concatenate formula that would have 80 characters. Since many of the cells would include more than 80 characters, I need the overflow to go to the adjacent cell. On sheet 3 of this file, I have eliminated duplicate routing numbers (found on sheet 1), but...

I think I was able to eliminate the duplicate routing numbers on Sheet 3. I could use the Concatenate formula to combine columns B thru G, but the system I need to export this to only can handle 80 characters. For those routing numbers, I will have to show more than once to accommodate this...

Your right. Of course they didn't tell me until after I we did this. But it did eliminate over 8000 part entries. Now I need to manually review the Concatenated cells and correct any words that are split. Thanks for all your help so far. I think all that is left is spot checking.

I check that out. Is there a way for the Concatenate cell to limit to 80 characters and put overflow into another cell? Our system for entry is limited to 80 characters so need to put overflow in another cell below or to the right with the part listed. Is that possible?

For some reason, some of the cells are missing a character. Not sure why since the majority is correct. Should I try a entering the Concatenate without copy and pasting. Only problem is I have 4000 lines to check. Do you see anything here. I highlighted a row 4 in gray as example. Missing "t"...

By George, I think I done it! Thanks everyone who helped. This is a great forum. I will recommend to others to join.

yes, I see what you did and it got rid of duplicate part number. I should be able to do the next step; Concatenate. I think my brain is fried. I did this once. Which cell/column do I do the formula, the last one and select the cells, then copy and paste?

I'm not concerned about the time. Since there are over 10,000 parts/comments listed in sheet. I just need to summarize or shorten it so one part shows all the comments. I can try the VBA solution with "baby steps" guidance. I wasn't sure of the other information above or what you meant by...

Yes, Luke sounds too much. You guys are definitely Ninja's. Need to take his excel course or get book. I don't even know where to get the file back you referred to and if I did, no clue how to use VBE

Layman terms. Don't know what you mean or where I put Dim objDic but I'll keep playing around with it.

Ok, here is the download link to what I'm working on. Trying to reduce the number of duplicate part numbers while combining the texts into one. https://hotfile.com/dl/175379633/5411562/sonnyatoak_file.xlsx.html