Re: $$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to the Right

2014-05-22 Thread JohnA
Paul, Absolutely PERFECT! Thank you so very much. I will analyze every line of code to learn, but it worked just as I needed. Thank you again. John On Wednesday, May 21, 2014 2:10:55 PM UTC-4, Paul Schreiner wrote: > This macro seems to work with the sample data: > > Option Explicit

Re: $$Excel-Macros$$ Formula for Lookup Based on 3-Factors Rather than Helper Columns

2013-10-30 Thread JohnA
Anoop, It really does help me, thank you. I don't understand it, but will be looking at the structure to learn how it works. Again, thank you for your quick reply and your much appreciated help. John On Wednesday, October 30, 2013 1:29:07 AM UTC-4, Enrique Martin wrote: > > Hi John, > > Pleas

Re: $$Excel-Macros$$ Formula Needed for Subtracting 2 Different Date/Time formats....

2013-08-26 Thread JohnA
Santy, Absolutely phenomenal! Thank you for your brilliant, quick reply! John On Monday, August 26, 2013 8:56:14 AM UTC-4, Santy wrote: > > Little lengthy formula but working fine > > > *Thanks & Regards,* > *Santy* > > > On Mon, Aug 26, 2013 at 5:56 PM, John A. Smith > > > wrote: > >> I

$$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread JohnA
clear view of my challange. Again thank you for your help. John On Tuesday, February 5, 2013 10:05:08 AM UTC-5, JohnA wrote: > I have a spreadsheet with 180 columns and 8,000 rows. I would like to > highlight a row if a specific value is anywhere in the spreadsheet. (for > examp

$$Excel-Macros$$ Formula for Military Time Calculations

2010-09-02 Thread JohnA
I need to determine time increments from postings in Excel in the 24 hour mode (commonly called military time). I can't come up with a formula to give me decimal hours from military time subtractions. Help please!