LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin
 
Posts: n/a
Default Multiple Task needed in Excel

How to do the following Tasks in Excel?
On Worksheet 1 cell A1 I have to Key in the lot number. At cell B1 I want to
auto import the dimension from Text file (in fixed pattern) created from
Measuring equipment based on the lot number in cell A1.
Lets say after keying the 10th lot number in cell A10 and there will be
automatic import of 10 dimension from B1 to B10, I want to find the average
of the dimension from B1 to B10 at cell B11. The cell B11 data will be
updated at another workbook for shipment. How to perform all this in a single
workbook?


 
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
How do I get cell data in multiple Excel files into one summary fi 78degreesinHI Excel Worksheet Functions 4 August 29th 06 02:05 AM
multiple sheets when importing into excel Nora Excel Worksheet Functions 1 January 30th 06 09:38 PM
how can i open multiple excel sheets separately srinu Excel Discussion (Misc queries) 1 July 8th 05 04:38 PM
Exporting from Excel to multiple XML files Questions Excel Discussion (Misc queries) 0 March 17th 05 10:20 PM
How do I access the Document recovery task pane in Excel AndyG Excel Discussion (Misc queries) 1 February 16th 05 03:21 AM


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Excel"