Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Mar 14 In MS Office Category.

  
Question Answered By: Isaac Williams   on Mar 14

For example, in worksheet 1 contains 4000 entries in one column,
there is only one column with data like this, for example:

A123
B234
C323
D567
etc...

In worksheet 2, there are about 40000 entries like the following:

A123 56.7 444 555
NMNC 76.9 345 123
D567 23.0 233 123
etc...

If a cell  in the column from the worksheet 1 matches a cell in the
first column of worksheet 2, then print that row  from the match from
worksheet2 to a new worksheet.

For example, A123(from worksheet 1) matches the cell in the first
column of worksheet 2, then print that row to worksheet 3.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Help with macro Or get search suggestion and latest updates.


Tagged: