Help with VBA/Macro to copy and paste values based on criteria

Hi,

I would like some help with creating a macro which copy and paste values over the formulas based on a criteria please.

The aim of the macro is to copy and paste values over the formulas in Column P and U in the Provider Detail tab, if the value in column L is less than the value in C4 within the Activity and Finance tab. The macro must repeat the loop until it has reached the bottom of the table.

The attached is an example of the layout of the spreadsheet which requires the macro.

Would anyone be able to assist as my knowledge of vba/macros is very limited.

Thanks in advance for your help
Bhaz

Originally Posted by than_gold

What should do if col L value > C4?

the formula should remain if col L value >= C4

i have tried writing the following vba but am getting an compile error message "end with without with".

Please Login or Register  to view this content.

could you please advise on how to fix it?

thanks in advance for your help

Hi !

You failed with the order of your End With and Next …

Originally Posted by Marc L

Hi !

You failed with the order of your End With and Next …

So should it be;

next
End with

?

Yes !

Classic issue with a not or bad indented code …

could you please fix this for me as my vba knowledge is limited and I dont understand what I'm doing wrong;

Please Login or Register  to view this content.

Thanks

Seems code has logic issues of using object variables but for criteria better as efficient is to use a filter or an advanced filter
as you can yet operate manually so with the Macro Recorder you can get your own free base of code …

Originally Posted by Marc L

Seems code has logic issues of using object variables but for criteria better as efficient is to use a filter or an advanced filter
as you can yet operate manually so with the Macro Recorder you can get your own free base of code …

I dont understand the logic for writing the code, could you please help me

As any beginner can do, activate the Macro Recorder, apply a filter then copy, …
In case of an optimization need, post here the generated code explaining what you need to be improved.