Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GSCaupling

    Lost Outlook Calendar and Contacts with New Profile

    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...
  2. GSCaupling

    Add Spaces to Alphabetized String

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

    Add Spaces to Alphabetized String

    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...
  4. GSCaupling

    AOL Attachments won't open

    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...
  5. GSCaupling

    Vanity Plates "XVI"

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

    Unique Month Numbers

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

    Unique Month Numbers

    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...
  8. GSCaupling

    Append Multiple Rows based on One Criterion

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

    Append Multiple Rows based on One Criterion

    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...
  10. GSCaupling

    Append Multiple Rows based on One Criterion

    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...
  11. GSCaupling

    Delete Rows Based on NOT Matching Two Criteria

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

    Delete Rows Based on NOT Matching Two Criteria

    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...
  13. GSCaupling

    Delete Rows Based on NOT Matching Two Criteria

    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...
  14. GSCaupling

    Delete Rows Based on NOT Matching Two Criteria

    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...
  15. GSCaupling

    Delete Rows Based on NOT Matching Two Criteria

    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...
  16. GSCaupling

    Text Intensive Report

    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...
  17. GSCaupling

    Link to Access Report Total to Excel Workbook?

    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.
  18. GSCaupling

    Link to Access Report Total to Excel Workbook?

    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...
  19. GSCaupling

    Quotation Punctuation

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

    Hurricun

    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.

Part and Inventory Search

Back
Top