Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    12
    Views
    116

    Re: More =IF formula issues

    Yongle You are right if the original cells were boolean values, I (maybe wrongly) thought they may be text, which, reading LiebKcir's latest post may well be the case.
  2. Re: Searching multiple values in Custom Filter

    To search for more than 2 matches at a time, you will need to either use the advanced filter or some vba. Have a look at advanced filter first. With that you can filter for many different values.
    ...
  3. Replies
    12
    Views
    116

    Re: More =IF formula issues

    Hi there. I think what is happening is that you are confusing boolean and text values at different points. If the copied values are TRUE or FALSE, these are text fields, not boolean. Typing TRUE into...
  4. Re: VBA Code to copy all files from Folder 1 to Folder 2

    Hi.

    There are many examples of how to do this on the web already. Ron De Bruin's website is one - look here for a complete solution: https://www.rondebruin.nl/win/s3/win026.htm
  5. Re: [VBA] Pivot Table make column headers show Day 12 instead of xx/xx/xxxx

    Hi there. This will produce the result you want i think:


    =""Day ""&(TODAY()-RC[-1]+1)
  6. Replies
    2
    Views
    132

    Re: Watermark problems in excel 2007

    Anyone got any insight here? Any way for me to put a watermark onto an excel page?
  7. Re: Merge Empty Cells with a cell with a date

    If the other 4 cells are ALWAYS blank (as you say), then simply sum them in column 6 and set the format of the column to what you want. The blanks get added up as zeroes, so you end up with just the...
  8. Re: Deleting a column and keeping correct formula.

    You're welcome and thanks for the feedback.
  9. Re: Deleting a column and keeping correct formula.

    Hi there. If the names start in the first column,just use the formula =COLUMN() in row 2. If the names start in a further column(e.g. it looks like your first name is in column C) then adjust the...
  10. Re: VBA split string and add to HTML body with formatting

    Thanks for the info. Peter. Now all I have to do is remember it!
  11. Re: VBA split string and add to HTML body with formatting

    Sorry. I forgot that this forum can misinterpret < and > characters. To do what you want, replace the variable forms in your output with Replace(forms,";"," < br > < br > "). Remove the blanks around...
  12. Re: VBA split string and add to HTML body with formatting

    You say it will be going into an html format. In that case, this will do it for you (change B2 to wherever your text is):

    strttext = Range("B2").Text
    EndText = Replace(strttext, ";", "<br><br>")
  13. Re: How to change dynamically excel external file name change daily as the date

    You need this to replace the red bit:

    &TEXT(TODAY(),"yyyymmdd")&
    So, the whole thing would be:

    =IF(FileExists(),VLOOKUP("NET EFFECT ON TRIAL...
  14. Re: I want to control the order of cell selection during data entry.

    Maybe E3 is locked?
  15. Replies
    5
    Views
    173

    Re: Adding Error with Copy & Paste

    Hi there. As the copy is done outside, you can't just use the paste function. Have a look at this reference to see how to read the contents of the clipboard - it also shows you how to handle empty...
  16. Re: How to autopopulate a textbox linked to a cell

    Try this:

    Private Sub UserForm_Initialize()
    Dim DateStr As String
    Dim ResultStr As String
    DateStr = Worksheets("Data").Range("B1").Text
    ResultStr = Right(DateStr, 1)
    For i = Len(DateStr) - 1...
  17. Re: How to autopopulate a textbox linked to a cell

    Glad to hear it worked. I assume B1 has in it something like "16/09/2019" but I'm still unclear on exactly what you want to see. Do you mean that you want to see (in textbox1) something like this:
    ...
  18. Re: How to autopopulate a textbox linked to a cell

    Hi there. You need to put the code that inserts the value in the userform initialize subrutine like so:


    Private Sub UserForm_Initialize()
    Me.TextBox1.Text = Worksheets("Data").Range("B1").Value...
  19. Replies
    5
    Views
    173

    Re: Adding Error with Copy & Paste

    If this is your code as typed (i.e. you haven't chopped out any lines from the middle) then your problem is because you have the error code directly after the paste statement, so it will always be...
  20. Replies
    3
    Views
    125

    Re: adding subquery in insert into

    Yeah silly me. Again untested:

    "insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) values('" & strRecordID & "', (select classid from employee where...
  21. Replies
    19
    Views
    320

    Re: Code numbering invoice

    Abdel, this is because you are using Dave's solution, which relies on formatting of the cell to show you the prefix. A combined version of my solution in post #2 and Dave's will work.


    Private...
  22. Replies
    19
    Views
    320

    Re: Code numbering invoice

    abdel. If you use my solution in post #2 you will get the full text in your userform
  23. Replies
    19
    Views
    320

    Re: Code numbering invoice

    abdel. Where are you putting the code we have provided (either solution works, mine fills the f9 cell with the full text, Dave's with just the number? You would need to refresh the data in the...
  24. Re: Search and return lowest value (sounds easy but it's trickier than it sounds)

    OK I have read your revised rules. See if this does it for you (a total of less than 5 of any NAT values will result in 5@3)

    ...
  25. Re: Search and return lowest value (sounds easy but it's trickier than it sounds)

    Hi there. This formula in I2 and copied down will produce the output you show:

    ="5@"&MIN(IF(COUNTIF(C2:H2,"NAT3")>0,3,99),IF(COUNTIF(C2:H2,"NAT4")>0,4,99),IF(COUNTIF(C2:H2,"NAT5")>0,5,99))
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4