If cell is in range update formula in another column

[ayyappan80]

Hi setting help of someone

In my active worksheet column B
I have numbers like from 10,000 tu 70000

If my b column is greater than 39000 and less than 60000 then I need formula on column G

The formula is mid function of column D
MID(RC[-4],9,5

If the results of column G is "0000" then need to filter those rows copying from B2 to G
And paste in new worksheet

I tried with below code but getting error.

Please Login or Register  to view this content.

Seeking help to create VBA code

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[nigelog]

@ayyappan80, it is easier to get an answer if you attach a workbook with before and after results shown. This will answer such things as is the new worksheet to be created by the macro or are the filtered results copied to a pre-existing sheet

[ayyappan80]

@ayyappan80, it is easier to get an answer if you attach a workbook with before and after results shown. This will answer such things as is the new worksheet to be created by the macro or are the filtered results copied to a pre-existing sheet

Hi Negilog

Thanks. Results to be copied in sheet2

[nigelog]

You're not exactly helping yourself here

Utilise this

Please Login or Register  to view this content.

[ayyappan80]

Hi nigelog

Code is working as expected. Thank you so much for your help. Apologies for not attaching sample workbook, surely will consider in future posts.

[ayyappan80]

Hi Nigelog

is it possible to exclude number "22000" and "48000" on the below line. Sorry for this additional

Please Login or Register  to view this content.

[nigelog]

Not tidy but should do --- I deleted workbook i mocked up

Please Login or Register  to view this content.

thanks for feedback and rep and for marking as solved