Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Referencing a code in a column to fill in names in sheet cells

    I have a sheet "Hours" that in column D has names and column E has a job code ex 829

    Then I have a sheet named "shuttle miles" where I want to enter drivers name based on the code in cells. The...
  2. Re: Convert the order the first and last name is written via formula

    You guys are awesome, multiple suggestions worked...ty.

    for my none issue above i will just put an if statement that will be an easy fix.
  3. Re: Convert the order the first and last name is written via formula

    This one worked all the way up to where I found a few records saying: Driver Name: None
  4. Re: Convert the order the first and last name is written via formula

    driving and looking at the forum I see many of you enjoy the challenge...ty for the help i will test out shortly
  5. Convert the order the first and last name is written via formula

    Hi assuming I have

    "Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald"

    ...not sure if that is possible so the other option is in B1...
  6. Re: Formula to figure out count based on category week i'm in and for previous week and current week to date

    Maybe I can explain this better basically i'm looking for effectively is a vlookup for a code WH as an example but I want to be able to tell how many times the code came up last week. In another...
  7. Formula to figure out count based on category week i'm in and for previous week and current week to date

    Hi I have a

    column A that has week ie 2019.26 represent 26 week of the calendar day.

    Column B Date

    Column D Reason Code WH BD HOS...

    Assuming my week is Mon to Sat (no data on Sunday)
  8. Re: Copy sheet with popup message asking to name the new copied sheet

    Cancel means I changed my mind and I don't want to proceed.
  9. Re: Copy sheet with popup message asking to name the new copied sheet

    Pretty standard process when using any PC, cancel...script ends you don't get warnings. You try to save something w/o a name it doesn't give you script errors and sends windows into debug mode just...
  10. Re: Copy sheet with popup message asking to name the new copied sheet

    Little hard to comment as I am not knowledgeable enough to write the code but the problem is that if you press cancel you wouldn't typically expect to get an error similarly if you press ok without...
  11. Re: Copy sheet with popup message asking to name the new copied sheet

    This creates issues...as after okay on blank or cancel it tries to delete activesheet. Also still gives a popup when you press cancel or okay on blank with this MsgBox ans & " Is not a proper sheet...
  12. Re: Copy sheet with popup message asking to name the new copied sheet

    I appreciate your help and quick responses it is not my intent to frustrate you not sure what exactly what you are looking for since I cannot foresee what the code will do and look like until i can...
  13. Re: Copy sheet with popup message asking to name the new copied sheet

    Specifically what I want is to copy a master sheet that includes...

    1. a pop up asking for a new name
    2. if duplicate provide a pop up stating so and a new pop up shows up to enter a name again.
  14. Re: Copy sheet with popup message asking to name the new copied sheet

    Thanks, you don't really think of all the nuances until there is code and you see all the different issues that pop up. I will rewrite.
  15. Re: Copy sheet with popup message asking to name the new copied sheet

    TY. Not a deal breaker but when i select the same name it doesn't give me the popup again just stops and I have to click the button again. Is there a way to make it so the popup comes back to enter...
  16. Re: Copy sheet with popup message asking to name the new copied sheet

    That almost works but when using existing name I get the error but a new sheets still gets created ie Master (1)
  17. Re: Copy sheet with popup message asking to name the new copied sheet

    Yes please.
  18. Copy sheet with popup message asking to name the new copied sheet

    Hi, I have a master sheet I want to be able to copy by pressing a button then getting a popup asking what name I the user wants to name the sheet and then use that to name the sheet.

    Thanks.
  19. Re: Multiple if statements to have a percentage

    This is perfect because its not dependent on the previous cell so if somebody skips one it will still report % completed. TY.

    NOTE: in my actual worksheet the cells were not next to each other so...
  20. Multiple if statements to have a percentage

    Hi, I'm not even sure how to title this and as such unable to find a solution which i'm sure is out there. Basically I'm looking to do a formula that says

    Basically i have 5 cells at as each gets...
  21. Replacing everything within [ ] with something else

    Hi I have formulas referencing different spreadsheets....

    [9U_Observations Tracker1.xlsx]Selection'!CX3

    ,... in sharepoint that seems to be broken through out the entire form so I want to...
  22. Replies
    5
    Views
    301

    Re: Zoom auto select and and copy

    Ah, that is where I went wrong...TY works perfectly!
  23. Replies
    5
    Views
    301

    Re: Zoom auto select and and copy

    TY however now when I click on the cell A2 it no longer zooms in to 130%, it doesn't do anything.
  24. Replies
    5
    Views
    301

    Zoom auto select and and copy

    Hi I currently have the following code that when I click on a pulldown menu it zooms in then when you clicks of zooms out.

    What I want is to still zoom in but once I click on selection it zooms...
  25. Replies
    1
    Views
    64

    Cross-reference cell

    Hi I need to cross reference Sheet1A1 against sheet2a:a. If match is found say true if not blank or false. Thanks
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4