Comma to Trigger new row content

[ryanb4614]

I run this macro script. With the new software I will be using to upload this I need some how if there is a replacement with a comma...I need just 173 to go in a row under 177 with no more comma... is this possible with macro?

Please Login or Register  to view this content.

[jason.b75]

Try

Please Login or Register  to view this content.

Wrap text needs to be true for that to work.

[ryanb4614]

This won't exactly work for what I do. I do not enter each replacement manually I have this setup in a formula.

Please Login or Register  to view this content.

for the numbers for example is use this code:

Please Login or Register  to view this content.

This pulls 177,173 from another sheet and if there is not another it will not include the comma and other number...So now what I need is if there is another number in sheet one example L14 it needs to go on the row below.

---------- Post added at 09:29 PM ---------- Previous post was at 09:13 PM ----------

And the code above does not put it in its own row

---------- Post added at 10:33 PM ---------- Previous post was at 09:29 PM ----------

basically I am looking for a if command that would move the content if there is anything in sheet1 like the if command above. I just need there to be no comma and go to the row below.

[MarvinP]

Hi ryanb4614,

I'd need a quick sample file with what you have and what you expect to understand this problem better.
Are you looking for only 177,173 or will it be more than 2 numbers separated by commas? Will they be in Col A or some other Column. Will the original data have all rows filled? IE - will this need to insert a blank row to insert the 173? We need a sample file...

To attach a sample file, Click "Go Advanced" and then the Paper Clip Icon above the advanced message area.

[ryanb4614]

Hello. Please see the sample that is attached. At the Fish/Aquarium Filters/Sumps,Fish/Aquarium Filters (where the comma is) I don't need the comma I need it to go directly in the row below creating a new blank row....when I run this macro script. Please see "After Macro I need it to look" sheet

[MarvinP]

Hi ryanb,

Your example needs a few more peices to it. I don't see where or how the comma fits into this problem. I also need more rows with full data of what you have and what you want to get.

[ryanb4614]

Thank you for the reply. To make it easier I just need it to take the content with a commma to a next new row.
I found a macro but it doesn't do exactly what I need. The script does not create a new "blank" row with just that content in it.


It divides this category which I can't have it do that:
Dog/Collars, Harnesses & Leashes

An attachment is attached as requested.

Please Login or Register  to view this content.

[MarvinP]

Hey ryanb,

I have no idea how the 177 and 173 fit with your attached file. Did you attach the correct file? Did you change the problem? Do you know you have lots of duplicates in Col A of the attached? What should happen with duplicates?

[ryanb4614]

Yes I will not be using the numbers now I need to us the text. So in the "checkthis.xlsx" file is correct. I just need anything with a comma in the middle of the category to create a new row and then the text after the comma to go directly after it. The only issue is again the category with Dog/Collars, Harnesses & Leashes

I know there are alot of duplicated these are the categories for each product. The attached file is correct.

[ryanb4614]

There is content left and right. The way this needs to upload is the items in column C with a comma needs to go to a new blank row. But it cannot carry any of the content in the new row that is to the left and right of it. Macro would probably be the best method? It needs to ignore Dog/Collars, Harnesses & Leashes where this is one category. New attachment is attached.

[jason.b75]

I'm still lost see if this works, there is some overkill in the code to allow for the possibility of multiple commas in 1 cell.

Please Login or Register  to view this content.