Geoff, Peter,
Thanks very much for the help. It works perfectly, and it sure is a lot easier than doing subtotals and then having to clean up afterward!
Alan
Geoff,
Thanks very much. Yes, I can do it with Subtotals, but it's kinda klutzy, and I would love to see how it's done in code.
Please understand, I am a real newbie to VBA. When you suggested doing it "via code", I took that to mean that I could create a macro called something...
I have an Excel 2000 spreadsheet that contains order details. The number of rows varies for different orders - some will have only one row, others may have several.
Is there a way to look at the Order Number column and, each time the value changes, to insert a blank row between the orders...
Greetings once more SBendBuckeye,
Thanks again for all of your help.
Just in case I didn't explain my original question clearly, here's what I was expecting. I had in mind a form with many fields for entry, upon completion of which the user would click an "OK" button. That button...
It appears we have the old Purdue/Notre Dame rivalry going on here! Thanks to both of you Hoosiers (or one Hoosier and one transplanted Buckeye) for your help. This Buckeye appreciates it.
While I'm not very experienced at reading code, it appears that both of you came up with pretty much the...
The term "TechnicalUser" can be misleading but, since "Dummy" isn't one of the choices on the menu...
I'm a newbie.
I have a data entry form that has a command button which adds the record to the underlying table. Normally, one of the fields in the record should have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.