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