• 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. Eloise T

    How to drag down dates?

    Thank you!
  2. Eloise T

    How to drag down dates?

    How do you highlight and drag down dates (day, month, date, and year) , e.g. see Column A. It doesn't work, but if you highlight and drag down Column D or Column E, it works. How can I do it with Column A? Thank you.
  3. Eloise T

    How to create a macro that clears entries on a worksheet?

    Thank you, Debaser!
  4. Eloise T

    How to create a macro that clears entries on a worksheet?

    When trying to use your example as a template: >>> use code - tags <<< Range("'calculator'![a30:a36]").ClearContents ' Range("'calculator'!a30").ClearContents ' Range("'calculator'!a31").ClearContents ' Range("'calculator'!a32").ClearContents ' Range("'calculator'!a33").ClearContents '...
  5. Eloise T

    How to create a macro that clears entries on a worksheet?

    I need a macro that clears the alphanumerical entries of a worksheet so the user doesn't have to do it manually. Please see the yellow highlighted cells (A-4..A28, A30..A36, A38..A47, A50..E76, F51..F76, and H75) on the attached worksheet. Is there a better way than listing each cell...see...
  6. Eloise T

    Is it possible to create a "Save" macro?

    I have a 20 Mb and growing spreadsheet that takes about 10 minutes to save. I would like a macro that when ran, will simply save the current spreadsheet/workbook and upon completing the "save," will beep or play a tune so that I can visit the lunch room or coffee pot while waiting and listen...
  7. Eloise T

    Macro to find and replace data

    Thank you for your submission, but that doesn't really encompass the desired end result.
  8. Eloise T

    Macro to find and replace data

    p45cal, et. al. The following version written by Marc L, works the fastest; however, it intermittently leaves a string of "zeros" past the data in Columns E and F for about 3200 rows [see picture below]. Sometimes it does it, sometimes not. >>> use code - tags <<< Sub Marc_L() 'Written by...
  9. Eloise T

    Macro to find and replace data

    There is one minor problem with this version. It picks up the "background highlight color" of cell E5 and propagates that across the "matches" as seen below. ...First picture below is cell E5, the next picture shows cells >36,000 rows deep with same background highlight color as cell E5. What...
  10. Eloise T

    Macro to find and replace data

    Please see the attached sanitized spreadsheet. I need a macro that will scan down Column J looking for the word “Canceled” and replace (in the same row) whatever may be in Columns E and F with “N/A” If "N/A" is already there, skip to the next occurrence of "Canceled" until all rows have...
  11. Eloise T

    Why doesn't [Yes to All] work?

    BTW, I did as you suggested: Pastes values into pre-formatted destination cells to adopt their number formatting. I'm guessing that since we got different results with the same files that Excel version / Windows version may be the root of the problem?
  12. Eloise T

    Why doesn't [Yes to All] work?

    I just realized I tried Formatting the entirety of columns (K) in both Demo1 and Demo-2 to "Custom" mm/dd/yyyy then copied a row (E through L) and still got the date in serial number. Any other suggestions?
  13. Eloise T

    Why doesn't [Yes to All] work?

    Paste Special -> Values works except it treats the date as a 5-digit number instead of a proper looking date. e.g. 43329 vs. 08/17/2018. Have any other suggestions? [Yes to All] really should work.
  14. Eloise T

    How to put my Excel spreadsheet on a diet.

    Luke, If I broke any forum rules, I apologize.
  15. Eloise T

    Why doesn't [Yes to All] work?

    I will check that out and report back. Thanks!
  16. Eloise T

    Why doesn't [Yes to All] work?

    YES, it is a VERY good thing I don't have 100! ...and I'm not sure I followed your train of thought on paragraph 2.
  17. Eloise T

    Why doesn't [Yes to All] work?

    By the way, it doesn't matter if you're copying row(s) from Demo-1 to Demo-2 or vice versa.
  18. Eloise T

    How to put my Excel spreadsheet on a diet.

    That's a pretty bold statement for someone who's only been a member 8 days, and weighing in on a question that's over 3 months old. BUT, in case you don't understand "diet" and really care, please re-read Panels #1, #2, and especially the link in #3.
  19. Eloise T

    Why doesn't [Yes to All] work?

    Please see the two attachments, Demo-1 and Demo-2. I have six Name Manager formulas in Demo-1. When I try to copy a single row (Columns E through F) from file Demo-2 to file Demo-1, I see: Note: SearchFor70 If I click either [Yes] OR [Yes to All] I see: Note: SearchFor75, then...
  20. Eloise T

    Why is the macro deleting data that has only numbers, but not if the data contains alpha or special characters?

    Both lines work! Thank you! Why is the 2nd variant your favorite? RE: codeline #21. It's normally False. I changed it to true to help me debug.
  21. Eloise T

    Why is the macro deleting data that has only numbers, but not if the data contains alpha or special characters?

    I have a VBA macro which "cleans" up the data before I process it; however, it cleans up too well in Column D. If the character data in any cell in Columns A-F is all numbers, the macro (CleanUp_9) deletes the data found in that cell. Fortunately, the only column that "may" have all numbers is...
  22. Eloise T

    Converting one column of text into two columns.

    Thanks for your assistance. I'll try that.
  23. Eloise T

    Converting one column of text into two columns.

    I updated with the mod. Here's a sample of real data..see attached:
Back
Top