Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
multiple sheets when importing into excel | Excel Worksheet Functions | |||
how can i open multiple excel sheets separately | Excel Discussion (Misc queries) | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) | |||
How do I access the Document recovery task pane in Excel | Excel Discussion (Misc queries) |