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
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
A text file is hard to try code on to check that the code does what you need.
Attach a workbook with a before and after
see this attachment jolivanes each and every detail is mentioned
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
Your attachment does not resemble your Post #1 at all.
Unfortunately, as you described in your attachment is way beyond me so I'll have to bow out.
You'll have to wait till somebody more knowledgeable jumps in.
Good luck
Thnx for ur precious time jolivanes i will wait for that knowledgeable guy
Remove this thread i will start a new thread bcoz its diiferent from post 1
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
Anyone more Knowlegeable in Excel plz look into it
I think No one knowledgeable Vba code developer in Ozgrid and i also think u answer only simple question
:congrats:
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
You can complain as much as you like but there is no explanation anywhere. Just a before and after but no explanation on why these rows are to be deleted.
I'll give it one try and that's it. No good, you're out of luck from my side until you take the time and explain things properly.
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
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
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
Kindly see this attachment joli this post is regarding this problem and thnx in advance joli
Copy data from sheet1 and paste to sheet3,sheet4,sheet5,sheet6 aa shown in the attachment
I can't see how you arrive at the result wanted.
No proper explanation, no more answers from me. I am sorry
I can't see the logic between Sheet1 and Sheet2. Maybe someone else can.
BTW, you're right. The code in Post #14 was for another thread. Good catch
Don’t have an account yet? Register yourself now and be a part of our community!