LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default Move Specific Data to Another Worksheet

Hi Experts: I'm really lost on this one...This is what I want to do:

On Worksheet 1: I have 32 Locations that have a # of Observations...I want
to take all the lines of data from Worksheet 1 for each separate location
that exceeds the # that is on Worksheet 3 in column H and populate in on
Worksheet 2.

Example of What I Want to Do:

Worksheet 1: Dept Login User Name Location Count of Ob
ABCD 1111 Rufus Good Detroit 4

Worksheet 3, Column H: 2 (4 Exceeds 2) (If the Count of Ob was 2, I don't
want it to select that record)

Worksheet 2: Dept Login User Name Location Count of Ob
ABCD 1111 Rufus Good Detroit 4

I've tried several of the Questions and Replies on this site, and I'm just
getting more and more confused and can't make anything work.

I would be so grateful for any help you can provide. Thank You,
--
jeannie v
 
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
How to move data to another worksheet depending on the criteria harwookf Excel Discussion (Misc queries) 7 November 19th 08 03:29 AM
How do I move data from one worksheet to another? Intrepid_firefighter Excel Discussion (Misc queries) 1 July 22nd 06 08:58 AM
How do I move certain Cell data from one worksheet to another? ryan r Excel Worksheet Functions 4 October 20th 05 10:59 PM
Move select data to another worksheet Annabelle Excel Discussion (Misc queries) 3 July 27th 05 06:01 PM
How to move data on worksheet Bonnie Excel Discussion (Misc queries) 3 February 23rd 05 05:49 PM


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