data entry in excel by linking to other word doc. or excel sheets
 

this sounds like using excel as a data recording tool question.

i have a client asking me this:

1. when he creates a new order either in word doc. (which he prefers)
or in excel (he can accept using this too), how can I help him enter
the order in excel data sheet--he wants to include order number, order
items (multiple usually), quantity etc.

2. when multiple orders are created in different files (e.g. one order
is one unique .doc file), how can I help him update the data entry in
the excel spreadsheet by accessing newly created orders?

3. if one order has two or more order items, I hope i can enter the
data sheet with two or more rows (meaning that the data is stored at
order item level not just order level), how can i automatically create
multiple rows for one order?

Sorry these questions sound very rudimentary...I try not to use ACCESS.
and i do know how to use excel as a reporting tool once the data are
entered.

thanks so much!

Jasmine


--
wangxuqin
------------------------------------------------------------------------
wangxuqin's Profile: http://www.excelforum.com/member.php...o&userid=33485
View this thread: http://www.excelforum.com/showthread...hreadid=532862

data entry in excel by linking to other word doc. or excel sheets
 

Do yourself a favor and avoid separate word docs LIKE THE PLAGUE.

You may not like Access, but using that is FAR preferable to the options
you've described.

This link has at least two versions of Access templates for customer orders

http://office.microsoft.com/en-us/te...366681033.aspx

"wangxuqin" wrote:


this sounds like using excel as a data recording tool question.

i have a client asking me this:

1. when he creates a new order either in word doc. (which he prefers)
or in excel (he can accept using this too), how can I help him enter
the order in excel data sheet--he wants to include order number, order
items (multiple usually), quantity etc.

2. when multiple orders are created in different files (e.g. one order
is one unique .doc file), how can I help him update the data entry in
the excel spreadsheet by accessing newly created orders?

3. if one order has two or more order items, I hope i can enter the
data sheet with two or more rows (meaning that the data is stored at
order item level not just order level), how can i automatically create
multiple rows for one order?

Sorry these questions sound very rudimentary...I try not to use ACCESS.
and i do know how to use excel as a reporting tool once the data are
entered.

thanks so much!

Jasmine


--
wangxuqin
------------------------------------------------------------------------
wangxuqin's Profile: http://www.excelforum.com/member.php...o&userid=33485
View this thread: http://www.excelforum.com/showthread...hreadid=532862