Search results for query: *

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.

here is the correct statement in a function form.. =SUMPRODUCT(('Data Sheet'!$K$2:$K$500=A2)*('Data Sheet'!$BW$2:$BW$500=1))

thats what people keep telling me, but the file when i use the function is too large. I need something smaller and by doing the vba I eliminate all of the issues concerning size. If I can just get past this step everything else should be very easy. Thanks.

ok. well im having problems communicating what i need. I simply need for my program to stop counting how many times each number in col a repeats itself in col k, and to start counting how many times col a repeats itself in col k and there is a 1 in corresponding cell in col BW

Maybe this will help. I have to match everything by sales reps. On my "sales reps" sheet i have a list of current sales reps, and my "data sheet" is a list of items reviewed by sales rep number. My code i have posted is simply searching my data sheet and counting how many times each sales rep...

I meant if cell in Col A matches Cell in Col K then count corresponding cell in col BW that contains 1's. Thanks