Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    58

    Hi Joe Thanks for letting me know

    Hi Joe

    Thanks for letting me know
  2. Replies
    2
    Views
    58

    Outlook Attachment Reminder

    I had an attachment reminder for Outlook "Code 2 Outlook attachment reminder"

    It worked perfectly for Office 2010, but I recently upgraded to Office 2013 and when selecting the send button on...
  3. Thanks for the reply. The descriptions are...

    Thanks for the reply.

    The descriptions are already on the Consolidation sheet and just the values need to be carried over
  4. Thanks Maud. Where the following appears under...

    Thanks Maud.

    Where the following appears under Dept1 for the first time , would it be possible to write code to insert the description "RETAIL SALES/EXPORT-SUMMARY" next to each of these in Col A....
  5. Thanks for the help Maude Where the...

    Thanks for the help Maude

    Where the decriptions are unique to a particular sheet for eg BR2 the values must also be copied to the consolidated sheet


    For example Units Sold
    Gross Sales

    ...
  6. Thanks for the reply Steve. I will import Trial...

    Thanks for the reply Steve. I will import Trial balances where the account numbers are exactly the same and then set up a standard management report
  7. Thanks for the reply, Steve Looking at your...

    Thanks for the reply, Steve

    Looking at your points 1 - 4, I now see that this is going to cause a huge problem

    There may be a way to resolve this. If there is a way to extract unique...
  8. Hi Steve What I mean by consolidate is to...

    Hi Steve

    What I mean by consolidate is to combine the values where the descriptions are the same in a given Range for Eg Dept 1 ranges from 1 to 125

    For eg I would like to add the values for...
  9. Consolidating Data where the descriptions are common

    Attached please find sample data where I would like to consolidate the values on sheet Br1 & BR2 (Cols F & H) where the text in Col B is the same by department.

    I also need a macro to clear the...
  10. Replies
    8
    Views
    141

    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
  11. Replies
    8
    Views
    141

    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
    ...
  12. Replies
    8
    Views
    141

    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...
  13. Replies
    8
    Views
    141

    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...
  14. Hi Maud Thanks for the help, much appreciated...

    Hi Maud

    Thanks for the help, much appreciated

    Howard
  15. 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...
  16. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    132

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

    Hi Tom

    Thanks for the advise. Will Try this

    Regards

    Howard
  17. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    132

    Thanks for the info Martin Howard

    Thanks for the info Martin

    Howard
  18. Thread: Copy & Paste

    by HowardC
    Replies
    4
    Views
    132

    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
  19. 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
  20. 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...
  21. 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
  22. Replies
    2
    Views
    107

    Hi Maud Thanks for the help Howard

    Hi Maud

    Thanks for the help

    Howard
  23. 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...
  24. Replies
    2
    Views
    107

    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...
  25. Replies
    7
    Views
    389

    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
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4