Sorting and deleting

hello,
do you want to delete complete row which has "P" or "R" in Item, description,material,stock ?

Tom, I`m so sorry I`m a not really familiar with VBA, can you tell me where to add and how to call this sub in my spread sheet?

Awesome! Thank you so much!!!

Do you guys know if it is possible to sort automatically 1,2,3 etc after running "aa" sub?

Originally Posted by shaukat

hello,
do you want to delete complete row which has "P" or "R" in Item, description,material,stock ?

Yes, delete complete row. Script above from Tom was what I needed. Thank you. Looking for how I can sort parts now.... do you know?

Originally Posted by tom1977

I am not sure I understand but if you want have numbers in column A like 1,2,3 etc try this:

Please Login or Register  to view this content.

Tom please see attached file. After you run the macro ( I modified it a little bit) if you look at Item column you`ll see it starts from #3. I`m wondering how to assign Item #`s so #3 becomes #1 and so on...?

Originally Posted by tom1977

I am not sure I understand but if you want have numbers in column A like 1,2,3 etc try this:

Please Login or Register  to view this content.

sorry wrong excel spreadsheet . the one attached is correct....

Genius!!! Thanks! Tom, at the risk of being a huge pain, do you mind if I`ll ask few more questions?

1. How to format cells and add borders automatically ? see test3
2. Is there any way to adjust break view so when I print it prints the entire sheet? see test3

BOM can be 10 rows long or 200 rows long.
Please see
test2.xls - after running macros and VB script
test3.xls - that what I need to be done in addition.

Thanks in advance!

figured out how to do break_page

Please Login or Register  to view this content.