Search results for query: *

Thank you very much for your assistance!!!! You have helped tremendously. I apologize for the delay in responding, I've been tasked with a project that took priority over my normal duties (I'm sure you all can relate....) Again, Thank you very much!!!!!!

Hi John, The Subtotals are already there when the spreadsheet is sent to me. My 'to do' is to consolidate each section (like the Eat at Joe's section above). For example, in the sample given in my first post, I go through and highlight and sum cells E2 (value = 10) through E5 (value = 30). I...

Hi everyone! I have a weekly report of 1,000+ lines that is provided to me to "condense". The report looks as follows: A B C D E Prob# CustName Date Time Duration (minutes) 001 Eat at Joe's 12/01 10:00a 10 001 Eat at Joe's...

Gentlemen, Thank you very much for this valuable information. I sincerely appreciate it! Robert.

Hi all, I have the following sample spreadsheet. A B C 1 Apple 2 3 Apple 2 5 Orange 2 I am looking for a formulas that would give me the average and count of ONLY the VISIBLE rows. For example, I would expect an average of 2 and a count of 3. (Notice...

Thank you two very much for your time. It's working! I sincerely appreciate your efforts. Robert. (I thought there was a place for me to flag this as a very hepful tip. Perhaps stars or something. I'm unable to find a place to flag this post. Either way, thank you two very much!)

Hi SkipVought, Thank you very much for your suggestion. I believe that this will work. I've been playing with it and I believe I need only one more tip. What is the syntax for selecting individual cells? For example: In the sample below, how would I write the formula you suggested...

Hi! I have the following sample data in a spreadsheet: A B C Sue Yes Yes Yes Ann No No No Joe X X X Bob X X X Kay Yes Yes Yes I'm trying to figure out a formula that will give me the total number of people...

Hi! I currently have a 400+ line report similar to this: Jan Feb Mar Emp A X X X Emp B A X A Emp C X X X I'm looking for a formula that will count all rows that have an "X" all the way across (B2, C2 & D2). I was going...

Anne, Success!!!!! I went in to My Computer and set it to show hidden files but unfortunately it still did not find the personal.xls file. Then I decided to go back and do one final search and found the 'Advanced' search button. In there I also checked 'find hidden files' and wham! It found...

Anne, Thanks again for such a quick response! When I try to record a new macro, I get the following message: "Personal Macro Workbook in the Startup folder must stay open for recording." One interesting thing is that I CAN create a macro for an individual Workbook. Unfortunately...

Anne, Thank you so much for your prompt response to my post. I did a search for personal.xls and sure enough it was not found. I take it that this file is where all macros are stored. My question now is do I just place an empty notepad document in there and name it personal.xls? Also...

Team, For some reason I have lost all of the macros that I built and saved in my Personal Workbook. When I try to go back and rebuild a macro, I get the following message: "Personal Macro Workbook in the Startup folder must stay open for recording." Has anyone seen anything...

VBAjedi, Item #1 above worked perfectly! With Item #2, when I run the macro it just seems to hang. I get the hourglass, and the first few conditions work properly, but it seems as if when it gets to the first Value that I want to exclude it just hangs. This goes on for several minutes and I...

VBAjedi, Thank you so much for your input. I've spent the better part of this morning studying it. I was able to run the macro with your code and it worked. I do have two more questions as I begin to tailor the code to my actual report. 1) When it highlights a row, the entire row is...

Hi Skip, You're correct, I didn't state in my initial post that I have multiple conditions. I'm a novice at best when it comes to using Excel and am desperately searching for a way to minimize errors and time spent while pulling this daily report. I'm thinking if I can atleast get the...

Hello dyarwood, Thanks for your assistance. I placed the code above in a MVB window but when I try to run the macro I get an error that reads: "Compile error: Loop without Do" Can you see where I'm going wrong? Also, what I planned on doing with this is getting the basic syntax...

How do I create a Macro to go through a report similar to the one below that will highlight any row where the "Response time" exceeds 3 minutes? I don't want to use Conditional formatting as it limits me to 3 conditions. Receive Customer Response time 10:00 INR...

Skip, Thank you very much for your input. It has helped me a lot. I was able to use the same concept and apply it to my report. The problem I'm running into is that it appears that each cell can only have a maximum of 3 conditions. And if any of the three conditions is true, the other two...

Hello everyone, I pull a daily report that is similar to this: Receive Customer Response time 10:00 INR 5.0 10:15 INR 6.5 10:30 Cust 3.0 10:45 Cust 3.5 11:00 SRV...