#1
|
|||
|
|||
Extract data from two worksheets into one
Hi there
I have a specific problem. I have two worksheets, each with vertically arranged data in three columns. For example sheet 1 = A b 5 / B b 3 / C a 6.5 and sheet 2 = D a 4 / E b 7 / F f 8. Into the third worksheet I wish to extract data from columns A and B of sheets 1 and 2 but only those that are accompanied by a value equal to or above 6. In other words, if there was such a function I would see in columns A and B in the third worksheet C a / E b and F f. Can I do this in Excel? Thanks for your help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comparing between 2 worksheets and retreiving data if a match | FUGMAN | Excel Programming | 8 | 02-18-2017 09:47 AM |
Cross reference data from 2 different worksheets | connell.richard@gmail.com | Excel | 0 | 12-06-2016 04:26 AM |
Copy data btw worksheets using public arrays | OldColdDreamer | Excel Programming | 4 | 02-10-2016 09:56 AM |
How to Extract key data from word | iliauk | Word | 3 | 11-08-2013 04:37 PM |
Finding sub-sets of data in worksheets | Rudi | Excel | 3 | 01-28-2013 06:13 AM |