drowing data from one sheet to anotherClosed

Question

Hello,

Need your kind help with this cause i have no idea how to excute this.

What i need is to drow data from one table in sheet 2 to the main sheet ( sheet 1)

Let me explain ,

i created three sheets, the first is the main the second is (OCI) and the Thierd is ( Oshfir)

i want in the main sheet to be able to select from drop down list which sheet i would like the data to be drow from.

so if in the main sheet i selcet "OCI" from the drop down list, it will automaticly take data from OCI sheet and insert it in the appropiate tab.

appriciate your kind help as always.




Configuration: Windows 7 / Internet Explorer 8.0

TrowaD · Answer

Hi Dkatorza,

What information would you like to pull from you second and third sheet?

Maybe it's best if you upload you file using a filesharing site like www.speedyshare.com and post back the link. Be as clear as possible when you (re-)explain what you want.

Best regards,
Trowa

dkatorza · Answer

Hi Trowa,
thank you for responding,
below you can see the link for this excel worksheet.
hope now i'm clear.
many thanks.

https://authentification.site/files/29925584/seaquote.xlsx

dkatorza · Answer

HI Trowa,
did you see my answer?

TrowaD · Answer

Hi Dkatorza,

Yes I do see your answer, unfortunately I'm still using excel 2003, so I can't check out your file. So please resave your file as .xls and upload your resaved file. I will be able to look into it on 25 Aug.

Best regards,
Trowa

Drowing data from one sheet to another

4 responses

Similar discussions

Subscribe To Our Newsletter!