Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wangxuqin
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
in an excel macro can you import data from word into a cell? Trefor Excel Discussion (Misc queries) 11 October 6th 05 01:49 PM
Using Excel 2000 as Data source for Word 2000 document Malcolm Agingwell Excel Discussion (Misc queries) 2 June 21st 05 09:28 AM
Insert excel data source into word doc using currency symbols Ginny Excel Worksheet Functions 1 May 31st 05 12:44 AM
Column format when merging Excel data to Word labels Red Excel Discussion (Misc queries) 1 April 6th 05 03:40 AM
Inserting Photos into Excel and linking to Word. Uploading Photos Excel Discussion (Misc queries) 0 March 17th 05 09:05 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"