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...
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...
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...
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...
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...
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.
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...
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! :)
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...
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...
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??
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??
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??
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...
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...