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!

Register Log in
  • Congratulations Rhinorhino 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. dcompto

    How to write this formula in VBA

    Thanks, Skip. I got it done. While my macro code is neither pretty nor efficient, it gets the job done and will save me hours every semester.
  2. dcompto

    How to write this formula in VBA

    I have hit a wall in writing a portion of an Excel 2016 macro... Haven't figured out how to write VBA for: In ws Extracted1, For every row, compare cell F to cell P, If F = P, copy F to ws Sorted corresponding row of cell B If F <> P, copy P to ws Sorted corresponding row of cell B I have a...
  3. dcompto

    Clearing Data Form Criteria - Excel 2016

    Thanks for your responses, Skip. It's not necessary for you to continue to look. I can close the Form after each search. We have 888 undergraduate students and within the next couple of weeks they will all be filtered through my desk for their advising appointments after filling out their...
  4. dcompto

    Clearing Data Form Criteria - Excel 2016

    No, I pressed Enter. However, after your last response, I went back and clicked the Form button after entering the criteria and got the same failed results.
  5. dcompto

    Clearing Data Form Criteria - Excel 2016

    The application is Excel 2016. Sorry, I should have repeated that info in the Body of the post instead of only in the Subject.
  6. dcompto

    Clearing Data Form Criteria - Excel 2016

    ...view all fields of a record matching the Name field criteria then repeat the process for multiple records. I enter the name (or partial name with *) in the Name field and it displays the record. I then click the Criteria button followed by the Clear button and enter another Name and it...
  7. dcompto

    Excel 2016 PivotTable Start_Time field shows as Duration - Why?

    combo, I can't thank you enough, and I am so very thankful for this forum!!!
  8. dcompto

    Excel 2016 PivotTable Start_Time field shows as Duration - Why?

    I've been doing this type of PivotTable for several years without problem but recently upgraded to Office 2016 and Windows 10 and I can't figure out why my Excel 2016 Data (defined as a Table) changes the Start_Time field (formatted as Time > 1:30 PM in the Table) is shown as if if were Duration...
  9. dcompto

    Excel 2010: Exlanation of formula for Thanksgiving date of current year

    bluedragon2, thank you for the detailed explanation. It was very helpful. zelgar, thank you, too, for your response. Your formula works fine, but I don't understand how you determined to use the numbers 29 and 31. ??
  10. dcompto

    Excel 2010: Exlanation of formula for Thanksgiving date of current year

    Yes, I'm sure I'm technically wrong in my phrasing; however, D5 is the cell reference in the formula: =DATE(D5,11,CHOOSE(WEEKDAY(DATE(D5,11,1)),26,25,24,23,22,28,27)) and D5's formula is =TEXT(C5, "yyyy"). Maybe, that's irrelevant; I don't know. I'm just hoping someone can explain the ...
  11. dcompto

    Excel 2010: Exlanation of formula for Thanksgiving date of current year

    I found a formula for determining the date of Thanksgiving for the current year from http://chandoo.org/wp/2009/11/25/findout-thanksgiving-date/, and it works great. However, I do not understand the explanation of the ",26,25,24,23,22,28,27". Can someone explain it to me so I can understand...
  12. dcompto

    Word 2010 Tell which label (Product Number) used in existing doc?

    It is as Skip last mentioned. To test, I created 2 files of different labels then ran the macro on each file. It returned the name of the label number last used and not the name of the label number used in the current document.
  13. dcompto

    Word 2010 Tell which label (Product Number) used in existing doc?

    Andy, How did you determine LabelID:="1359804673" for Avery US Letter, 5162 Easy Peel?
  14. dcompto

    Word 2010 Tell which label (Product Number) used in existing doc?

    Do you know of a way to tell which labels product number was used for an existing Word 2010 doc? I have a label document that was created by someone else and I'm wondering if there is an easy way to determine the product number (instead of applying borders to the labels, measuring the label...
  15. dcompto

    Outlook 2010 conditional formatting - whole words?

    Using Outlook 2010, and trying to set up conditional formatting for words in Subject line: "bus", "shuttle", and "BOB reservations", but emails containing the word "business", etc. are also being affected. Have even tried putting a space after each one of my conditional words and phrases without...
  16. dcompto

    Create field for Video Length

    PVH, thank you for your reply.
  17. dcompto

    Create field for Video Length

    Win 7, Access 2010: I searched this thread and googled a lot yesterday, but have not found an answer. I'm creating a database for 100+ YouTube videos created by one of my bosses and I need to include a field for video length. Would like to be able to perform calculations on the field and for...
  18. dcompto

    Acrobat X javascript for Protection &gt; Remove hidden information... &gt; MetaData

    Using Acrobat X, I have created an Action that does: Step (1) Execute Javascript 'to apply a copyright watermark /* Watermark - COPYRIGHT */ this.addWatermarkFromText({cText: "COPYRIGHT \xa9 " + util.printd("yyyy", new Date), nTextAlign:app.constants.align.center, cFont: "Arial Black"...
  19. dcompto

    Flatten Transparency via Action with javascript

    I created an Action that executes javascript that inserts a Copyright [yyyy] watermark at a 45-degree angle on all pages of my PDF, and I would like to add more javascript to perform: Tools > Print Production > Preflight > Flatten transparency (high resolution) How can this be done?
  20. dcompto

    PivotTable style with Banded Rows not working (!?)

    I think I just found the answer. I'll get back to you.

Part and Inventory Search

Back
Top