Move the content of specific groups of cells in column C to the first cell in that group
Hi Gurus:
I am trying to get a VBA code to help me move the content of specific groups of cells in column C to the first cell in that group.
A sample file with "Original" & "How I want it to be" sheets is attached and the requirement is written.
Thank you for your kind help and have a wonderful day!
Chris
Move the content of specific groups of cells in column C to the first cell in that group.xlsx
Last edited by aviatecar; 09-03-2014 at 03:16 PM. Reason: Solved
Try this
Open up the VBA editor by hitting ALT F11
Please Login or Register to view this content.
Insert a new module by hitting Insert - Module
Paste the macro into the empty sheet
Hit ALT F11 to get back to the worksheet.
Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
Martin
Thank you Mrice! It works like a charm!
Hello Mrice:
I need this code to repeat automatically on each worksheet within the same workbook.
Would you mind looking at my new thread and help me solve this problem?
http://www.excelforum.com/excel-prog...-workbook.html
Thank you,
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks