Avinash Singh
asked on
copy the data from sheet1and paste that data to sheet2 each first empty row of each row into each table(in 4 tables) as shown in the sample file
column highlighted in red colour nothing to do with that and we don't have to consider the red highlighted colour column, No role of that data
the coloumn highlighted in yellow colour we have to work on that
copy that data and paste that data to sheet2 each first empty row of each row into each table
in sheet2 also we don't have to consider the red highlighted coloumn no role of that coloumn
I have posted the question before also the code was proper but my data is alpha numeric in red highlighted coloumn so that code does't work so that's y don’t consider red highlighted coloumn
See the sample file
Book2.xlsm
the coloumn highlighted in yellow colour we have to work on that
copy that data and paste that data to sheet2 each first empty row of each row into each table
in sheet2 also we don't have to consider the red highlighted coloumn no role of that coloumn
I have posted the question before also the code was proper but my data is alpha numeric in red highlighted coloumn so that code does't work so that's y don’t consider red highlighted coloumn
See the sample file
Book2.xlsm
This is a duplicate of another question https://www.experts-exchange.com/questions/29100507/copy-the-data-from-sheet1-and-paste-that-data-to-sheet2-each-first-empty-row-of-each-row.html reported
ASKER
This is different, it is not completely same Sir
Have u open the sample file
Open both the files and see they are different they are not completely same the work which we have to do is different
Have u open the sample file
Open both the files and see they are different they are not completely same the work which we have to do is different
Why do you keep asking variations of basically the same question?
Where's the code that you say does not work?
It's not clear what you want to achieve, give a better explanation.
Where's the code that you say does not work?
It's not clear what you want to achieve, give a better explanation.
ASKER
My data is alpha numeric in the red highlighted column so that's y the code is not working but this time we will not conclude that column so the problem will be solved
And I have 2 variation 1 is solved and this is the last variation
And I have 2 variation 1 is solved and this is the last variation
Which code is it? Can you provide the link to the other question.
That code is totally different to what you need. I posted some code for a similar question of yours, I believe the sample was workbook9 which I don't have available at the moment.
I've found the code that I think that you want editing.
Can you explain which sheet contains the data & where to copy to
Can you explain which sheet contains the data & where to copy to
ASKER
See the sample file
ASKER
The link which i shared with u it's solved and this post is pending for solution so look this post sample file not the solved sample file of the given link
I have looked at the sample file and it's not clear what you want to achieve.
The link you provided is solved but the code in it is not applicable to this problem. My solution that I also provided is more applicable to this problem.
It would save a lot of time if stated clearly what you want to do instead posting variations of the proble, I've lost count how many similar questions that I have seen
The link you provided is solved but the code in it is not applicable to this problem. My solution that I also provided is more applicable to this problem.
It would save a lot of time if stated clearly what you want to do instead posting variations of the proble, I've lost count how many similar questions that I have seen
ASKER
See this post forget everything (shared link) and solve the problem
See this post forget everything (shared link) and solve the problem
I don't work for you or EE!!!
ASKER
Sorry Sir u got me wrong actually it was my request not an order type thing actually i wanted u to foregt the link concept otherwise u will be confused that's y i told u Sorry sir it was not my intention
I still need clarification ob what you want to do
ASKER
column highlighted in red colour nothing to do with that and we don't have to consider the red highlighted colour column, No role of that data
the coloumn highlighted in yellow colour we have to work on that
copy that data and paste that data to sheet2 each first empty row of each row into each table
in sheet2 also we don't have to consider the red highlighted coloumn no role of that coloumn
Book2.xlsm
the coloumn highlighted in yellow colour we have to work on that
copy that data and paste that data to sheet2 each first empty row of each row into each table
in sheet2 also we don't have to consider the red highlighted coloumn no role of that coloumn
Book2.xlsm
ASKER
Sir we have to solve this problem nothing else
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thnx Roy Cox Sir, David sir for giving ur precious time to this post
Problem Solvef
Problem Solvef