BILL OF MATERIALS¦ TITLE
BILL OF MATERIALS¦ TITLE
(OP)
Is there any way to erase or hide the bill of materials´ title?
Thanks for all...
Thanks for all...
When was the last time you drove down the highway without seeing a commercial truck hauling goods?
Download nowINTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: BILL OF MATERIALS¦ TITLE
1) Open the BOM template in excel.
2) Insert new columns (How many ?)
Note: Be sure your columns are on the inside left of $END column.
3) Highlight the 4 default columns RMB on the columns and chose "Hide"
4) Click in the cell that you plan to add your own custom columns.
5) If you look at the upper left corner (lower of the toolbars) there is a box that tells you the cell name
Ex: You pick cell "E1" this box says "E1"
6) After you pick the cell you want click and have found the above mentioned box. Then type a name in this box for a new name for this cell.
Note: The name can ***NOT*** have spaces in it. Although this is legal "No_Name".
7) You don't have to add text in these cells, just make sure the names are right.
8) Save the worksheet under a new name and that's it.
You have now added a new name to these cells, and if you have these same names in your part or assembly it will show up in the BOM.
If you or anyone that reads this, need an example let me know,
I hope this helps,
Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com
RE: BILL OF MATERIALS¦ TITLE
3) Highlight the 4 default columns or the columns that you need too & RMB on the and chose "Hide"
6) After you pick the cell you want....click on Insert\Name\Define. Then type in a new name and click add or use an existing name for this cell.
Note: The name can ***NOT*** have spaces in it. Although this is legal "No_Name".
Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com
RE: BILL OF MATERIALS¦ TITLE
________
Part No
105
________
105
RE: BILL OF MATERIALS¦ TITLE
That's alot easier than what I did before.
Try this instead:
1) Go to where you installed your copy of SW
EX: C:\Program Files\SW01\Lang\English\bomtemp.xls
2) Make a copy of this file "bomtemp.xls" and rename it to something that you will know.
3) Once you have renamed it, open it in Excel
4) Go to where Part No. is and delete it. Do this for all of them if you want.
***NOTE***: Just don't delete "$END"
5) I don't think you will be able to get rid of that space above the 105.
EX:
________
Part No
105
_________
_________
105
I hope that helps,
Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com