Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michael A
 
Posts: n/a
Default MACRO - copy rows based on value in column to another sheet

Any help would be greatlyi appreciated.

I need a macro that copys rows on a spreadsheet to another spreadsheet based
on the value thats in the B column. For example, b4 has "RES" as the value,
so i want row 4 to go to the first available line on the RES sheet. If it had
"BOB" as the value, i would like it to go to the BOB sheet on the first
available line. I would like to be able to do this with the entire sheet.
Thanks!
Reply
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
inset rows and copy formatting , excel macro sloanranger Excel Discussion (Misc queries) 13 March 10th 05 12:44 AM
Activate a macro to insert a row and copy the formuals from the rows above to the blank row oil_driller Excel Discussion (Misc queries) 1 February 11th 05 04:30 PM
how to copy 2350 hyperlink full paths to any column in a worksheet ? kontiki Excel Discussion (Misc queries) 4 December 10th 04 11:00 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 3rd 04 12:04 AM
macro - adding rows to a column that is summed HGood Excel Discussion (Misc queries) 2 December 1st 04 04:28 PM


All times are GMT +1. The time now is 02:42 PM.

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

About Us

"It's about Microsoft Excel"