Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    8
    Views
    120

    Hi Steve My apologies. I must have deleted the...

    Hi Steve

    My apologies. I must have deleted the macro in error

    I managed to sort out an error in my code.

    In my code I had
  2. Replies
    8
    Views
    120

    Hi RG & Steve It would be appreciated if one...

    Hi RG & Steve

    It would be appreciated if one of you can assist me in getting the macro "Delete_next_period" to work. If I delete this macro, then the other macros in the workbook can be run
    ...
  3. Replies
    8
    Views
    120

    Thanks for the reply I have filtered data that...

    Thanks for the reply

    I have filtered data that is imported on sheet "Data". I manually filter the data for a specific month number in Col O for Eg 10 and then delete these rows. I then refilter...
  4. Replies
    8
    Views
    120

    Macro Security Issue

    When trying to activate any of the macro on the attached workbook I get a message regarding macro security (has also attached screen print of message)

    I have look at my macro security settings and...
  5. Hi Maud Thanks for the help, much appreciated...

    Hi Maud

    Thanks for the help, much appreciated

    Howard
  6. Hi Maud In the text box containing the cost...

    Hi Maud

    In the text box containing the cost (Txtcost), I would like the code amended, so that if there is a xzero after the decimal pace for eg 7040.00 and the user enters 7040, the code will...
  7. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    116

    Hi Tom Thanks for the advise. Will Try this ...

    Hi Tom

    Thanks for the advise. Will Try this

    Regards

    Howard
  8. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    116

    Thanks for the info Martin Howard

    Thanks for the info Martin

    Howard
  9. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    116

    Copy & Paste

    From time one uses Ctl C to copy, it does not always copy and one needs to rerpeat the process

    Is this an intermittent Microsoft problem?

    It does not happen often -only every now and then
  10. Hi Maud I overlooked this (Dim I as Integer)....

    Hi Maud

    I overlooked this (Dim I as Integer). Have tested and code works perfectly

    Once again thanks for all the help

    Howard
  11. Hi Maud Thanks for your help. I am getting...

    Hi Maud

    Thanks for your help. I am getting closer to the desired result.

    After entering the data and selecting "Add Fixed Assets" , I get a message "compile error variable not defined and the...
  12. Thanks for all the help Maude I will get back...

    Thanks for all the help Maude

    I will get back to you tomorrow as I need to test the code this evening (it is 14:48pm over here)

    Howard
  13. Replies
    2
    Views
    98

    Hi Maud Thanks for the help Howard

    Hi Maud

    Thanks for the help

    Howard
  14. Amending User Form to set number of times data to be copied

    I have a Template was a user form which is activated on sheet "Macro"

    The user form copies the data into the vrespective fields once "add Fixed assets" is selected.

    I would like to amend the...
  15. Replies
    2
    Views
    98

    Macro to clear data on all sheets

    I have a macro that clears data on all sheets , except the first and last sheet .

    The following are the exceptions :

    1) It must not clear text for Eg Oct 2013, Man etc
    2) Where a value...
  16. Replies
    7
    Views
    373

    Hi Zeddy Thanks for the reply. Hope you have...

    Hi Zeddy

    Thanks for the reply. Hope you have made a full recovery. I overlooked your reply. It works perfectly

    Howard
  17. Managed to resolve problem

    Managed to resolve problem
  18. Macro to copy Numeric Number and character

    I have a spreadheet containing data in Col K. Where there are numberic characters combined with the alpha's for Eg 1050M, 1050S, W1131 (highlighted numerical and alpha characters), then these must be...
  19. Replies
    6
    Views
    167

    Thanks for the tip Howard

    Thanks for the tip

    Howard
  20. Replies
    6
    Views
    167

    Thanks Steve Did not check the raw data to...

    Thanks Steve

    Did not check the raw data to determine whether there was data aged between 60 -90 days. it makes perfect sense

    Howard
  21. Replies
    6
    Views
    167

    Hi Steve Have set to grouping to Starting...

    Hi Steve

    Have set to grouping to

    Starting at: 30
    Ending at: 120
    by: 30


    However, I am not getting the band 60-90 -see attached file
  22. Replies
    6
    Views
    167

    Pivot Table Ageing

    I have a Pivot Table and have tried to group as follows but cannot get it right

    < 30 days
    30-60
    61-90
    91-120
    > 120

    It would appreciated if someone could assist me on how to resolve the...
  23. Replies
    5
    Views
    196

    Thanks for this info, Paul

    Thanks for this info, Paul
  24. Replies
    5
    Views
    196

    Hi Paul Thanks for the information. The PDF is...

    Hi Paul

    Thanks for the information. The PDF is not published as an image. Are there any PDF readers you can recommend? I will also try Libre Office

    I found some software that can convert PDF to...
  25. Replies
    5
    Views
    196

    PDF to CSV Converter

    I am looking for a software that converts PDF to CSV file format

    I have a PDF file that is downloaded each month from a supplier , but need it to be in CSV format as the CSV file needs to be...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4