Search results for query: *

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.

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

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

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.

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

I'm trying to use a Data Form to quickly find and 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...

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

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

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. ??

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

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

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.

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

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

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

PVH, thank you for your reply.

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

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"...

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?

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