asked on

copy the data from sheet1 as per given condition and paste to sheet2

Nothing to do with yellow highlighted colour data, highlighted colour is only for understanding purpose in actual file there is no highlighted colour
what I want is to copy the data from B to A
see the sheet2, I have putted the result to sheet2
copy the data from sheet1 as per given condition and paste to sheet2

i have to do all this by vba only
Sample-file.xlsm

Roy Cox

Again, I have provided code to do a similar exercise. Can't you adapt code that you have been given previously?

Avinash Singh

ASKER

This is similar But very different from that question Roy Sir
I know u have provided the code for that but this is different

Roy Cox

Is this what you mean?

EDIT: upload amended example to include column E
Sample-file--3-.xlsm

Avinash Singh

ASKER

Roy Sir Plz look into the sample file that i have uploaded see how conditionally we have copied each data sets from sheet1 to sheet2
we have to do that

Roy Cox

What do you mean, there's no conditions on sheet 2 to compare?

Avinash Singh

ASKER

We dont have to compare
We have to copy data from sheet1 and paste to sheet2 as per the given condition
As shown in the sample file

Roy Cox

What condition?

Avinash Singh

ASKER

Copy B to A data sets from sheet1 and paste to sheet2
And if there is Continous A back to back(suppose there is 3AAA back to back ) then Copy B to A then B to AA and then B to AAA and so on

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Avinash Singh

ASKER

Thnx Neeraj Sir for giving ur precious time and great support to this post

Subodh Tiwari (Neeraj)

You're welcome Avinash!