Search:

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

Search: Search took 0.00 seconds.

  1. Thread: IF String

    by Thomo4321
    Replies
    8
    Views
    575

    Re: IF String

    For whatever reason the error was coming up for one cell but not the rest of them and since then has fixed itself.

    Thanks for your time on this
  2. Outlook 2016 to print attachments automatically

    Morning,

    I have the following code written up for me but I cant seem to get this to work.
    I have Outlook 2016 64 bit, i require all my invoices to be printed either as they come in or late in the...
  3. Thread: IF String

    by Thomo4321
    Replies
    8
    Views
    575

    Re: IF String

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  4. Thread: IF String

    by Thomo4321
    Replies
    8
    Views
    575

    Re: IF String

    Sorry,

    Should have placed that in the initial post.


    <tbody>
    A
    B
    C
    D
  5. Thread: IF String

    by Thomo4321
    Replies
    8
    Views
    575

    Re: IF String

    Thanks,

    I have tried this, but i forgot to mention in the post that the bought and sold values contain a date, DD/MM/YY
  6. Thread: IF String

    by Thomo4321
    Replies
    8
    Views
    575

    IF String

    Morning All,

    For some reason i cannot get the below IF string to work, keeps bringing up #Value ! error but will work if the Sold cell is blank.

    Thanks


    ...
  7. Replies
    2
    Views
    208

    Re: Simpler Macro required

    Thanks BlueAure,

    With every second %{Tab} It can be anything, but after the first %{Tab} i need to keep it as is as my program that im trying to enter info in doesnt like anything else, also some...
  8. Replies
    2
    Views
    208

    Simpler Macro required

    Afternoon All,

    I have the following Macro for the sample Table below.

    I would like the Macro to loop until it reaches the end of the table, at the moment i have the shortcut entered at the end...
  9. Replies
    2
    Views
    202

    Re: Formula to Multiply by a cell value

    arthurbr Works a treat, I thought there was something simple but just couldnt put my finger on it.

    Thanks
  10. Replies
    2
    Views
    202

    Formula to Multiply by a cell value

    Morning,

    For the life of me i can not think of a way to do this.

    So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2



    =IF([Average_Qty...
  11. Re: Macro to Add or Subtract- with clicking on a Cell

    Thanks All,

    Both of these options work great, I found the macros that JackDanIce has made as he has mentioned double clicking is an intentional act where as the single click will cause the cell to...
  12. Macro to Add or Subtract- with clicking on a Cell

    Hi,

    Im trying to have a macro to add or subtract, depending on which cell i click on.

    I have a + in Cell A1 and a - in Cell B1.

    I would like this macro to plus or minus 1 each time either of...
  13. Re: Excel to Copy and Paste to a non MS Program

    So i have figured out how to use sendkeys.

    The below is the macro i am currently running, but i would like this macro to continue on until the end of the table (roughly 5000 Rows)

    Thanks

    Sub...
  14. Excel to Copy and Paste to a non MS Program

    Morning,

    I am trying to figure out how to get Excel to integrate with another program that is not a MS program.

    All i am wanting to do is take a selection of data out of Excel, cell L:L and...
  15. Replies
    1
    Views
    121

    Macros not deleting selected ranges

    Afternoon,

    I have recorded the following Macro on Excel, All i am trying to do is delete all the unwanted info from the reports i download from the system at work and have it set up to how i want...
Results 1 to 15 of 15