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: 1
Default copy rows based on specific field value

Q5I am trying to create a macro that will copy specific fields from 1
spreadsheet to another, based on certain criteria.

Example. Copy cells A5 - I5 from current spreadsheet to new spreadsheet
only if cell B5 0.

At the same time I need to copy cells L5 to T5 from current spreadsheet to
new spreadsheet only if cell Q5 0

Need to do this for all rows in the spreadsheet.

How do you accomplish this??
 
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
copy rows to new sheet based on specific cell value dlballard Excel Worksheet Functions 5 April 24th 23 11:44 AM
How do I find and copy rows based on specific criteria? Georgew New Users to Excel 3 May 29th 09 11:07 AM
Moving data based on specific field thomaspb Excel Worksheet Functions 4 October 4th 08 11:38 AM
Copy table information and paste sorted based on specific field. Paul Excel Programming 1 August 5th 05 04:54 PM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 0 March 4th 05 04:27 AM


All times are GMT +1. The time now is 06:50 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"