So I have one sheet that we use for a Bill of Material list, Column A5-A? contains the part numbers of this job, there can be any number of parts then column B5-B? contains the amount quantity for each part, Now some of the values can be zero. I am looking for a way to transfer the information from sheet1 to sheet2 while leaving out any of the rows that have a zero quantity. And Im just drawing a blank, any help would be appreciated.
Thanks
Chris
I recommend you copy all the data to the new sheet. Sort column (A, B, both?) and delete any rows that have a zero (they should all be together and easy to find). If the original order is important, then create a helper column which you initially number 1 to ? before any sorting/deleting. Then do the sorting and deleting as above, then sort the helper column (and you can then erase the helper column).
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks