Search results

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

Hope this helps. Sub InvoiceCopy() Dim val As Variant Dim lMaxRows As Long Dim blnReplace As Boolean Dim i As Long 'GET VALUE TO SEARCH FOR Sheets("Invoice").Select val = Sheets("Invoice").Range("M1").Value 'SEARCH FOR VALUE Sheets("Bill").Select...

Hope this helps. Public Sub ImportSheet() Dim sImportFile As String, sFile As String Dim sThisBk As Workbook, wbBk As Workbook Dim wsSht As Worksheet Dim vfilename As Variant Application.ScreenUpdating = False Application.DisplayAlerts = False Set sThisBk = ActiveWorkbook sImportFile =...

That didn't work. :-( Thanks for the suggestion though! I've about decided to give up for now. I think if my users encounter these errors they'll just have to have the system generate a new file rather than trying to update an existing file. This happens with very small batches of files as...

Yes, and the error is generated from Excel. I actually have to switch windows to Excel, handle the error dialog -- which only has the option to End btw -- and then go back to Access.

Narayan, here's what I got when I tested. No, swapping the lines doesn't impact the outcome. I truly think it's the spreadsheet itself with some issues. Since it's protected (even the code is) I can't dig too much deeper into the workbook itself. ?oWS.Range("C4").Value 4/24/2015...

Narayan, I will try that and let you know. I'm back in the office today so I'm going to take another look at it. Ken, thanks for the suggestion but that won't work. The workbook has various cells on 2-3 worksheets that need updating. In the sample I provided, I happen to be populating two...

Nebu, yes the formula needed to be dynamic. Your formula's logic was right but I needed a formula to dynamically count the unique tornadoes after filtering. Sorry I was unable to articulate that better in my original and previous posts. I was able to solve my problem by using a solution from...

It is 118. Some of the records that should be included in the total are getting excluded because of the formula and I can't figure out how to stop that. example: in 1977, the formula has a 1 for Logan county and a 0 for Oklahoma county. The 0 is because that record is a duplicate. Index |...

I actually just finished something similar, but I was copying out to a new workbook for each rep. Here's some of the code I used to make that work. With some manipulation, you can have it locate the file. Hopefully you have the date portion that would be different each month located somewhere...

I have an Access database with code that opens an Excel file and then updates information in it. I am getting the error 1004 when I try to put data into some of the cells. I know that the code has the correct worksheet referenced because I am able to get one cell to work, and then the...