Posts by dtwk

Re: Clear Cell If Cell To The Right Is Empty

I need a macro for this ><

Hi

If I have 2 columns A and B, I would want cells in A emptied if cells in column B is empty. Otherwise, ignore.

Any advice?

Thanks

Re: Match Cells From Tables &amp; Shift Rows Down If No Match

Thanks ger for that long post... much appreciated for your efforts... although it doesnt work perfectly, i think i could work on it for the time being... cheers

Re: Sort AlphaNumeric Text By Numbers

Nice Badger... It works perfectly... Thanks a lot to all u guys... been a great help since i registered to this website... Thanks to Dave and all... /bow /salute

Re: Sort AlphaNumeric Text By Numbers

Dave

ABC10 will still come before ABC9 even thought 9 < 10... =(

Re: Match Cells From Tables &amp; Shift Rows Down If No Match

Oops... ok i hope its changed...
To ByTheCringe2... sorry about that any solution to my problem?

Re: Matching Cell From 2 Tables And Shitfing Rows Down If Cell Does Not Match

Updated the Matchtest.xls field for columns B and M to make it easier...

Cheers

Re: Matching Cell From 2 Tables And Shitfing Rows Down If Cell Does Not Match

I got the first 2 parts working

If Cells(1, 2).Value < Worksheets("Sheet1").Cells(1, 13).Value Then
    Range("M1:V1").Select
    Selection.Insert Shift:=xlDown
    Exit Sub
    End If
    
If Cells(1, 2).Value > Worksheets("Sheet1").Cells(1, 13).Value Then
    Range("B1:K1").Select
    Selection.Insert Shift:=xlDown
    Exit Sub
    End If

Need help with the third part on what if its equal or how to loop the procedure again for the next row

Re: Matching Cell From 2 Tables And Shitfing Rows Down If Cell Does Not Match

Basically what I am trying to achieve is this:

If cell B1 < cell M1, shift cells M1:V1 down 1 row
If cell B1 > cell M1, shift cells B1:K1 down 1 row
If cell B1 = cell M1, Look at next row cell B2 and do the procedure again.

Any advice?

Cheers

Re: Sort AlphaNumeric Text By Numbers

Yes dr.
Its the same ABC followed by a set of numbers.

Cheers

Hi All

Im having problems with the above.
Attached is a spreadsheet of 2 tables from B:1 to V:5
I need to shift either rows down if cells from column B do not match column M and vice versa.

How would it be possible to acheive results as shown in B:10 to V:15 through VBA.

Thanks in advance.

Re: Sort AlphaNumeric Text By Numbers

Thanks for the swift reply.

However, Due to circumstances, I am not allowed to create an additional column. Would there be a macro to do all this together?

Cheers

Hi

Take for example ABC10 in Cell A1, ABC199 in cell A2 and ABC9 in cell A3

How am i able to sort such that ABC9 appears in cell A1 followed by ABC10 in cell A2 and ABC199 in cell A3?

VBA advice would be appreciated.

Thanks.