Dave,
Yeahhh... I thought that too... but then I thought... well it's an interesting problem :-)
LIsa
Sent: Sun, Jan 13, 2013 10:54 pm
Subject: Re: [ExcelVBA] Re: Puzzling Behavior
Look at the idea of inserting everything in the one place (unsorted) and
then using one sort at the end to sort by style and size. (In fact, I'd
wonder if you want to sort firstly by size, so that everything for a
particular person's foot size is together.)
> As I add each size for a particular style, I store
> the size in a separate sheet. When I finish with a style,
> I sort the sizes, and then concatenate them into a string,
> which I enter as part of the description of that style.
I don't know if I'm understanding this properly, but it sounds as though you
will have 2,000 sheets (one per style). This could also be a problem.
I wonder if you need to sort the sizes at all ... aren't you adding them in
a particular order anyway?
Regards, Dave S
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar