Recent content by cbanks

Im filtering a selection and I want to insert a msg box to allow the user to work on the spreadsheet once the msg box pops up. Therefore they can make changes then click ok to let the macro continue. How would i do that? Right now its not allowing me to edit. Thanks. Dim lRow5 As Long...

Here is what I need. Now how do I write this in VBA? =SUMIF(Z2:Z5000,A2,AA2:AA5000)

I would need it to look like this so to speak, but of course this is not working right. I have something in it wrong. With Range("L2:L5000") sumL = 0 'assuming the row range is 2 to 5000 For r = 2 To 5000 If Cells(Worksheets("Sales Reps")(r, 1)).Value = Cells(Worksheets("Data Sheet")(r...

Thanks, the rows are on different sheets. How should i reference those?

Here is what I am using... With Range("H2:H5000") .FormulaR1C1 = "=SUMPRODUCT(('Data Sheet'!R2C11:R5000C11=RC1)*('Data Sheet'!R2C81:R5000C81=""G - Prior policy incident handling errors""))" .Copy .PasteSpecial Paste:=xlPasteValues End With Ok, here is where it gets tricky...

Yes i corrected that but my sales reps end at 600 today and i have it set to 5000 keeps filling all the way to 5000. Also for the second search i get a return of NAME. Why is that? Can you tell me how to make it search for just a capital A and not the whole explanation after it. With...

this works. but it counts all blanks.. With Range("D2:D5000") .FormulaR1C1 = "=SUMPRODUCT(('Data Sheet'!R2C11:R5000C1=RC1)*('Data Sheet'!R2C75:R5000C75=1))" .Copy .PasteSpecial Paste:=xlPasteValues End With

yes, but my sales reps can change every month/week. New ones are added and deleted constantly.

Sorry I can not

Yes it loops through.

Im clueless. I dont understand

OK. Im using the formual, but I need help. Col CC contains "C - Long Explanation" but when I make my formula look like this it does not count. Can it just count those that begin with C or contain the entire "C - Long Explanation"? Thanks =SUMPRODUCT(('Data Sheet'!$K$2:$K$55000=A2)*('Data...

Just lost me

Its just a large file that takes a terribly long time to calculate. is there no way to do this in vba?

around 600 reps, and around 50000 rows on the data sheet i have have around 15 cols on the reps sheet that all with be very similar to the problem i have asked for help on. Basical if the reps match i have a ton of 15 questions to answer. Which gives me my 15 cols.