Add text to cells with existing content - with a challenging twist!

[madjan]

This is solved, check new problem down!

Hi all!

After intense googling I didn't find the solution to my problem which is why I'm asking for your help!

I've got a macro which is running in a regular excel-file exported from one system. It is moving around columns and adding headlines to fit as an import into another system.
In one column, AF, I want to add the string "Att: " before the already existing content.
Since the number of rows differs from document to document I want it to add "Att: " (WITH content, if it's empty it shouldn't do anything) as long as column A has rows.

I've got a similar code from another column;

Please Login or Register  to view this content.

But this is replacing existing content and fills ALL cells in column C to "Y" on as many rows that there is in column A .

In my new case every column is unique and the existing content should remain with the adding of "Att: ".
I've tried:

Please Login or Register  to view this content.

But this only works for the first cell in the column ("AF2") and replaces that content into every other.

Please use the same column-names, string-names etc. in your solution. All headlines
are on row 1, the data starts att row 2 and should end when column A rows end.

Does this make sense?

Thanks in advance!


This is solved, check new problem down!

[tigeravatar]

madjan,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[madjan]

madjan,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Thanks alot, mate! Amazingly done. Saved my day!

Got time to explain your code row by row? I don't understand it to 100%!

Thanks once again.

[madjan]

I've got a new question, a spin off from the last solution.

I got a new column (M), this should add c/o: instead of Att: AND add a "-" to all empty cells. Everything else should be the same, i.e. stopp when rows in column A stops.

Please Login or Register  to view this content.

Anyone?

Thanks in advance.

[tigeravatar]

madjan,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[madjan]

madjan,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Thank you again, amazingly much!