Recent content by dianacris

Thanks for the reply! I need to find out which clients have more than one unique expiry date. The pivot table shows all clients and their expiry dates, but I just want those that have 2+ unique expiry dates and I can't figure out how to be able to filter for them.

The solution here is probably easy but I just cannot determine how to approach this. I have information by client that includes dates. Each client will have 1-5 rows of data. Each row includes a date. If the client has 3 rows and all 3 dates are the same, I can skip them. I need to...

You can use the email code you included in your second post, but you just take out the ".Attachments.Add Filepath" because you don't want the file attached. What you are trying to build is the ".body = msg" portion. First, take all of the outlook code and put it in its own procedure. I'm...

Question: do you want the email to attach a file with the desired data, or insert it into the body of the message? Your file gives the impression you want the data in the email body, not an attachment.

Thought about this while at lunch (and while in a meeting). Came back to it and was able to get the formula to work at the bottom of column AC. How do you want that single column to look? I added a possible result in col AH. I tested changing the event times to see if it continued to work as...

There are many code samples out there for looping through files in a folder, or specifically for Excel files in a folder. Here's one example: http://stackoverflow.com/questions/5851531/code-for-looping-through-all-excel-files-in-a-specified-folder-and-pulling-data Once you have that loop...

I'm not sure how to get it all combined into a single column. Now that you have the formulas for the four events, you need to test and determine whether the time in col P is equal to the start time or is between the start/end time. You would have to do that for the event 1, and if it's false...

Combine the formula with an IF statement.

I was going to suggest a vlookup but Narayan's formula is probably more precise.

You just need some formulas that will update automatically. See if the attached is what you're looking for. I had to add two cells with dates to make the formula easier.

Couple of considerations .... Will the new lines be at the bottom? Or mixed within? What do you want to do to the "new" lines of data? Is your data in both sheets sorted the same? Does your data have a single value (a key value) that you can/will compare in order to find the "new" lines? I...

Good thing you attached a file because your description of your problem was less than clear. After reviewing your attachment, I'm not sure how you'd group and get the result you're looking for. Can you output a "final" table with the desired result like what you have in B37:F37? If you can...

You changed the name of your object -- you are using NewMail and then on that line with the error (as well as the one after it) you are using MyMail. Make all the names the same and hopefully it will work.

Would love to help but don't understand your issue. I suspect that is one reason no one has assisted yet. I don't get what you mean by Are you wanting to use the date in column A, find the corresponding date in column H, and then copy that information (cols H-N) to cols B-F? However, if the...

I've never done anything like this but here's my two cents .... The first problem I can think of is whether the slave files' passwords can be modified by the employees. If so, it would be difficult for any code to pass the correct password if the passwords could change. I believe that when...