• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Locate rows that don't match others in group

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

    Locate rows that don't match others in group

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

    Macro to Copy data for specific date from different worksheet but from same workbook

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

    Macro to Copy data for specific date from different worksheet but from same workbook

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

    Need a help on filling the timesheet

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

    Wants to mail on different ID attachments from a folder through Outlook

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

    Need a help on filling the timesheet

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

    Need a help on filling the timesheet

    Combine the formula with an IF statement.
  9. D

    Return value assoc. with known?

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

    Need a help on filling the timesheet

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

    I need help creating a macro or pivot table.

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

    Grouping code Maj_Rock

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

    How Send email from yahoo (error 424)

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

    VBA Exercise

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

    VBA Assistance Required

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

    Help With Copy Data Code for Existing and New Records

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

    Move a sheet from closed workbook (almost 90%)

    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 =...
  18. D

    Error 1004 Select method of Range class failed

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

    Error 1004 Select method of Range class failed

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

    Error 1004 Select method of Range class failed

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

    Error 1004 Select method of Range class failed

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

    Count unique values in filtered pivot table

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

    Count unique values in filtered pivot table

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

    Copy data from one workbook to an existing workbook in folder

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

    Error 1004 Select method of Range class failed

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