condition paste vba

I have the following code which works well but i now need to copy J & K if the condition is met I have tried a couple of ways but cant get it to work so use same module but for J it would be much quicker if i could do them both together as there are often about 4-500,000 lines of data but on...

Hi, I am new to VBA, and have searched the forum a lot, but I couldn't find a solution that exactly matches what my code requires. What I basically want to do, is to loop through a lot of cells in a column, and if a condition is met, I want to copy the two cells next to it in to another sheet...

Hi, I am working on a macro which copies data from multiple sheets, creates a new sheet and pastes it in the new sheet sequentially and then sorts the data based on a column called "Region". But, every time this macro is run the conditional formatting rules change their ranges and multiply...

Hello, Firstly please let me advise that standard conditional formatting will not work here as this requires ten conditions to be set. I have a worksheet that contains 40 'paired' columns. In the first column of each pair I can enter any one of ten condition codes. The corresponding cell in...

Hi, Thanks for helping in advance.... Is there any possibility, I copy a range (J1:M1) in an active sheet and paste it downwards at every row where there is a text "Memb" in column A until the last Memb in Col A. Example Copy Range J1:M1 and Memb is present at 19th row, so the range must be...