Edit a small code to remove error

**moonbreakker** · 07-29-2015, 05:38 AM

Hello,

Credit for the codes to Skywriter.

In attached sheet, macro2 (StatusMove) only has the issue. It runs fine IF and ONLY if all three entries (Delivered, Hold, Rejected) are present in column H. If any of the three is missing it gives 1004 with cells not found error.

I want it to run with any of the entries. And if H is blank, it can give message like Status is empty or something.

Any help will be greatly appreciated.

Please Login or Register  to view this content.

Thank you.

**Parth007** · 07-29-2015, 06:49 AM

Hello Moon,

Check the file now...

**moonbreakker** · 07-29-2015, 07:03 AM

Thanks Parth,

When new data is pasted to sheet1, i need to compare with sheet (delivered,rejected,hold) to check if new data already does not exist in any of those sheets. If so give some warning and in sheet1 column G show message duplicate, or status etc. How can i achieve that?

Thanks.

**Parth007** · 07-29-2015, 07:42 AM

IF you have any unique column in Sheet1..
considering Customer Number is unique you can match the column values with other sheets & plot the data in column G is found.. may be you need to see if the code can work out..

**moonbreakker** · 07-29-2015, 07:47 AM

Can we match name mobile no and model? There is 0% possibility of all three matching.

**Parth007** · 07-29-2015, 07:53 AM

Yup you can.. see if you get the code in working condition

**moonbreakker** · 07-29-2015, 07:56 AM

Well, i am new with VBA.
Anyways, thanks for your help.

**Parth007** · 07-29-2015, 08:09 AM

Hey Moon,

Below is sample code which match one column value from sheet1 & sheet2 & insert value in G column, you just need to see how the vlaue can be plotted

Please Login or Register  to view this content.

Experts please help me in getting this code work for Moon..

Edit a small code to remove error

LinkBack

Thread Tools

Rate This Thread

Display

Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Re: Edit a small code to remove error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Blank cell gives error 13 (Mismatch) in loop - edit code to accommodate for blanks

[SOLVED] Macro small edit

[SOLVED] Remove the error and clean my code to send mail automatically from excel

Error when executing VBA code to remove all formulas from Workbook

Edit code to loop error msgbox and inputbox until valid date is entered by user.

[SOLVED] Coyping results in Run-TIme Error 424, Need help to edit code

Getting Error 400 with following code. How do I remove it?

Bookmarks

Bookmarks

Posting Permissions