Help! combining 2 VBA codes

[iamreese]

How do I combined these 2 codes into one VBA code?

The first code is a recorded macro

Please Login or Register  to view this content.

The second code is

Please Login or Register  to view this content.

[tom1977]

maybe You can use call method

Please Login or Register  to view this content.

[iamreese]

Hi..thanks for the quick reply..

I tried running the code you suggested and it did run correctly except for the third row where it did not delete the empty cells and gave me a debug error message

[tom1977]

Hi
Could You send the sample file with description what You want achieve

[iamreese]

attached are 2 excel files.

start.xlxs refers to the original file before applying the code

result.xlxs will be the end result after applying the code. I had to run 2 codes separately.

[tom1977]

try to use this
If You have a lot of data it could take a moment

Please Login or Register  to view this content.

[iamreese]

Hi..the code was almost perfect but some issues

1. If cell in column C is empty, corresponding columns A and B should also be deleted.
2. empty cell in column A should copy the cell above it.

[tom1977]

please check attachment

[iamreese]

^^ hi..see 2 issues on my prior post

this conditions should be met:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[tom1977]

Hi
I am uploading new file because in the previous one was mistake (the results are the same You wanted in your file call "results")

p.s. I do not follow your last post....