Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    0
    Views
    22

    Formula to extract ref numbers

    I have reference numbers in sheet1 and reference numbers in sheet2

    I would like to compare the reference numbers on sheet1 with sheet input

    Where the reference number is on both sheets, I would...
  2. Macro to extract data based on certain Criteria

    I have a spreadsheet where I need certain codes and values extracted based on certain criteria

    1) Where Code 765915 appears in Col G, I want the value extracted as well as the code above. However,...
  3. Replies
    2
    Views
    80

    Thanks for the help Don

    Thanks for the help Don
  4. Replies
    2
    Views
    80

    Selecting item in Drop down

    I would like to be able to select an item in the drop down-se attached and go to the cell number where the cell is in Col A for eg if I select BRZZ1, I must then go to A4

    See sample data attached...
  5. Replies
    2
    Views
    185

    Thanks for your input Maud I would like to...

    Thanks for your input Maud

    I would like to amend my code below, so that if I copy more data from a source file, It will copy the data after the last row in Col A


    Sub copyDataFromSource()...
  6. Replies
    2
    Views
    185

    Macro to check if existing data

    I would like to amend my Macro to check if there is existing data on any of the sheets. If so, then to create a new sheet and to copy the data in the sheet created

    I have attached sample data...
  7. Replies
    2
    Views
    101

    Hi Zeddy Thanks for the help, match...

    Hi Zeddy

    Thanks for the help, match appreciated


    Howard
  8. Replies
    2
    Views
    101

    Formula or Macro to Match Values

    I have debit values in Col B & credit values in Col C

    I would like to set up a formula or macro to match the values that are the same and to delete the rows where these match
  9. Replies
    4
    Views
    295

    Thanks for the info Guys

    Thanks for the info Guys
  10. Replies
    4
    Views
    295

    Message Help us protect your account

    I have Windows 8 operating system

    When I tried logging into Skype, I get the following message

    Help us protect your account

    We detected something unusual and need to verify your account....
  11. Replies
    0
    Views
    404

    Increasing the number of libraries

    I have several libraries created on Windows 7. However, when trying to create a new library nothing happends. I guess I have reached the maximum level. Is there a way to increase the number of...
  12. Thanks Maud, never thought of this. Have amended...

    Thanks Maud, never thought of this. Have amended code and it works perfectly
  13. Macro to copy data , except where = sum appears

    I have code to copy the Data in Col F (closing Balances) and to paste value these in Col C (Opening Balances) from row 3 onwards, except where the data contains an = sum formula. Where there is an ...
  14. Hi Guys Thanks for your input, much appreciated

    Hi Guys

    Thanks for your input, much appreciated
  15. Hi Maud Agree 100%. I'm going to use your...

    Hi Maud

    Agree 100%. I'm going to use your suggestion by placing an apostrophe in front of the section as mentioned by you
  16. Hi Maud The source files were developed by...

    Hi Maud

    The source files were developed by someone else so I did not want to amend their code, but I will ask the person to put an apostrophe in front of their code as this is the easiest way
  17. Thanks for pointing this out Maud. I was hoping...

    Thanks for pointing this out Maud. I was hoping that there may be another way. I will put an apostrophe in front of the message Box for all the files containing this message box statement
  18. Hi Guys Sorry for the confusion caused See...

    Hi Guys

    Sorry for the confusion caused

    See code below from original workbook which generates the message box in the source workbook. When calling this from the destination workbook, I want OK...
  19. Hi RG Thanks for the help. I used your code...

    Hi RG

    Thanks for the help. I used your code and called it from within my macro using application.run "DisplayMsgBox", but the message box still appears and I have to select the "OK" button to...
  20. Thanks for the info Maud, however the message box...

    Thanks for the info Maud, however the message box with the OK button still appears
  21. Code to automatically accept OK button without clicking it

    I have a macro that opens several files and activates a particular macro that brings up a message box that prompts the user the "OK" button

    I would like code to would automatically accept the "OK"...
  22. Replies
    7
    Views
    326

    Thanks for your input dguillett

    Thanks for your input dguillett
  23. Replies
    7
    Views
    326

    Hi Maud Thanks for the help and your input

    Hi Maud

    Thanks for the help and your input
  24. Replies
    7
    Views
    326

    Macro to open Files

    I have a spreadsheet, where I want to open all the files that are listed on sheet "workspace" in a folder called C:\Pull as well as the sub-folders

    I have tried to write code to do this -see code...
  25. Thread: Library

    by HowardC
    Replies
    2
    Views
    258

    Thanks for the reply. Much appreciated

    Thanks for the reply. Much appreciated
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4