# How to extract the same data from different sheets

program_info@yahoo.com
Guest
Posts: n/a

 1st Dec 2005
Hi,
I need to extract the common and same data from four different sheets
into one sheet. Could you please let me know how to do it?

I can use VLOOKUP, but I need to generate one temperary sheet for any
two sheets. And based on these temperary sheets, I need to use VLOOKUP
to generate other temperary sheets. And then finally I could get the
last result. Too complex.

THanks.
--Kening

Jerry W. Lewis
Guest
Posts: n/a

 1st Dec 2005
Can you say more about the structure of your data, how you are
identifying "common and same data" and why you need all those temporary
sheets to use VLOOKUP?

Jerry

(E-Mail Removed) wrote:

> Hi,
> I need to extract the common and same data from four different sheets
> into one sheet. Could you please let me know how to do it?
>
> I can use VLOOKUP, but I need to generate one temperary sheet for any
> two sheets. And based on these temperary sheets, I need to use VLOOKUP
> to generate other temperary sheets. And then finally I could get the
> last result. Too complex.
>
>
> THanks.
> --Kening

Piotr
Guest
Posts: n/a

 1st Dec 2005
Its good to use macro from http://www.rondebruin.nl/copy3tip.htm it
works for me fine

regards
Peter

program_info@yahoo.com
Guest
Posts: n/a

 3rd Dec 2005
Thank you. Jerry and Peter.
I use IF and MATCH functions to do it. It is not very complex.

I appreciate that you answered my email.

--Kening

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post VeDe Microsoft Excel Misc 2 27th Jan 2010 06:52 PM Pravin Microsoft Excel Programming 4 9th Jan 2008 05:05 PM ExcelTricks@gmail.com Microsoft Excel Discussion 2 8th Aug 2006 12:56 AM kevatt Microsoft Excel Programming 0 10th Jan 2006 11:47 PM =?Utf-8?B?a2FpbGFzaA==?= Microsoft Excel Misc 2 23rd Nov 2004 05:27 PM

Features