Removing spaces between data by macro

**ad9051** · 11-29-2011, 01:25 PM

Hello guys many thanks for taking the time to look at my problem essentially i need to remove spaces between data by macro. I enclose an example showing what i have and what I need, with description.

Many thanks

Alan

**Steffen Thomsen** · 11-29-2011, 01:36 PM

Hi,

Try this

Please Login or Register  to view this content.

This has to be inserted into the sheet code module.
Whenever a value is updated in column c it's automatically inserted into column b

**Hyflex** · 11-29-2011, 01:59 PM

Steffen Thomsen,

I think he wants a macro to basically squish the code into one continuous column of data...

**ad9051** · 11-29-2011, 02:33 PM

Yes correct i do want it squished, not simply copied to the column to the right.

Cheers

Alan

**Steffen Thomsen** · 11-29-2011, 02:46 PM

If data in column A should stay then

Please Login or Register  to view this content.

If data in column a should be deleted as well then

Please Login or Register  to view this content.

**GeneralDisarray** · 11-29-2011, 03:30 PM

This works on the test data. Attached is the "squiser2000" --- good for all your squishing needs

Please Login or Register  to view this content.

----Edit----

Wait...did i totally miss something? where you looking to delete the entire row of information if the b column was blank? I thought you were wanting to just adjust the B column and leave the other columns untouched...either way stefen() was way more slick... didn't see that before i went off to create this...

Stepping backwards from the bottom...totally forgot you could change the step to a -1...much simpler