How to Select large amount of data in a colum that equals column from another table.

J

Jennifer Burnel

Ive got a huge table and I want to select the data in one column that is
equal to that of a column in another table?

is there an easy way to do this?

Thanks
 
R

RagDyer

One way, if you know the parameters of the original, is to type the
references in the name box and hit <Enter>.

For example, click in the name box and enter:
E1:E65000
Then <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Ive got a huge table and I want to select the data in one column that is
equal to that of a column in another table?

is there an easy way to do this?

Thanks
 
J

Jennifer Burnel

The column consists of 6000 items where I need to select around 2000 so I
need a swift solution.
Thanks
 
R

RagDyer

Which 2,000?
How are the cells identified?

Could you be more precise?

Does this help:
If you can click in the first cell, say E21,
then click in the name box and enter E2012,
Then hold down <Shift>,
and hit <Enter>.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

The column consists of 6000 items where I need to select around 2000 so I
need a swift solution.
Thanks
 
J

Jennifer Burnel

I dont think Ive explained this very well.

I will explain exactly what Im trying to do:

as an example I have a table with over 5000+ lines of data and one of the
columns has each products unique image name.

Out of the product data table I will only require around 1000+ lines but
these will be individually selected from the image name I require.

using the thumbnail image view in windows XP explorer, I will then use
folderview to copy the names of the chosen images
to a table. These image names will then represent the data I require.

What I dont want to have to do is go through the table selecting each line
required matching my image list then
cutting and pasting into a new table, because Ive got a large number of
tables to edit this way 70,000 + lines of data.
 
R

RagDyeR

Sorry, but I'm lost!
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I dont think Ive explained this very well.

I will explain exactly what Im trying to do:

as an example I have a table with over 5000+ lines of data and one of the
columns has each products unique image name.

Out of the product data table I will only require around 1000+ lines but
these will be individually selected from the image name I require.

using the thumbnail image view in windows XP explorer, I will then use
folderview to copy the names of the chosen images
to a table. These image names will then represent the data I require.

What I dont want to have to do is go through the table selecting each line
required matching my image list then
cutting and pasting into a new table, because Ive got a large number of
tables to edit this way 70,000 + lines of data.
 
D

Debra Dalgleish

Assuming your large table is in the range A1:E20000, with image names in
column A, and your list of images is in range J1:J1000

In cell, F2, enter the following formula:
=COUNTIF($J$1:$J$2000,A2)

Copy the formula down to the last row of data

Select a cell in the large table, and choose Data>Filter>AutoFilter
From the dropdown list in cell F1, select 1
Select and copy the filtered table, and paste on a different worksheet
 
Top