Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    3
    Views
    67

    Re: Easiest Way To Concatenate

    I was doing it wrong, seems to do what I need. Thanks.
  2. Replies
    3
    Views
    67

    Re: Easiest Way To Concatenate

    Thanks, probably doing it wrong but just get results of #VALUE !
  3. Replies
    3
    Views
    67

    Easiest Way To Concatenate

    I have a sheet as below with several dozen columns and thousands of rows. I want to join each column separtated by a / and a space. They are set out like below but if i do a normal concatenate...
  4. Replies
    7
    Views
    222

    Re: Help & Advice On A VLookup/Match Maybe?

    Seems to work great, thanks for your help. Also jkpieterse.
  5. Replies
    7
    Views
    222

    Re: Help & Advice On A VLookup/Match Maybe?

    Thanks but that's not working for me, just returning #N/A all the way down.
  6. Replies
    7
    Views
    222

    Help & Advice On A VLookup/Match Maybe?

    I don't really know how to explain this!! I have 2 sheets with a massive amount of data. Sheet 1 will have numbers with a 2 letter prefix then 4 or 5 numbers then letters again, and so will sheet 2....
  7. Code Or Formula To Tell Me The Most For A Number In Column A

    I have column A below with a list of numbers, next in B is another list of numbers. I need a formula or code to tell me the highest amount for a said number. Below in rows 17-20 is the most for the...
  8. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    Perfect thanks Mick.
  9. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    Sorry thats not correct. I may have misled you but is going like this

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse:...
  10. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    A I think!
  11. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    Seems to have been a rogue character messing it up.
  12. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    Yes they must all be exactly as they are as they are part numbers. (also it will have to sort other columns with data in as you mentioned in an earlier post). Thanks Mick.
  13. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    Thanks Mick. I thought you may be able to read through the code like I would the sports pages, sorry about that!

    I run the code but got a visual basic error 400

    Sheet 1 Before Code

    Excel...
  14. Replies
    36
    Views
    2,821

    Re: How Do I Sort Alpha Numerically?

    Hi Mick this code works great but I think it only caters for a 2 letter prefix. Can it be amended for any number of letters before the numbers please?
  15. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    Worf I am now getting a run-time error '13' type mismatch and when I debug it points to this line?

    dest.Resize(d.Count).Value = WorksheetFunction.Transpose(d.Keys)
  16. Replies
    19
    Views
    640

    Re: Code To Delete Columns Containing No Data

    Works perfect thanks mumps. Thanks oldbrewer also for your efforts.
  17. Replies
    19
    Views
    640

    Re: Code To Delete Columns Containing No Data

    Thanks but there will be thousands of rows and dozens of columns, how would that affect the code?
  18. Replies
    19
    Views
    640

    Re: Code To Delete Columns Containing No Data

    Hi. Would this code be able to be adapted where it deletes rows rather than columns when there is nothing in them apart from column A? Thanks.
  19. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    Working much better now, thanks for all your time.
  20. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    Would you PM me your email again please.
  21. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    I know this is not the reason but I have changed PCs but its the same version of Excel. Only thing I can think of why it stopped working all of a sudden!
  22. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    But I get that visual basic 400 error now.
  23. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    No line, that message box pops up as soon as I run it. As I said it seemed to work perfect for 8 characters so I have adapted my data for that but if it could be for more it would be great.
  24. Replies
    76
    Views
    3,877

    Re: Code To List Numbers Missing From Sequence

    For some reason now I am getting invalid procedure call or argument?
  25. Replies
    5
    Views
    251

    Re: Change Part Of Before Save Code In Bulk?

    Thanks for the reply but I don't understand it!!

    It doesn't matter if the code opens, makes the changes and closes them again.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4