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

    Help with COUNTIFs or Pivot Table with input Date filter

    Hi all! This forum has helped me tremendously in the past!... and now, I am back! :) so here is the file: Fields1 through Fields34 are across the top row. Fields1-Field10 are basic header labels (country, state, county) Fields11-Field34 are the data fields which have a bunch of dates under...
  2. T

    Quick Edit Question: How to modify this code after splitting the original column

    Hi SirJB7!...thank you! I thought I would have to add the XLWhole but I couldnt figure out where to add it! but if I modify the "rangeC:C" line, would that solve for the "Item"s that is searching for below the Date? the DAte search has been working great, the issue is when i search for the...
  3. T

    Quick Edit Question: How to modify this code after splitting the original column

    Hello! Can someone please help me with one slight modification? So the wonderful code, that Luke created above, finds a specific text and inserts a new row underneath with the User Prompted data. Issue comes up when there are multiple fields (to search for) that have the first few...
  4. T

    Quick Edit Question: How to modify this code after splitting the original column

    oh,i figured it out! :).... but I do have another question... how I get the newly inserted rows to copy the formatting from the row above?
  5. T

    Quick Edit Question: How to modify this code after splitting the original column

    Luke!... another question.... how can I edit this line: Cells(newRow, "B").Formula = Cells(newRow - 1, "B").Formula so that the "formula" gets copied down with the relative cell change. If the row 4, cell above is Sum(E4:AC4)... the new row's formula in B should be Sum(E5:AC5)...right now...
  6. T

    Quick Edit Question: How to modify this code after splitting the original column

    I really do not know how to thank you!! .. "THANK YOU!!! Please know that you just helped me keep my job!!
  7. T

    Quick Edit Question: How to modify this code after splitting the original column

    Hi luke! I really feel bad bugging you.... but you are so very helpful! Your original code was not rushed, it worked perfectly. I think I did not explain it properly, I am sorry. yes, the goal is to (1st step) find the Start Date AND Specific Item THEN Insert New Item. This is to find the...
  8. T

    Quick Edit Question: How to modify this code after splitting the original column

    Thank you, Luke M...AGAIN!.. You are awesome! The new macro works great but how do i modify it so that it keeps adding the new Item? I executed the code, it found the Start Date, added the NewItem (but only once) it didnt continue to add for all dates forward.
  9. T

    Quick Edit Question: How to modify this code after splitting the original column

    Hi! So this code below, works awesomely- thanks to Excel Ninja! - but I now i have modified the data table so all the columns are screwed up! BEFORE: ALL IN COLUMN B: Date Item1 Item2 Item3 NextDate Item1 Item2 Item3 Goal was to find a specific Date, then find a specific Item under...
  10. T

    Need help in streamlining macros and speeding up macro enabled template

    Thank you Narayan! I believe you confirmed what I have been suspecting- its my laptop. I cannot edit and save a single character within the file without it slowing down. Thank you for looking into it for me! :)
  11. T

    Need help in streamlining macros and speeding up macro enabled template

    Here is the DB Link: https://www.dropbox.com/sh/4pjr72k3zp6o9b4/xiFpElDb4U Thank you for the help!!!
  12. T

    Need help in streamlining macros and speeding up macro enabled template

    Thank you, I will post a DropBox Link :)
  13. T

    Need help in streamlining macros and speeding up macro enabled template

    hi! Is there a way that I can attach my file to my post? Or can I email it to someone? i have created a macro enabled workbook that is sooooo slow when I edit VBA and change! and I have only done the first tab with 400 row. I will be creating the same tab six times with 55000 rows on each tab...
  14. T

    excel 2010 freezing- not responding with macro

    Thank you Chandoo! I appreciate all of your input! You just saved me $2K in buying a new PC!
  15. T

    Excel Ghosting Out

    hi Muneer, it is not a problem with a specific file. It happens across any of my files that I am creating and updating and saving macros in. When I make an Edit in VBA and hit save, Excel does "Not Reponding" and whites out then after while starts working again. Same thing happens when i...
  16. T

    Excel Ghosting Out

    hello, i just wanted to see if anyone had a workaround for Excel freezing/ghosting out/shutting down/not responding when working with macros? i currently use a Dell inspiron 1764 with CPU i5 8 GB of Ram Windows 7 64-bit OS. Is it my computer issue or Excel issue??
  17. T

    excel 2010 freezing- not responding with macro

    hello, i just wanted to see if anyone had a workaround for Excel freezing/ghosting out/shutting down/not responding when working with macros? i currently use a Dell inspiron 1764 with CPU i5 8 GB of Ram Windows 7 64-bit OS. Is it my computer issue or Excel issue??
  18. T

    need to create a macro to find a txt and insert and Prompt user for Text

    You are awesome!!! If I could hug you....i would! :)
  19. T

    need to create a macro to find a txt and insert and Prompt user for Text

    oh and the "day 2" or starting point to find is in column A
  20. T

    need to create a macro to find a txt and insert and Prompt user for Text

    sorry to be a pain! I appreciate all of your help! :) If its not too much trouble, could we please modify the code to say find "DAy 2" and start from that point forward??
  21. T

    need to create a macro to find a txt and insert and Prompt user for Text

    amazing! Thank you for your input! One more add on- if there is of repetitive IDS that are in Daily sections. Day1 123 456 789 10 Day2 123 456 789 10 Currently the macro find all instances of (say for ex: 456) and inserts New Term so it looks like this: Day1 123 456 New Term...
  22. T

    need to create a macro to find a txt and insert and Prompt user for Text

    Hello. I am trying to write a macro that will search down column B, find a User Prompted Term, insert a blank row beneath it and continue this for all instances. I have managed to get this to work with the macro below. HELP: What I am trying to achieve on my next step is to have the User...
Back
Top