Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    86

    Updating a status

    Looking for help with the below....


    Basically,

    I want to track the status of an item.

    If i am to enter a date lets say in column C which is titled " Item setup date" i would like the...
  2. Thread: Weeknum

    by TheRins3r
    Replies
    8
    Views
    175

    Re: Weeknum

    Your formula works, i forgot to change the lookup cells when i pasted it in!!

    Thanks very much.
  3. Thread: Weeknum

    by TheRins3r
    Replies
    8
    Views
    175

    Re: Weeknum

    yes , it is a date.
  4. Thread: Weeknum

    by TheRins3r
    Replies
    8
    Views
    175

    Re: Weeknum

    Unfortunately that did not work, see below example where the new week count starts at 0 and should start at 1


    <tbody>
    28/06/2019
    28-Jun-19
    2019
    JUN Qtr
    June
    13
  5. Thread: Weeknum

    by TheRins3r
    Replies
    8
    Views
    175

    Weeknum

    I have a formula below , where I need the week number from 1 - 13 depending on the upload date & what Qtr we are in.



    =WEEKNUM(J4058)-WEEKNUM(LOOKUP(J4058,DATE(YEAR(J4058),{3,6,9,12},30)))

    ...
  6. Replies
    8
    Views
    159

    Re: Concatanation problem

    That worked perfectly Jeff, Thanks a lot.
  7. Replies
    8
    Views
    159

    Re: Concatanation problem

    Thanks Jeff,

    That almost worked, apolgies.

    The data which i need from A, needs to be added into B ( and replace/delete the following "XXXXXXXXXXXXXXXXXXXXXXXXX".
    It also added a space before...
  8. Replies
    8
    Views
    159

    Re: Concatanation problem

    It needs to be placed as the 49th character in a string of text that totals 104.
  9. Replies
    8
    Views
    159

    Re: Concatanation problem

    Hi Jeff, Thanks for your help.

    Basically i have 30k lines i need to do this for, i need to copy text from column A "TEXT1" and paste it into column B.
    I want to keep what is in B and add the data...
  10. Replies
    8
    Views
    159

    Concatanation problem

    Hi All,

    I am looking to take data from column A and paste it into column B.
    However, i need to paste it into the middle of a string of text that lies in B.

    Help would be much appreciated.
  11. Replies
    2
    Views
    113

    Re: Creating an IF statement

    <tbody>
    Overall Status
    Data A
    Data B
    Data C
    Data D


    Ready / Testing / Production etc
    When i enter Data here, i want the "Overall status" to update.
  12. Replies
    2
    Views
    113

    Creating an IF statement

    Hi Folks,

    Hope you can help me.

    I have created a log, where i populate daily with certain data.
    What i am ltrying to achieve is, when i enter data into column D letys say, it automatically...
  13. Replies
    3
    Views
    138

    Re: MsgBox prompt

    thanks a lot, they both worked :)
  14. Replies
    3
    Views
    138

    MsgBox prompt

    Hi,

    I am looking to add a MsgBox with Yes/No prompt, below is how far i have got.

    Answer = MsgBox("Have you set Bla Bla to Active?", vbYesNo)
    If Answer = vbYes Then


    Else If Answer = vbNo...
Results 1 to 14 of 14