I guess having to work every now & then isn't all that bad - kinda fun actually.
#Selecting non consecutive rows excel for mac code#
Fucking code is BOMBER and I haven't done shit like this in years. Outside of this minor output/display issue, I'm extremely proud of the work thus far. Much easier to dump into an excel sheet (which could theoretically then feed the DB) but simplicity is key as I'm sure that many people will be digging into over time making updates to the code and data validation formulas. It certainly would, however a lot of the data comes from a real time feed and it's touchy as hell importing the data from the feed direct to the db & just not worth the effort.
Wouldn't Access or even SQL be a better choice than a spreadsheet? Sounds like you're trying to make Excel behave like a database why not just migrate into a real DB? But I'm sure it'll be this type of thinking to come up with the solution.
Trying to account for the basic stupidity of human beings and make it as tight as possible. Problem is that the data is constantly changing, so the end luser would have to be hiding & unhiding (which would ultimately result in disaster). 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 kommentar(er)
