![]() Select the rows you dont want to show, then its Alt + D, G, G. ![]() Not exactly freezing, but you could try grouping the rows in the middle that you dont want to see and then hiding them. Trying like hell to keep all this shit in one workbook as it is confusing enough as is without dealing w/ multiple books. Workaround would be to either have two tabs per customer (1 for buys, 1 for sells) or to do two totally separate workbooks - again one to track sell & the other for buys. The idea is that someone can then click on the customer tab and see a split screen and easily scroll thru the buys/sells. Anything bought or sold is tracked on one sheet - regardless of the customer - then a shitload of VBA code comes in and copies rows of all sells to a specific tab (based on values in customer column) starting at row 2, and then all buys for that customer the same sheet row 1001. Definitely trying to avoid opening a file multiple times as that will invariably get all kinds of fucked up at some point.īest example without going into gruesome detail would be that it's a tracking sheet for sales. ![]() As you indicated row 100 isn't too far away, but that was actually just an example - the other header row is #1000. ![]() I see where you're going, but I don't think that's going to do it (if I'm understanding you correctly). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |