alphabetizing

Sorting a pivot table A-Z keeps giving me Bad Debt Bank Charges Depreciation Dues & Fees Tax-Real Estate Advertising Employee Benefits Insurance Everything after Insurance is sorting properly. If I copy and paste the values outside of the pivot table and sort A-Z it sorts correctly. Any idea...

Hey everyone, At my work I'm trying to use Excel VBA to take scanned PDF documents of patient information from the path they're scanned into and have a macro that will automatically go through the PDF files, look at the name of the files and be able to go to another path (patient accounts...

TL;DR version: Can I use some kind of formula to convert a letter into a number, without using 28+ IF nestlings? Not too long; did read version: I have a bit of a problem. Namely, I have a quite large spreadsheet that has a total of 1 array formula in it. But, that array seems to be...

This is my first vba project ever, so please excuse my novice approach. I work at a summer camp and am creating a user form that allows you to input a camper's name and medications, and upon submission of the form it puts the information into a printer friendly page that has am/lunch/pm initial...