Search:

Type: Posts; User: Michael M; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.48 seconds.

  1. Re: Conversion of column list to comma delimited string

    Aww stop it, now you're just making me feel redundant..:oops:
    Thanks for the pointer.
  2. Re: Conversion of column list to comma delimited string

    Peter_SSs
    I'm ever impressed...:pray:
  3. Re: Conversion of column list to comma delimited string

    Try using


    Sub MM1()
    Dim i As Integer, s As String
    i = 1
    Do Until Cells(i, 1).Value = ""
    If s = "" Then
    s = Cells(i, 1).Value
    Else
  4. Replies
    6
    Views
    120

    Re: Minimizing utility

    OOps...didn't realise that..:oops:....like it though !!
  5. Replies
    12
    Views
    263

    Re: proper syntax for With Rng/Evaluate?

    I think you are also asking for problems, If you are assigning a number to a variable called "formula"
    Call it n, or x, or anything but using the word formula.
  6. Replies
    9
    Views
    141

    Re: Case "Question"

    Keeping in mind of course that you may / may not need to loop through the sheets.
    So, if you want to apply / or not, the code to activesheets it could simply be


    Sub MM1()
    Select Case...
  7. Replies
    9
    Views
    141

    Re: Case "Question"

    Ahh...you mean like this ??


    Sub MM1()
    Dim ws As Worksheet
    For Each ws In Worksheets
    ws.Activate
    Select Case ActiveSheet.Index
    Case 1 "sheet number
    'Do stuff
  8. Replies
    9
    Views
    141

    Re: Case "Question"

    you confused me...:lol:



    For Each ws In Worksheets
    ws.Activate
    Select Case (ws.Name)'this doesn't change !!
    Case "Name1" 'this changes to your required sheet name !!
    ...
  9. Re: Organizing Columns w/ First and Last Names

    Why don't you sort by last name first, THEN join the names ??
  10. Replies
    9
    Views
    141

    Re: Case "Question"

    Something like this ??


    For Each ws In Worksheets
    ws.Activate
    Select Case (ws.Name)
    Case "Sheet1"
    'Do Stuff

    Case "Sheet2"
  11. Replies
    6
    Views
    120

    Re: Minimizing utility

    Fluff.....Whats with the new Avatar...:biggrin:
  12. Replies
    6
    Views
    120

    Re: Minimizing utility

    Just by looking at you screenshot..it is Subtotals....Grouping and Ungrouping.
    Have a look here on methods and How To !!

    https://www.contextures.com/exceldatasubtotals.html
  13. Replies
    4
    Views
    59

    Re: Passworded Sheet is NOT protected

    I know the people you may be dealing with, and I doubt there would be any effort on their part...but, you are aware that sheet protection is very weak and can be easily broken ???
  14. Replies
    4
    Views
    59

    Re: Passworded Sheet is NOT protected

    Is the worksheet that doesn't protect the one that holds the password.
    Also, why not put the password into the code via InputBox....so ask the user for the password to Protect the sheets, if it...
  15. Re: How do you query in excel? What would be the best program to complete this in?

    All I can suggest is looping through the directory, extracting the relevent worksheet and putting them all into 1 workbook.
    You could then extract to a "Summary" sheet from there.
    there is a...
  16. Re: Combining cells from multiple worksheets into rows on single worksheet

    That's probably the best "Guess" I have ever had....:lol:
  17. Thread: Inquiry

    by Michael M
    Replies
    7
    Views
    258

    Re: Inquiry

    You may need to provide more info, but have a look at Autofilter for your "above 35"....that might also give you your consecutive instances
  18. Re: SUMPRODUCT formula making spreadsheet run REALLY SLOW!

    Have you tried posting from home rather than at work ??
    Your IT dept might be locking you out....you could always tell IT to fix it, but I can already guess the response.
  19. Re: Combining cells from multiple worksheets into rows on single worksheet

    I'll put this up and the OP can adjust the range to suit.
    But I'm willing to bet there is more to this than we see here, it'll get MUCH bigger...:lol:


    Sub MM1()
    Dim ws As Worksheet, c As...
  20. Re: Combining cells from multiple worksheets into rows on single worksheet

    I'm guessing a sheet for each customer / client / patient, with a need for their personal data on a Master...??
  21. Re: Combining cells from multiple worksheets into rows on single worksheet

    In that case you will need to provide ALL the necessary information !!
    The code I provided will copy all of the data from each sheet onto the Master Sheet
  22. Re: Combining cells from multiple worksheets into rows on single worksheet

    How about


    Sub MM1()
    Dim r As Long, Ur As Range, I As Integer
    For I = 2 To Sheets.Count
    Set Ur = Sheets("Master").UsedRange
    If I > 2 Then
    On Error Resume Next
    Set Ur =...
  23. Replies
    10
    Views
    172

    Re: Fill Series greyed out...

    OK, I can't replicate the problem with your workbook
    it works fine for me with the drag and fill.
    It works with Fill series and it works with Autofill !
    Only thing I can suggest is save the...
  24. Replies
    10
    Views
    172

    Re: Fill Series greyed out...

    Can you upload the fiel to dropbox....can't replicate the problem with a picture ???
  25. Replies
    3
    Views
    103

    Re: Not sure where to start. NOOB Q

    Are both of those files .JPG's ??
    We can't help much with a picture.
    You need to upload the actual file
    Dropbox tells me the files don't exist !
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4