Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
pinar
 
Posts: n/a
Default getting data from 2 excel sheets automatically


Hello

I have a problem that is a bit complicated for me.
Is there anybody who has idea?

I have 2 excel sheets.

In the first sheet , there is a lot of data like

Column A Column B Column C Column D… Column E
Model Name … …… .... Price 1
1000 ABC 50
1003 DCB 30
1004 DDD 20
1005 EED 10

And in the second one, there is also a lot of data with price 2.

Column A Column B Column C Column D Column E Column F
Model Name …... ……. ...... Price 2
1000 ABC 20
1003 DCB 30
1004 DDD 10
1005 EED 40

What I need is to form automatically another excel sheet for specific
models, for example,
I need model 1000 and 1004. and their price info. Price 1 info has to
come from sheet 1 and Price 2 info has to come from sheet 2 and form
the sheet below. I don’t need column c and d. but the thing is that it
has to take the right data from the excel sheets automatically and put
them to this new sheet.

Column A Column B Column E Column F
Model Name Price 1 Price 2
1000 ABC 50 20
1004 DDD 40 10

Is there any way to do it without any macro?
Thnks a lot


--
pinar
------------------------------------------------------------------------
pinar's Profile: http://www.excelforum.com/member.php...o&userid=16067
View this thread: http://www.excelforum.com/showthread...hreadid=276544

Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how to automatically configure excel data in all worksheets of a . Er Singh SD Excel Discussion (Misc queries) 1 January 8th 05 09:26 PM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 12:46 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 04:53 PM
How do I plot data in Excel that is captured on separate sheets; . krwegner Excel Discussion (Misc queries) 0 November 30th 04 06:43 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"