Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    12
    Views
    123

    Hi Zeddy Thanks very much for the help. The...

    Hi Zeddy

    Thanks very much for the help. The code works perfectly

    Say for eg branch names are KTL PA, KTL UIT, KTL CPT etc i.e spaces in the branch name, how to I amend the code below, which I...
  2. Replies
    12
    Views
    123

    Hi Zeddy The data is filtering all the data...

    Hi Zeddy

    The data is filtering all the data from sheet "Recon" to sheet BR1 and no data is filtered to the other BR sheets

    I have attached the workbook

    Please test & amend the code
  3. Replies
    2
    Views
    49

    Thanks for the help. I have reset the IE settings...

    Thanks for the help. I have reset the IE settings and so far it have had no problems
  4. Replies
    12
    Views
    123

    Hi Maud I still can't get the code per my post...

    Hi Maud

    I still can't get the code per my post #4 to work. I still get run time error 1004 Method "range of object_Global failed"

    I have attached the sample file


    It would be appreciated if...
  5. Replies
    12
    Views
    123

    Thanks Maud Code works perfectly

    Thanks Maud

    Code works perfectly
  6. Replies
    2
    Views
    49

    Internet Explorer shuts down

    I am using IE 11 and Windows 10. From time to time IE comes up with a message that it has found a problem and needs to close down

    I would like to know how to overcome this
  7. Replies
    12
    Views
    123

    Maud I have another workbook, where I have...

    Maud

    I have another workbook, where I have data on sheet "Recon" and want to copy the data from A2:O to sheets 10 onwards except the last sheet based on criteria in Col Q. I have named the...
  8. Replies
    12
    Views
    123

    Hi Maud Thanks for the help much appreciated ...

    Hi Maud

    Thanks for the help much appreciated

    I have added code to first clear the data from row 2 onwards on sheets 2 to 4, otherwise each time I select the macro it then copies the data from...
  9. Replies
    12
    Views
    123

    Advanced Filter Macro

    I have set up criteria on sheets (2) "branch1" to sheet (4) in Col J containing the heading "Branch codes"


    I have set up a macro to extract the data from sheets (1) Col A:F based on the criteria...
  10. Replies
    6
    Views
    117

    Thanks Zeddy This is also very useful ...

    Thanks Zeddy

    This is also very useful


    Howard
  11. Replies
    6
    Views
    117

    My Apologies. I had a type, so I thought that txt...

    My Apologies. I had a type, so I thought that txt had to be in upper case
  12. Replies
    6
    Views
    117

    Hi RG Thanks for your help and your comments,...

    Hi RG

    Thanks for your help and your comments, which I fully understand and appreciate

    Kindly amend your function to accept both upper and lower case


    Howard
  13. Replies
    6
    Views
    117

    Vlookup problem pertaining to two sheets

    On sheet “Applicable Branch” Col H, I am trying to look up the branch code for the applicable stock number. The branch codes are on sheet "Stock Sheet" .

    Where "CB","AVI TRADERS","CN" appears on...
  14. Hi Maud Managed to sort this out by amending ...

    Hi Maud

    Managed to sort this out by amending


    ThisWorkbook.Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteValues

    to
  15. Thanks for the compliment Maud I tried to make...

    Thanks for the compliment Maud

    I tried to make one small change to your code, so when the data is copied, it value pastes the data.

    Your code


    With .Sheets(1)
    ...
  16. Hi Maud Thanks very much for the help. Code...

    Hi Maud

    Thanks very much for the help. Code works perfectly. I have been through your code and fully understand how it works


    Howard
  17. Hi Maud I tried to adapt your code to another...

    Hi Maud

    I tried to adapt your code to another worksheet, but nothing is pasted into the destination workbook

    I need to open up a workbook "CRE TB Consolidation IS & BS.xls" and copy the data...
  18. Replies
    2
    Views
    124

    Thanks very much for the help Maud, much...

    Thanks very much for the help Maud, much appreciated
  19. Replies
    2
    Views
    124

    Formua to compute correct value based on account numbers

    I have set up a macro to copy data in sheet "Inc St" from N2 to the last row containing data in Col N to A2 on sheet "Input Acc numbers" and then the macro deletes blank cells

    I have tried to set...
  20. Replies
    1
    Views
    66

    I have amended my formula from ...

    I have amended my formula from


    =IF(C2=0,"",IFERROR(C2-INDEX(F:F,MATCH(A2&"",D:D,FALSE)),C2))

    To (removed &"")


    =IF(C2=0,"",IFERROR(C2-INDEX(F:F,MATCH(A2,D:D,FALSE)),C2))
  21. Replies
    1
    Views
    66

    Compute variance in two columns

    I have tried to set up a formula to compute the variance in Col G showing the difference in the values between Col C & F based on the account numbers on Col A & D

    I have shown the correct...
  22. Thanks for thehelp Maud

    Thanks for thehelp Maud
  23. Hi Maud Thanks for your help. The code still...

    Hi Maud

    Thanks for your help. The code still requires me to select the workbooks to open and when I do no data is copied and pastd into the destination workbook

    The Code in Post # 1 works...
  24. Thanks for the reply Nicole No data is being...

    Thanks for the reply Nicole

    No data is being copied

    I need the workbooks to be automatically opened and the data copied from A2 to the last row in Col D from sheet 4 in the source workbook to...
  25. Macro to open specific workbooks and copy data

    I have code below to open up workbooks by having to select each workbook and to copy from sheet 4 (Source workbooks) to sheet2 (Destination workbook) after the last row containing data

    I would...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4