Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I am fairly new to creating macros and am stuck on something... Here is the sequence that I want to follow: 1. I need to delete every third starting at row 3 (3,6,9,12,etc) and move information up 2. Cut and paste every other cell starting at A2......A300 i.e. (2,4,6,etc) after those cells from part 1 have been moved up and moved over to column B starting at B1 with no spaces between the information 3. Then the newly blanks cells in column A need to be moved up.... Is it then possible to take the first 12 spaces of the cells in column B and move them over to column C? Sorry if I put too much for a first post but I am stuck. Thanks to anyone who can help -- ajjag ------------------------------------------------------------------------ ajjag's Profile: http://www.excelforum.com/member.php...o&userid=35799 View this thread: http://www.excelforum.com/showthread...hreadid=555717 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |