LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Macro that cut and pastes

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet pastes as picture Worker Bee[_2_] Excel Discussion (Misc queries) 1 February 6th 09 01:28 AM
I cut and paste a pic & it pastes somewhere else in the doc, why? cut and paste and lost my picture Excel Discussion (Misc queries) 1 June 14th 07 01:09 AM
A Macro that Copies from Excel & Pastes into a webpage Eric Excel Discussion (Misc queries) 1 July 14th 06 12:38 AM
Excel macro that opens new MS Word file and pastes data as a pictu Rob Excel Worksheet Functions 0 July 6th 05 05:12 PM
change a macro so that it copies and pastes data as values rather than references Meg[_2_] Excel Programming 3 December 17th 03 09:35 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"