Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Unknown1256
 
Posts: n/a
Default Copy If Ability for Excel Data

Is there a way to copy data in Excel only if a condition is met, like if I
selected a series of rows containing data and only wanted to copy certain
rows out of the selection that met a certain condition in one of their cells,
can Excel do that?

I have a workbook of customer contract data (on one master sheet) that
contains several worksheets of different customer names. I want to be able to
select the entire master sheet and tell Excel to only copy data to "Bob
Jones" sheet if the name in column A on the master sheet equals "Bob Jones".
I'd use links or filters but there are about 30,000 row items and I was
wondering if there was a smoother way of doing it. FYI: I'm not a programmer.
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
using programming to copy worksheets data only maxzsim Excel Discussion (Misc queries) 1 November 29th 05 06:02 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 14th 05 12:33 AM
How do i copy columns of data in notepad into microsoft excel? JP New Users to Excel 2 February 10th 05 10:47 PM
How do i copy columns of data in notepad into excel? JJ Excel Discussion (Misc queries) 1 February 10th 05 10:21 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 10:20 PM


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