Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: Macro to change amount of next bill and carry it forward

    Thank you Fluff,
    As always you are a great help :-)

    Tony
  2. Macro to change amount of next bill and carry it forward

    Hi Everyone,

    Ok so a bit of a strange one i'm doing a Billing cycle that shows how much is owed but i need to be able to adjust the amounts and could do with a macro to help.

    So I have three...
  3. Replies
    3
    Views
    66

    Re: Macro to swap data around

    Briiliant thanks Joe
  4. Replies
    3
    Views
    66

    Macro to swap data around

    Hi Everyone,

    I have data in cell D5:D6 that needs to go into F5:F6
    but need whats in F5:F6 to go into D5:D6

    with a macro

    please help if you can

    thanks
  5. Create tabs for each name in horrizontal list and add there data

    Hi Everyone,

    I have data I want to split up into clients names.
    In range K5:"Last column" & 5
    I have a list of clients names

    I want to create a tab for each client and add there data to that...
  6. Macro to open a sheet in a new window

    Hi Everyone,
    Hope you can help

    I want a macro that can open a sheet in a new window.
    Idealy it would do this.

    When macro is run open Sheet"PDF Views" in new window and
    if possible?
    place...
  7. Re: Find the last row with data in it in a row of formulas?

    Thanks Fluff,
    worked perfectly :-)
    Tony
  8. Find the last row with data in it in a row of formulas?

    Hi Everyone,

    I have a small range of BJ28:BJ42
    I want to find the lastrow that contains data,
    they all contain formulas so my normal lastrow method select every row,
    but the formulas have "(IF...
  9. Re: Macro to copy data from the other open xmls document to this one?

    Hi Mumps,
    This is great, thank you very much
    Tony
  10. Macro to copy data from the other open xmls document to this one?

    Hi Everyone,

    Hi you can help me.
    I have a document my boss uses all day everyday and he keeps asking me to add new deshboards etc.
    The thing is it takes me a while to do this which mean this...
  11. Re: Find highest number when mixedwith text in each cell

    Thank you final flight but thats what I tried and get CA9 above CA4000 (as examples) because it see them as alphabetical.
    mikeerickson, brilliant, thank you fixed that problem perfectly :-)
    Tony
  12. Find highest number when mixedwith text in each cell

    Hi everyone,
    I need to find the highest invoice number but the cels are not numbers but text

    They look like this,


    <colgroup><col></colgroup><tbody>
    CA0939
  13. Re: Macro to add tab name to cell and check if its there?

    Brilliant, thanks Neil :-)
  14. Macro to add tab name to cell and check if its there?

    Hi Everyone,
    I need two macros and not sure the best way to do them

    I need one macro that when run take the activesheets name and adds it to Control range A35

    Then another that when run looks...
  15. Re: Has anyone got examples of VBA code for API's

    bomp
  16. Has anyone got examples of VBA code for API's

    Hi Everyone,

    I have to pull data from a site called Harvest.
    the data i want is employees time logs

    I understand this can be done and was told when we got the software that its easy but i...
  17. Re: Macro to check if a cell has been filled in if cell next to it is?

    Hi Joe,
    Worked first time perfectly,
    Took out the veriffied part but handy to have it there as I'm bound to use this again and again.

    Thanks

    Tony
  18. Re: Macro to check if a cell has been filled in if cell next to it is?

    Hi Joe,
    The macro runs when they press a button so normal macro is fine thanks
  19. Macro to check if a cell has been filled in if cell next to it is?

    Hi Everyone

    I need a macro to mack sure people are filling in both columns
    what I need is if

    any cells in Range AH52:AH252 have data in them then check that the same row for column AG has...
  20. Re: Deleting spaces from blank cell in sheet?

    Thank you Fluff,
    Seams to hsve done the job nicely :-)
    Tony
  21. Re: Deleting spaces from blank cell in sheet?

    Hi Fluff,
    it came back with 160
    Thanks
    Tony
  22. Deleting spaces from blank cell in sheet?

    Hi Everyone.
    I need a macro that can help me clean up my data range.
    We export data from our CRM system which is very old and the data needs sorting out before i can do anything with it.
    I've done...
  23. Re: Can I get this macro to run all the code before opening the PDF?

    Thanks Johnny C,
    I will give this a go and play around with timings etc.
    thanks
    for the input :-)
    Tony
  24. Can I get this macro to run all the code before opening the PDF?

    Hi Everyone,

    I have a macro below that works great but looks ugly,
    what i mean is it opens the pdf half way through the macro, so when you close the pdf it shows me a half loaded screen and a...
  25. Re: Can I run a macro after i've pasted?

    Now just to be a pain, would it be possible to have two options Paste and paste values? some people do one some the other!

    Thanks again for everything you have done

    Tony
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4