# Search:

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

Page 1 of 6 1

1. ## Thread: Need to paste multiple rows in Excel multiple times

by Michael M
Replies
4
Views
73

### 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. ## Thread: Can someone help me with this? Probably a beginner level formula.

by Michael M
Replies
32
Views
403

### 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. ## Thread: Need to paste multiple rows in Excel multiple times

by Michael M
Replies
4
Views
73

### Re: Need to paste multiple rows in Excel multiple times

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

by Michael M
Replies
32
Views
403

### 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...

by Michael M
Replies
14
Views
279

6. ## Thread: Making an idiot proof one step sheet.

by Michael M
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. ## Thread: microsoft excel has stopped working.

by Michael M
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
OR
8. ## Thread: extracting number from text string and doing calculations

by Michael M
Replies
5
Views
114

### 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. ## Thread: microsoft excel has stopped working.

by Michael M
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. ## Thread: microsoft excel has stopped working.

by Michael M
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. ## Thread: Can someone help me with this? Probably a beginner level formula.

by Michael M
Replies
32
Views
403

### 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. ## Thread: Can someone help me with this? Probably a beginner level formula.

by Michael M
Replies
32
Views
403

### 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

Sounds like a SUMPRODUCT would do...
13. ## Thread: help with macro issue

by Michael M
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. ## Thread: help with macro issue

by Michael M
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...

by Michael M
Replies
4
Views
97

### Re: enabling macros

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

by Michael M
Replies
2
Views
65

### 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. ## Thread: Why am I getting an overflow error

by Michael M
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. ## Thread: adding \$ before a number vs selecting currency/accounting format

by Michael M
Replies
2
Views
74

### 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. ## Thread: Need help to do Macro.

by Michael M
Replies
2
Views
123

### Re: Need help to do Macro.

Why not simply use the macro recorder, doing the steps you provided ???

by Michael M
Replies
8
Views
231

### Re: Excel 365 Advanced Filtering

You and me both Mike !!!!!
21. ## Thread: Empty textbox needs text

by Michael M
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. ## Thread: Excel is creating very large files

by Michael M
Replies
9
Views
84

### Re: Excel is creating very large files

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. ## Thread: Excel is creating very large files

by Michael M
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. ## Thread: Evertything seems to paste only in column A

by Michael M
Replies
2
Views
46

### 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. ## Thread: Excel is creating very large files

by Michael M
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