Search results for query: *

My primary email account stopped working two months ago on Outlook 365, and after many vain attempts to fix it I rather hastily deleted and recreated the account. This fixed my email problem perfectly. However, I did not realize all my contacts and calendar entries would disappear. Is there...

Awesomesauce! That works - thank you! ******^******* I Hate [♥] Ambiguity.

I found code for a function that will alphabetize the characters in a string. If A2 is "TACO" then Sortletters(A2) returns "ACOT." What I'd like the result to look like is "A C O T" with a space in between the characters. A leading space before the first character is okay - I'm just looking...

Windows 7 home premium I access a free AOL email account via Chrome. Until recently when I received an email attachment I would click on the attachment and it would download and show as a button at the bottom of the page. I would click on the button and the file, usually a .pdf, would open...

Saw this Ohio plate today in North Carolina: SQL MVP. I wonder if they're a member here. [smile] ******^******* I Hate [♥] Ambiguity.

This works for me, Skip: =(YEAR(somedate)-1900) *12 + MONTH(somedate) Thanks! ******^******* I Hate [♥] Ambiguity.

Is there a function or addin for Excel (2013) that returns a unique number for each month, similar to how days are counted from 1/1/1900? I don't mean the Month function that returns "6" for June no mater what year it is. I need every month to have a unique, consecutive number. For example...

Thanks MajP! I'll study this tomorrow when I'm fresher, but I suspected I would need a Recruits Table. ******^******* I Hate [♥] Ambiguity.

You're right, Duane. Let me try again. Example: The Tropical Fish Store rewards salespeople when they recruit other salespeople like this: You get 10% of the sales of your direct recruits and 5% of the sales of THEIR recruits. Rewards are only two generations deep, after which the initial...

Using Office 365. This is basically a commission scenario. I have a Sales Table with: SaleIDAgentIDProductPrice and a Commission Splits Table: SplitIDSaleIDAgentIDSplit% I can populate the Sales table without problem The issue is populating the Splits Table. Depending on WHO made the...

PWD - thank you! ******^******* I Hate [♥] Ambiguity.

Skip, what I am trying to do is create a proper table from the imported data. Picture a financial statement with page and column headers on every page, plus subtotal sections every few pages. Now picture all of that imported into Excel. I'm trying to delete every row that does NOT contain a...

That never crossed my mind, Skip. Thanks for the idea. Now here is the rest of the story, so you can throw rocks at me for leaving out important stuff. [bigsmile] My goal is to get the Excel data into a compact table (no blank rows) so I can import it into Access. When I do it manually it...

Thanks PHV. While I needed that, what I need also is how to put this into a macro. I Googled this issue before posting and found answers all over the place, with loops and without, etc., but none that addressed two criteria in the same column. Any ideas on what the macro would look like...

Using Win 7 & Excel 2013 I'm totally new to VBA code, but I need some kind of code/macro/magic that will delete rows in Excel. Each month I import a financial statement with about 500 rows and I need to delete all but 350 of those rows. The rows I want to keep have an account number in Column...

I need to create reports that are heavy on text and light on data fields. Essentially these are contracts or agreements with several paragraphs and then a few name, address and dollar amount fields. Is it better to store the text in the report itself or import memo fields that contain the...

Thanks Skip. I've never tried that before (I've never had the need) so it looks like I'll be learning something new this weekend. GS ******^******* I Hate [♥] Ambiguity.

MS Office 2007 Professional. I have a set of linked Excel workbooks: Payroll, Commissions and Payables. The Payables workbook is linked to the other two and updates automatically. The client looks at this frequently to see how much cash he can take out of the business. I am building an...

I would tell you what my teacher said about punctuation and quotation marks, but... I no longer know how. [bigsmile] GS ******^******* I Hate [♥] Ambiguity.

I'm surprised no one challenged this one, if I may respectfully disagree. Thought rhymes with taut or sought or caught. :-) GS ******^******* I Hate [♥] Ambiguity.