Conditional Delete Cells and shift to the left

Hi,

I have an input data like that:
--A-B-C-D-E-F-G
1-5-7-7-7-5-7-5
2-7-5-5-5-7-5-7
3-5-5-5-7-7-5-5
and so on...

an output data I need:
--A-B-C-D-E-F-G
1-7-7-7-5-7-5
2-7-5-5-5-7-5-7
3-7-7-5-5
and so on...

as above, macro must to delete number 5 from left to right until not contain other number, and shift to left

my problem is similar to below:

Please Login or Register  to view this content.

above macro works good, but only for one row...

any help?

ps. I have also other variant my data, like this:

input data:
--A-B-C-D-E-F-G
1-5-6-3-8-4-1-5
2-9-5-5-5-6-5-44
3-5-5-5-6-4-5-5
and so on...

output data:
--A-B-C-D-E-F-G
1-6-3-8-4-1-5
2-9-5-5-5-6-5-44
3-6-4-5-5
and so on...

I'm not clear... Do you want to delete all 5's?

Hi, markos97,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

Yeah - That's it!
Macro works perfectly for me!
Thanks a lot HAHOBE, AndyLitch also many thanks!
and you - mahaveersomani (yes I remember) - ps, your code not exactly do what I need (save blank space between cells)

Hi, mahaveersomani,

your code will delete every occurrance in the sheet, not only those at the beginning of each row until any other number is found.

Please Login or Register  to view this content.

Ciao,
Holger

Hi, mahaveersomani,

using your approach the code may look like

Please Login or Register  to view this content.

Ciao,
Holger

one again, thank you HaHoBe, now your code looks like:

Please Login or Register  to view this content.

I need change this part of code

Please Login or Register  to view this content.

to something like that:

Please Login or Register  to view this content.

but it does not work like I wanted;
I need only clear this cells (not shift to left in this moment), I'm try it, but the cells go to up...

--edit--

as above my input data looks like

--A-B-C-D-E-F-G
1- -7-7-7-5-7-5
2-7-5-5-5-7-5-7
3- - - -7-7-5-5

Hi, markos97,

sory but a sample workbook with what it looks like now and what it should look like after the macro would make things clearer. What should be cleared in Column A/B/what cells? The new sample isn´t explaining itself, and there is not 5 or 55 in the fist column as far as I can judge.

Ciao,
Holger

Hi, markos97,

to my opinion this is a different problem to what you originally asked help for.

Code for a standard module:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, markos97,

with an error

If that should mean the cells haven´t been changed I´ve got it. If not please explain the error that you mean.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Ciao,
Holger

maybe you can't open my attach "condtdelcells2.xlsm"?
maybe see, the screen (this sceen presents data after running the code)

ps, my USED (non-blank cells) range is A4:AD2377 (in this case) - but this is not a whole range to clear!

Hi, markos97,

I´m afraid I got the problem wrong this morning - resulting in a wrong code. Let´s start it over again and maybe you can give this code a try:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, markos97,

glad we finally got it sorted out the way you expected it to work. Could you please mark this thread as Solved via Thread Tools? Thanks.

Ciao,
Holger