Hi guys- I was wondering if there was a way to create a macro to move data like I have in my attachment ("Before" vs "After")
I really have been struggling on this and no expert on macros so any help would be great- thank you!
Accidentally posted on Excel General Forum as well- http://www.excelforum.com/excel-gene...move-data.html
Last edited by mattmurdock; 07-18-2012 at 01:53 PM. Reason: Added link
Hi
Try this
rylo
Please Login or Register to view this content.
Wow This worked awesomely- I can't thank you enough! Thanks!!!
Last edited by Cutter; 07-19-2012 at 07:40 PM. Reason: Removed whole post quote
In my actual workbook I currently have 53 columns, but the user is going to add more columns of data. How should I make it so that it works for 53 columns plus any more they add?
Hi
I've changed it so that it finds the last used column based on data being in row 3.
ryloPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks