Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to write a Macro that searches column B.
This column contains only "A's" and "B's" When it gets to the first row that has a "B" I want it to cut that certain cells in that row (from column A to column N) and then paste them up in cell(2, 13)column P to (2, 25) column AB. I want this to loop so that all of the rows with "B" in the cell will be moved over to be along side the data that has an "A". I have written the code for the search to find the "B" but I can't get the cut and paste to work. Also I need for everytime it finds a "B" to cut it must increment downwards for those values to be pasted. Can anyone help me. This action happens on the active worksheet. Shannon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spreadsheet pastes as picture | Excel Discussion (Misc queries) | |||
I cut and paste a pic & it pastes somewhere else in the doc, why? | Excel Discussion (Misc queries) | |||
A Macro that Copies from Excel & Pastes into a webpage | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
change a macro so that it copies and pastes data as values rather than references | Excel Programming |