Drowing data from one sheet to another [Closed]

Report
Posts
4
Registration date
Wednesday August 17, 2011
Status
Member
Last seen
August 20, 2011
-
Posts
2755
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 3, 2021
-
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.




4 replies

Posts
2755
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 3, 2021
462
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
Posts
4
Registration date
Wednesday August 17, 2011
Status
Member
Last seen
August 20, 2011

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
Posts
4
Registration date
Wednesday August 17, 2011
Status
Member
Last seen
August 20, 2011

HI Trowa,
did you see my answer?
Posts
2755
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 3, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!