Search:

Type: Posts; User: RandyD123; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    133

    Re: Min and Max Values on Separate Tab

    no info on those tabs anyway!!
  2. Replies
    6
    Views
    133

    Re: Min and Max Values on Separate Tab

    Unprotected File is HERE Sorry for anyone that tried to help. Thought I removed all the VBA!!!
  3. Replies
    6
    Views
    133

    Re: Min and Max Values on Separate Tab

    thought I removed all of that....I will edit it and remove password
  4. Replies
    6
    Views
    133

    Min and Max Values on Separate Tab

    I have a multi-tab spreadsheet that I want to extract the MIN and MAX values from the monthly tabs and transfer them to my "FL" tab. The code I use now does not allow for me to just drag the top...
  5. Thread: Indirect??

    by RandyD123
    Replies
    7
    Views
    117

    Re: Indirect??

    PERFECT, Thank You Very Much!!!
  6. Thread: Indirect??

    by RandyD123
    Replies
    7
    Views
    117

    Re: Indirect??

    Thank You Very Much. Just one last question, If the sheets don't exist I get a #REF ! error. How can I avoid this error or have the cell show a blank value. I don't mind the "0" value for sheets that...
  7. Thread: Indirect??

    by RandyD123
    Replies
    7
    Views
    117

    Re: Indirect??

    actual sheet is here
  8. Thread: Indirect??

    by RandyD123
    Replies
    7
    Views
    117

    Indirect??

    I have multiple sheets that I want to create a master tab. It needs to pull one cell value (J55) from each sheet. Not sure the easiest way to go about it. See example: column B,D,F,H....have to pull...
  9. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    In this version of the file: https://1drv.ms/x/s!Ai35lp1419xzo4UDEX6nexi5KPJGYg you can see my workaround for renaming the airlines. Also notice the the "desired output" tab. When the script is run...
  10. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    The sort order should be by Airline then by time. So AA would come first with all the flights listed by time, earliest first. See below. Also in the file that I uploaded there is an example of the...
  11. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    So i have found a workaround for the naming of the airlines properly, not the best workaround but it works. But post #6 are the 2 concerns if solvable that would be awesome. Thanks for all the help...
  12. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    I think you may have misread that...."RESULTS" of the conversion, not "rest" of the conversion!!! SEE POST #9
  13. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    sorry for the "bad link"...the end result is here: https://1drv.ms/x/s!Ai35lp1419xzo4R_XBTnjE9wa51Ofg
  14. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    I do not have a lookup table. I see how the conversion is working on the airlines..... Southwest Airlines (SA) Delta Airlines (DA) and United (U)......I'm just trying to figure out how to make them...
  15. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    Wow!! It's very close. Just a couple of minor things...The conversion for for the airlines should be converted as the two letter code as follows Southwest (SW) and United (UA) and Delta (DL)....
  16. Replies
    15
    Views
    391

    Re: Converting data from one tab to another

    yes, and it looks good for the end result!
  17. Replies
    15
    Views
    391

    Converting data from one tab to another

    I know this is a big "ask", but I need some help. What I need to happen is all the data on the "raw data" sheet needs to be converted to the format on the "converted data" tab.


    I can of course...
  18. Replies
    7
    Views
    217

    Re: find duplicates

    yes the UID column will be hidden. so i do need the entire row to be highlighted.
  19. Replies
    7
    Views
    217

    Re: find duplicates

    I've done that, that is my UID column. Not sure how to write the conditional format code to just highlight the duplicate row only
  20. Replies
    7
    Views
    217

    Re: find duplicates

    That won't work, as you can see the same name can appear more than once. It's when the NAME & DATE both match I need to highlight the duplicate row ONLY
  21. Replies
    7
    Views
    217

    find duplicates

    I have a sheet that can be seen here. I'm not sure how I got the UID column to fill in automatically when I type something in the Name and Date column but it doesn't seem to work for the COUNT...
  22. Replies
    0
    Views
    164

    Counting Formula

    I have a spreadsheet located on Google Drive.

    I need a formula in column "GT" that will count the number of days in each row that have either an "X" or "RDO". When that number hits 14 or more...
  23. Replies
    3
    Views
    1,831

    Re: Conditional Format for Multiple Sheets

    Does the "compile sheet" have to be the name of each sheet or can I use workbook instead?
  24. Re: Deny Cut/Paste but Allow Copy/Paste on Workbook

    Thank You, Works Perfectly!
  25. Replies
    3
    Views
    1,831

    Conditional Format for Multiple Sheets

    I have 12 sheets that I want to apply conditional formatting across them all. I only need to make sure that any cell that has data will be an Arial 14 point Bold font across all sheets. I would like...
Results 1 to 25 of 135
Page 1 of 6 1 2 3 4