New to excel - how to query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RachelD - 05 Feb 2008 16:50 GMT

Hello, I am new to excel currently working with Moss sharepoint

I have a "ticket" that needs to pull data from another excel workbook when
they need to update a budget and they send it in for approval using moss.
Is that possible? I am new to this and looking for ways to make this easy
for my users when they use the "ticket" template requesting a new budget
change and the data they are getting is from a set budget form for a
project. Can someone lead me to the right direction on how to handle this.
Thank you for your time.

Reply to this Message

RachelD - 05 Feb 2008 19:31 GMT

I don't have the terminology to be able to explain what I need. I hope
someone can guide me to the right direction. Thanks.

> Hello, I am new to excel currently working with Moss sharepoint
>
[quoted text clipped - 5 lines]
> project. Can someone lead me to the right direction on how to handle
> this. Thank you for your time.

Reply to this Message

CLR - 05 Feb 2008 20:18 GMT

I'm not sure exactly what you want, but you might try doing Data >
GetExternalData > CreateNewQuery .....and follow menus........as that is one
way to retrieve data from another workbook. After you try that, come back
and tell us how what you want differs....

Vaya con Dios,
Chuck, CABGx3

> I don't have the terminology to be able to explain what I need. I hope
> someone can guide me to the right direction. Thanks.
[quoted text clipped - 8 lines]
> > project. Can someone lead me to the right direction on how to handle
> > this. Thank you for your time.

Reply to this Message