![]() |
#23
|
|||
|
|||
![]()
On sheet Parts is a table, where you register parts. This table is defined as Table tParts (select any cell in table and select Design from Menu - in Table Name field in Menu Ribbon you see the name of defined Table). Here you enter all parts you have, and quantities to keep for those parts. When afterwards you get new parts to account for, you add those into tParts. When the quantity to keep changes, you edit it (as this is a very simple application, you can't keep e.g. the history of quantities to keep here). When you don't need some part anymore, you can delete according row from table, or you can set QtyToKeep = 0.
Below Table Name field in Menu ribbon is a button <Resize Table>, which opens a "Resize Table" popup window. There is a field, where you can edit data range of Table. For tParts, in my example there the data range is "=$A$1:$B$4". When you edit it to "=$A$1:$B$14", and press <OK>, 10 new empty rows are added at bottom of Table tParts. You also can simply enter a new PartNumber into cell A5 - the Table TPards is expanded for one row. Or you can select cell B4 (the bottom right cell of tParts, and press Tab - an new empty row is added at bottom of tParts. The same applies for all other defined Tables (tInventories, tInventoty, and tPartOrder). Btw, I tried to remember yesterday, what more to correct, and didn't remember to correct Table name (tInvetoty > tInventory). Quote:
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
lesmielles | Excel Programming | 3 | 02-08-2017 06:14 AM |
Timeline creation - show events out of order | triallawyer | PowerPoint | 0 | 03-17-2015 08:48 PM |
Changing order of animations in slide show mode | mrbutler88 | PowerPoint | 1 | 02-14-2015 11:57 PM |
Show & hide paragraphs, parts of tables, etc | Preloader | Word | 2 | 10-19-2013 02:37 PM |
![]() |
pgwolfe | Word | 3 | 09-24-2013 07:58 PM |