Watty added a topic in General Chit ChatMS Excel HelpWas hoping someone here in the community could help me with an Excel issue/problem I'm having.
I have a sheet where one of the columns is "Sort Position". It's an integer and (for ease of explaining) is numbered from 1 to 100.
I need to "sort" the sheet based on the sort position column... in a rather odd way.
Sort position (record number):
In other words, I need to take the bottom 50% of the records and alternately insert them into the top 50% of the records.
Might anyone have an idea/suggestion? I've installed a freebie software addon for excel called ASAP Utilities (an INCREDIBLE addon I might add), but out of the hundreds of options it provides, I can't find anything that would help in this situation.
- 2 replies
- 589 views
Watty added a topic in General Chit ChatGoogle VoiceJust heard about a new service Google will soon be offering - Google Voice. It's actually pretty cool!
Anyone else heard of it and/or planning to use it? Apparently it is only by "invitation" right now, but they say within the next couple of weeks they will open it up.
- 38 replies
- 2,789 views
Watty added a topic in General Chit ChatMS Excel HelpI'm hoping there is a MS Excel GURU that hangs out here for a problem I'm having. :)
I do a LOT of mail merge (MS Word) functions and pull the data from Excel. The info is printed on a Master template and everything is fine - however, we recently started using an optional format for our clients and there's the problem.
Our master template needs the merged information to pull twice per template (left side/right side) - in a specific order ("sort position"). Let's say there are 200 records in Excel... I need the first 100 records to print on the left and the 2nd group of 100 to print on the right. These are "2-up" templates, so there will be 100 pages printed (front/back).
- 0 replies
- 380 views
Watty added a topic in General Chit ChatVariable Data Printing (VDP)Wow, been awhile since I stuck my face in here... :lol:
Was hoping someone here could offer some advice, etc. The company I work for uses Corel Draw X3... which has a Print Merge function that works GREAT - as long as I'm only printing fewer than 20 documents. Unfortunately, I work with much more than that (doc size is 11x17 4 color, both sides).
I'm trying to use VDP to address each doc/print using fields from an excel (CSV) file. Like I said, if I only have 20 or so addresses, no problem - but trying to do VDP with roughly 500 (sometimes much more) addresses causes Corel to die. The problem is (as I see it), is that it creates a separate document for each address when trying to send to our Konica-Minolta C5500 Biz Hub printer.
Has anyone here worked something similar to this and found a solution? :unsure:
- 0 replies
- 518 views