Need help to create a macro to automatically copy in one sheet and copy in the other
I have an excel sheet in which the data is slightly mixed up. In each operation 4 rows in a column have to be cut and pasted in transposed way in the other sheet. After that it has to copy one more cell (that is 2 cell from the last copied cell) and paste in the same sheet , next to the previously copied. After this it has to return to the previous sheet. Also, for the next cycle of cut paste , it should start pasting in the next row
PLease help.. It is a bit urgent
Your request gives a good idea of what you want, but is not specific enough for which to write code. If you could include a sample workbook with desired results, you might get some help.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks for the replies. I should have uploaded the sheet along with my query. My bad. Please find the attached. I have showed in the sheet 2 , the format in which i wanted (colour has no relevance ) The next set of data should be pasted below it
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks