Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.52 seconds.

  1. Re: Need to paste multiple rows in Excel multiple times

    OK, this will post below the existing data


    Sub MM1()
    Dim x As Integer, r1 As Range
    x = InputBox("Enter the number of times to copy the range")
    With Range("C1:G3")
    Set r1 =...
  2. Re: Can someone help me with this? Probably a beginner level formula.

    That's a quantum leap from your first post....and you thought it was a beginner formula ??
    You might need to VBA the summary sheet...!
  3. Re: Need to paste multiple rows in Excel multiple times

    Where are you going to paste the rows ??
  4. Re: Can someone help me with this? Probably a beginner level formula.

    I'm with sandy666 on this one !!!
    Time to learn Pivot tables....it's pretty simple
    Date as filter
    Location as columns
    Flavor as Rows
    Totals as values


    I think a formula would be incredibly...
  5. Replies
    14
    Views
    279

    Re: microsoft excel has stopped working.

    There are no files on the link you have provided....I'm out of this thread !!...:banghead:
  6. Replies
    2
    Views
    115

    Re: Making an idiot proof one step sheet.

    This will do the formula down col "F"


    Range("F2:F" & Cells(Rows.Count, "E").End(xlUp).Row).Formula = "=(YEAR(NOW())-YEAR(E2))"
  7. Replies
    14
    Views
    279

    Re: microsoft excel has stopped working.

    You can't attach files in this forum.
    I'd suggest looking at available options here
    https://www.mrexcel.com/forum/about-board/508133-attachments.html
    OR
    Upload your file to a sharing site,...
  8. Re: extracting number from text string and doing calculations

    looks like an assignment to me !
    what have you tried so far AND how did you arrive at The first sum should be 280*4 ??
  9. Replies
    14
    Views
    279

    Re: microsoft excel has stopped working.

    Is scorecard an Excel form or a 3rd party app.

    Also, look here for possible solutions.
    ...
  10. Replies
    14
    Views
    279

    Re: microsoft excel has stopped working.

    It would help if you provided the macro that is causing the problem !
    AND
    we can't see an image that is on your HDD !
  11. Re: Can someone help me with this? Probably a beginner level formula.

    This without the flavours


    =SUMPRODUCT(--(B2:B15=F3)*(C2:C15=G3)*(D2:D15))


    This with a choice of flavours


    =SUMPRODUCT(--(B2:B15=F3)*(C2:C15=G3)*(A2:A15=H3)*(D2:D15))
  12. Re: Can someone help me with this? Probably a beginner level formula.

    Can you paste the sample data here please?

    HAve a look here for posting data to the forum

    https://www.mrexcel.com/forum/about-board/508133-attachments.html

    Sounds like a SUMPRODUCT would do...
  13. Replies
    4
    Views
    112

    Re: help with macro issue

    Thanks Peter, it WAS an assumption that may have been wrong....or not, depending on the data.
    I also wondered if EVALUATE would be able to be used here....but for the life of me, EVALUATE does my...
  14. Replies
    4
    Views
    112

    Re: help with macro issue

    My offer....although Peters will be much quicker


    Sub MM1()
    Dim c As Long, r As Long, ws As Worksheet, n As Long
    For r = 1 To 22
    For c = 1 To 10
    n = 0
    For Each ws In...
  15. Replies
    4
    Views
    97

    Re: enabling macros

    File>>Options>>Trust Center>>Trust Center settings>>Macro Settings>>Enable macros>>OK>>OK
  16. Re: How do you query in excel? What would be the best program to complete this in?

    With the amount of data that may be involved, I would think Access would be the choice
    Have a read here on Exporting data to Access....step by step !!
    ...
  17. Replies
    9
    Views
    131

    Re: Why am I getting an overflow error

    what value is Ref when you hover over it and why have you declared it as String

    Ref = sh3.Cells(Rows.Count, 1).End(xlUp).Value
  18. Re: adding $ before a number vs selecting currency/accounting format

    Generally, no.....but why would you do that, instead of simply formatting the number correctly !
  19. Replies
    2
    Views
    123

    Re: Need help to do Macro.

    Why not simply use the macro recorder, doing the steps you provided ???
  20. Replies
    8
    Views
    231

    Re: Excel 365 Advanced Filtering

    You and me both Mike !!!!!
  21. Replies
    17
    Views
    439

    Re: Empty textbox needs text

    Did you change the name of the textbox in Kenneth code to your textbox name
  22. Replies
    9
    Views
    84

    Re: Excel is creating very large files

    Duplicate thread here

    https://www.mrexcel.com/forum/excel-questions/1109672-excel-has-saved-my-file-size-79-1mb-81-147kb-how-do-i-reduce-size.html
  23. Replies
    9
    Views
    84

    Re: Excel is creating very large files

    You may have a corrupted workbook
    Firstly, another clear method

    Sub MM1()
    Dim lastRow As Long, ws As Worksheet
    For Each ws In Worksheets
    ws.Activate
    lastRow = Cells(Rows.Count,...
  24. Re: Evertything seems to paste only in column A

    What does seperate the data ??
    Can you post a small sample of the SQL data ??
    Are you using a macro to import the data ?
  25. Replies
    9
    Views
    84

    Re: Excel is creating very large files

    You are saving AND closing...then reopening aren't you ??
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4