What I am looking for is to copy column E and then insert the copied cell below the orginal so if you have 1 through 5 in column E
1
2
3
4
5
the macro will copy column E then insert the copy below so it'll look like this
1
1
2
2
3
3
4
4
5
5
Thank you for your help if you need any more information please let me know
Last edited by awagenhurst; 09-18-2013 at 04:55 PM.
Change the name of sheet3 to suit your needs.
Please Login or Register to view this content.
No macro
1) Sort the range first.
2) copy the range and paste to the first empty cell below the range.
3) Sort.
It seems to work great just for column E, I dont need to have only E doubled can Column A through E be doubled. Sorry didnt explain it well enough
Assuming the value of double comes from column E, change this line
INTOPlease Login or Register to view this content.
If this does not work, I need to see a sample with a desired result.Please Login or Register to view this content.
Thank you Works GREAT!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks