×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

BILL OF MATERIALS¦ TITLE

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...

RE: BILL OF MATERIALS¦ TITLE

Try this:

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

I found these two rules to not read very well. So I tried updating them.

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

(OP)
What I want is to hide just the title like this:
________
Part No    
105          

________
105          

RE: BILL OF MATERIALS¦ TITLE

Oh Ok!

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources