Posts by dgfsag

My data
1 2 3 4 5 6 17
2 3 4 5 7 8
1 2 3
15 16 12 18
If 17 is found in a row then delete complete row
In this example row 1 will be deleted

Copy data from sheet1 and paste to sheet3,sheet4,sheet5,sheet6 aa shown in the attachment

Kindly see this attachment joli this post is regarding this problem and thnx in advance joli

Now i understood what u have done joli
First of all Thnx alot for giving ur precious Time and for Ur great efforts
This code is of different post thnx for the solution joli by mistakely u have sended the code to this post I ran the code it works best and doing the same. What i wanted
Plz look into this post joli and thnx alot joli

And the delets part which u saying that is not delete that is clear content of the cells and that question is different and that post is also different and explanation is given in that post and in this post also
2nd thing explanation for what u can see the sample file in both the post what we have to do i told u
Now i need ur guidance for code
And i think no explanation is required now

We don't want to delete that joli sir kindly see the attachment in this post see the sample file of excel what i want is to copy the data and paste the data
the data which we copy are sets lots of sets
So we want to copy that sets and paste that sets as shown in the sample file
Now the pasting part why we r pasting the data like this
We r pasting the data like this bcoz i am researcher I want to analyze that data and for that i have maken a sheet with formulas and that will help me to analyze the data
I am doing Research so i don't know what will work so finding the same

Everyone is knowledgeful invba in ozgrid
ozgrid is known for its best quality vba codes
Only the thing disapointed me is if my question is a complex question plz let us know we will choose hire option in ozgrid bcoz i know for complex question i need to opt for hire option in ozgrid
The only thing and a small thing is whenever i visit to this website there is a hope that i will get rply from urs
But the thing is atleast let us know that this is the complex question kindly opt for hire option and we will help u at our best level

:congrats:

I think No one knowledgeable Vba code developer in Ozgrid and i also think u answer only simple question

Anyone more Knowlegeable in Excel plz look into it

Plz have a look in it

I just want to know that what i am trying to do is possible or not bcoz u told more knowledgeble so i am worried about my question

Kindly see the attachments

And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th part)seperately

Remove this thread i will start a new thread bcoz its diiferent from post 1

Thnx for ur precious time jolivanes i will wait for that knowledgeable guy

And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th part)seperately

see this attachment jolivanes each and every detail is mentioned

Thnx alot Daves i also needed the same

I don't want to clear only X clear all the sets that is affected by X
see this attachments see both the sheets
Sheet1 with X with affected data sets
And sheet2 without X and without affected data sets by X

I have the vba code but i want to change the pasting way of the vba code
Example
Data
1 2 3 4
5 6 7 8
By applying this code this code paste the data in this way
1 2 3 4 5 6 7 8
What i want is to paste the data in this way
1
5

2
6

3
7

4
8