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

Auto Delete Rows

Hi, nnavarro!


There is the crux of the matter, as my older relatives used to say.

You can't use tables with this method. BTW, what do you need them for?


Try to do this:


1) keeping the workbook with your actual data

a) open it

b) open my file

c) copy sheet 'Data Dump New' to your workbook

d) copy actual data from the original source

e) paste actual data into new sheet copied

f) test process clicking on mouse button


or


2) using my uploaded workbook

a) open it

b) open the workbook with your actual data

c) copy actual data from the original source

d) paste actual data into sheet 'Data Dump New'

e) test process clicking on mouse button


If none works, well... what about taking a sabbatical week, go fishing to a quiet and lost river and forget all this? :)


Otherwise you'll have to do one of two things:

- convince me about your insistence in using tables (here, not everywhere, where I use them too)

- preparing a couple of 21 years old Johnnie Walker Blue Label (I'd say one, just for me, but I guess that Chandoo, b(ut)ob(ut)hc and Montrey would be trying to hunt me if I don't use the floo network to share it with them...)


Just a joke, see this topic:

http://chandoo.org/forums/topic/chandoo-please-clarify


Regards!


PS: Just a joke the second bottle only, ha ha ha...
 
Hi SirJB7,


You guys are so funny:) Using tables is out the door. It was the opposite you convinced of my wrong table doings. Earlier you answered one of my questions regarding copying formulas to the rows below (Appreciate). So I thought screw this stupid table and use SirJB7’s macro. I copied it and modified it but it is not working. Can you help a brother out? I think that this will accomplish what I am trying to do.

Also how do you move the macro bottom from the data dump to the input data tab.

Thanks,


https://dl.dropbox.com/u/90166573/Auto%20Delete%20Rows%20-%20One%20More%20Try.xlsm


NN
 
Hi SirJB7,


You guys are so funny:) Using tables is out the door. It was the opposite you convinced of my wrong table doings. Earlier you answered one of my questions regarding copying formulas to the rows below (Appreciate). So I thought screw this stupid table and use SirJB7’s macro. I copied it and modified it but it is not working. Can you help a brother out? I think that this will accomplish what I am trying to do.

Also how do you move the macro bottom from the data dump to the input data tab.

Thanks,


https://dl.dropbox.com/u/90166573/Auto%20Delete%20Rows%20-%20One%20More%20Try.xlsm


NN
 
Hi, nnavarro!


I think you only missed defining the code for the macro button control's click event:

-----

[pre]
Code:
Private Sub cmdMacro_Click()
DeleteRowsUponCriteria_Filter
End Sub
[/pre]
-----


You can manually add these lines to the worksheet 'Data Dump New' code area (Alt-F11) or from the sheet, Programmer tab, Controls group, Design Mode icon, then right click on command button, View Code, and you'll be prompted with the 'Private Sub... End Sub' where you should overtype the blank line with the name of the procedure called.


BTW, the file you uploaded weights 27Mb, it's a lot, and even if I deleted the hidden sheet 'Data Dump New Backup' (unnecessary) it was 25Mb: the problem is with sheet 'Invalid Data', so deleting blank rows and blank columns, it went down to 51Kb.


I uploaded this version:

https://dl.dropbox.com/u/60558749/Auto%20Delete%20Rows%20-%20One%20More%20Try%20%28for%20nnavarro%20at%20chandoo.org%29.xlsm


Hope it works, amigo!


Saludos!
 
Buenas Noches SirJB7,


Are you getting tired of me already? Sorry to keep bothering you :). The macro to copy the formulas is not working. Did I do something wrong? I would like for the data dump tab to copy the formulas down for columns A,J,K,l,M,N. So if I enter information in row 3,4,5,6,7,9 it automatically copies all the formulas in columns A,J,K,l,M,N from the original/first row. I copied this from a prior response and made some changes. Also how do I move button control to the tab input data in row D4

[pre]
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
' constants
Const ksTriggerRange = "B,C,D,E,F,G,H,I"
Const ksFormulaRange = "A,J,K,L,M,N,"
Const kiFirstFormula = 2
Const kiWitnessColumn = 1
' declarations
Dim I As Long, J As Long, K As Long, A As String, bOk As Boolean
Dim rng As Range, lCalculationMode As Long
Dim sTriggerArray() As String, sFormulaArray() As String
' start
Application.EnableEvents = False
lCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
'  arrays
ReDim sTriggerArray(Len(ksTriggerRange) - Len(Replace(ksTriggerRange, ",", "")))
ReDim sFormulaArray(Len(ksFormulaRange) - Len(Replace(ksFormulaRange, ",", "")))
'  trigger
I = 0
For J = 1 To UBound(sTriggerArray)
K = InStr(I + 1, ksTriggerRange, ",")
A = Mid$(ksTriggerRange, I + 1, K - I - 1)
I = K
sTriggerArray(J) = A
Next J
'  formula
I = 0
For J = 1 To UBound(sFormulaArray)
K = InStr(I + 1, ksFormulaRange, ",")
A = Mid$(ksFormulaRange, I + 1, K - I - 1)
I = K
sFormulaArray(J) = A
Next J
'  ranges
bOk = False
For I = 1 To UBound(sTriggerArray)
Set rng = Application.Intersect(Target, _
Range(sTriggerArray(I) & ":" & sTriggerArray(I)))
If Not (rng Is Nothing) Then
bOk = True
Exit For
End If
Next I
If Not bOk Then Exit Sub
' process
With Target
For I = 1 To .Rows.Count
For J = 1 To UBound(sFormulaArray)
A = sFormulaArray(J) & ":" & sFormulaArray(J)
K = .Row + I - 1
If ActiveSheet.Cells(K, kiWitnessColumn).Value <> "" Then
If K <> kiFirstFormula Then
ActiveSheet.Cells(kiFirstFormula, Range(A).Column).Copy _
ActiveSheet.Cells(K, Range(A).Column)
End If
End If
Next J
Next I
End With
' end
Application.EnableEvents = True
Application.Calculation = lCalculationMode
End Sub
[/pre]

I am so sorry I keep asking but I am trying to learn it.


Saludos,


Su amigo NNAVARRO


https://dl.dropbox.com/u/90166573/Auto%20Delete%20Rows%20-%20One%20More%20Try%20%28for%20nnavarro%20at%20chandoo.org%29.xlsm


EDITED by SirJB7, just for indenting purposes only.
 
Hi, nnavarro!


Don't say such a thing, man... at least not today, tomorrow who knows :=)


As I wrote at your previous post bottom I edited the code for indenting purposes only. You can post indented text embedding it within backticks.


When I read a new entry at this topic I screamed "what in the earth might have happened now with the ranges, tables, list objects and Co.?", but when I saw that it was another issue I breathed quietly and colors came back to my face.


Now seriously, the problem is with constant kiWitnessColumn.

As you might have seen the whole process should be executed each time you modify a cell in columns of ksTriggerRange, copying cells (which are supposed to contain formulas) specified at ksFormulaRange. It starts with a un-updatable row for original formulas (kiFirstFormula, which has a value of 2: source is then row 2).

But that wasn't efficient at all since it copied multiple times formulas in same row: each time you edit/input a cell in ksTriggerRange.

So then it appeared the trick: while you input data copy process is filtered by checking if a particular column is empty or not: kiWitnessColumn, i.e., the last column inputted after which can formulas be copied.


We're ok till now? In my very first example it was set to 1 (column A) -wrongly- but as it copied all the other cell formulas I (should say we?) didn't notice it. Now that the deleting rows issue is finished (it's finished, isn't it? and if not I'm closing my eyes and won't read... joke), it arises but it should have appeared from the first time.


Solution: change it to 3 (column C) or to any other column that will always be entered and after which formulas can be copied, that's to say, the last or main column that's used for formula calculations.


I apologize for the error, but I didn't catch it before.


Now change it, try it and tell me please... but take care of my heart health, please.


Regards!
 
SirJB7,


Thank you so much! It works great and I don’t have any more changes. Yehhhhh!!!!! I am amazed on how you combined the two macros and made worked. The auto copy formula macro is a great addition and it works better than a table. It is like magic you paste or enter your information and magically populates all the formulas. You don’t know how but you appreciate this being done automatically.

This workbook is so polished and this would have never been achieved without you. I hope that other readers find this posting. If they do, they are going to love it and find it very helpful.


Muchas Gracias,


NN
 
Hi, nnavarro!

Glad you could solve it at last. Thanks very much for your feedback and for your kind words too, maybe a little exaggerated. You know you're always welcome here (well, except for modifications about auto delete rows's topic, of course). And got my mail too, so...

Buena suerte y hasta la vista!
 
SirJB7,


Well, I am breaking the rule with the auto delete rows file. Just one more favor. I want to move the the macro buttom but I just can't figure out. Can you help me with that or give me instructions on how to do it?


Thanks,


NN
 
Hi, nnavarro!


You frightened me once more... But this is easy.

You can place 2 kind of command buttons in Excel:

a) Form controls (top half of Programmer tab, Controls group, Insert icon)

b) ActiveX controls (low half)


First one is a shape (you can add a different shape too), to which you assign a macro. And control name and macro name may be totally different. Second one is an object which has more flexibility assigning properties and viewing code. Code is always set as ControlName_Click, as it's triggered by the control click event.


First one can be moved with right button and selecting/dragging. Second one requires entering into design mode (Programmer, Controls, Design Mode) and then selecting and moving normally until exiting design mode.


Regards!
 
Hi SirJB7,


I moved the button but when I did so I lost the functionality. The macro seems to be runing in current tab "Input" as opposed to the original "data dump"


I was also wondering if you could help me with my formula in column n. I am getting an #NA error, I tried fixing it by adding IFerror and ISerror but it didn't work.


I hope that you can help me with this two items.


https://dl.dropbox.com/u/90166573/Banded%20Rate%207-20%20Original%202.xlsm
 
Hi, nnavarro!


Looks who's here again... so long...


Summary review:

a) button move

- error, created a form control command button (top part of insert menu) and not an ActiveX command button (lower part): next time select control, Ctrl-X, Ctrl-V, then rename, that ensures same object and behavior

- calling code, ergo idem

- code was prepared for deleting rows in active sheet, so when moving button, activating/deactivating of data sheet was needed

b) cell K2, !#N/A error: missing entry for my cousin's Pay Frequency, added with dummy data

c) cell N4, !#N/A error: missing value in J4 for entry in Band Info, added ENG02 as test


Link to file:

https://dl.dropbox.com/u/60558749/Auto%20Delete%20Rows%20-%20Banded%20Rate%207-20%20Original%202%20%28for%20nnavarro%20at%20chandoo.org%29.xlsm


You know the routine, just follow the yellow line :)


Regards!
 
Hi SirJB7,


Thanks for the change and the instructions, it was very helpful. I got a question for you regarding a freak of nature. For some weird reason when I run the macro I get an error on a formula that is working well at first. I only get an error on the last part of the formula for the weekly part. It changes it from J to ref error. I attached the file with dummy data. All you need to do is run the macro and you will see what I mean. Can you please please help me with this error.


Thanks in advance.


NN


https://dl.dropbox.com/u/90166573/Banded%20Rate%207-21.xlsm
 
Hi, nnavarro!


I'm afraid I couldn't reproduce you issue as I'm unable to find the dummy data.


Just three comments:

- file is empty of data, but it weights 63Mb vs the 388Kb of mine uploaded, do you remember what processes have you done on it?

- if I run the macro on the heavy file with no data, it doesn't shows the related error, but it ends with an "not enough resources to complete tha task"

- when I delete all contents of hidden sheet 'Invalid data' workbook size shrinks to 64KB, so... if you don't need to keep deleted data, then why not leaving blank cell B2 in sheet Parameters and don't use that sheet? (it was a feature asked by the guy who original posted in the topic from which we took this path, but not you...)


Could you please upload it again with data to test it and decide about file size? Thanks.


Regards!
 
<p> Karen Millen Floral Print Pencil Dress White/Purple</p>



<p> The Google Adsense plan compensates the affiliate in a pay-per-click basis. The advertisers would pay Google a certain quantity every time their advertisement on your web site is clicked and Google would then ahead this amount for you through checks, despite the fact that only soon after Google have deducted their share from the quantity. Google Adsense checks are usually sent month to month. Also, the Google Adsense plan offers website owners using a monitoring instrument that allows you to monitor the earnings you in fact get from the specific advert.</p>


<p> </p>


<p>The far more you comprehend about any subject, the more interesting it gets to be. While you go through this article you will <span style="color: #ff6600">Karen Millen Dress</span>
come across which the topic of Google Adsense Profits Mixed In With Affiliate Marketing and advertising is undoubtedly no exception.</p>


<p> Where else but to earnings, profits as well as much more earnings! Affiliate advertising and marketing plans as well as the Google Adsense program merely function, no matter whether you might be the merchant or perhaps the affiliate. For the merchant's aspect, a whole lot of income might be saved if marketing work is concentrated on affiliate advertising instead of on coping with advertising firms. For your webmaster, you can very easily gain a whole lot of profits simply by carrying out whatever you do best, and which is by creating internet sites. And if you combine all your profits from each the Google Adsense system and other affiliate marketing programs, it will certainly convert to a large quantity of money.</p>


<p> Why Affiliate Advertising and marketing</p>


<p> It is possible to see that there is functional worth in learning Google Adsense Earnings Mixed In With Affiliate Marketing. Can you think of approaches to apply what is been covered so far</p>


<p>Karen Millen Folded Satin Pencil Dress Fuchsiasale provide much more range than actually before. most effective Prom Gowns, most effective Evening Dresses, short celebration Dresses, Cocktail Dresses, as well as dimension Dresses, short red-colored Dresses, and dark apparel and consists of a great offer much more in store for you.</p>


<p> </p>

<p> Google Adsense is actually some sort of an affiliate marketing plan. In Google Adsense, Google act because the intermediary between the affiliates and the retailers. The merchant, or perhaps the advertiser, would simply signal up with Google and give the latter with text ads pertaining to their merchandise. These ads, which can be in fact a link to the advertiser's website, would then appear on Google searches in addition to on the internet sites owned by the affiliates, or by individuals website owners that have signed up with all the Google Adsense program.</p>

<p> Karen Millen Orchid Corsage Fitted Dress Red perfect for that newest bride with an eyesight for style.If you're a discerning bride, your gown should really develop to arrive to be just as one of the type and particular if you are. Karen Millen Orchid Corsage Fitted Dress Red</p>


<p>So, exactly where do all of those lead us to</p>


<p> Affiliate advertising, merely stated, is a partnership Karen Millen Dresses or agreement created among two internet sites, with one particular site becoming the merchant's web site along with the other becoming the affiliate's web site. In the connection, the affiliate agrees to allow the merchant promote his merchandise around the affiliate's internet site. The merchant, on the other hand, would concur to spend the affiliate in whatever technique they've agreed into. This would normally mean straightforward income for your affiliate, as he would do nothing at all but spot the retailer's ad on his web site. This would also be quite beneficial for the merchant, as getting affiliates to advertise their items will be a lot more inexpensive than employing an marketing firm to promote their merchandise.</p>


<p>We are not limited to this only in lieu every twelve weeks we arrive up with new types of attire with numerous patterns and mode. Its numerous types of customized collection, Ball gowns, Karen Millen Orchid Corsage Fitted Dress Red has made it probably the most useful place for just about any lady to explore them.</p>


<p> What about Google Adsense</p>


<p> Nicely, merely because affiliate advertising is the easiest and almost certainly the very best method to generate earnings on the internet, unless or else you are a businessman and would relatively promote your own goods on the internet than advertise other businessman's merchandise in your website. But even on-line merchants can advantage from affiliate marketing and advertising plans, because affiliate marketing in fact functions for retailers and also it functions for your affiliates.</p>

<p> Getting much revenue on affiliate marketing applications, nevertheless, doesn't rely so considerably around the compensation technique is it does around the traffic aren-millen-outlets.co.uk/"><span style="color: #ff6600">Karen Millen Dresses uk</span> created by your website. A site that can attract a lot more guests would typically have the greater chance of profiting in affiliate marketing programs.</p>

<p><br class="Clear" />

</p>


<p>You'll find a number of strategies on how the merchant would compensate the affiliate for his solutions, and for your webmaster, these approaches basically translates for the strategy by which he would make straightforward money. Among the a lot more frequent methods of compensation will be the pay-per-click strategy, the pay-per-lead approach, and the pay-per-sale strategy. The pay-per-click technique will be the strategy most favored by affiliates, for their site's visitor would only must check out the advertiser's site for them to gain income. Another two strategies, however, are better preferred by retailers, as they would only need to compensate you if your visitor gets a single of their registrants or if the visitor would in fact acquire their items.</p>


<p>Karen Millen Colour Block Dress BlackWhite</p>


<p> </p>


<p> Are you currently a webmaster who needs funds to help keep your internet site running Or is your site the only real way to suit your needs to make income Whichever you're, for so long as you're a webmaster or perhaps a web publisher and you need cash, affiliate advertising and marketing may work well for you personally. With affiliate marketing and advertising, you might get a good deal of cash pouring into your financial institution account simply. And if your web site is wealthy in excellent contents and you would like to make far more profit, why don't you get into the Google Adsense program too</p>


<p> It by no means hurts <span style="color: #ff6600">Karen Millen Dresses</span> to become well-informed with the most current on Google Adsense Earnings Blended In With Affiliate Advertising and marketing. Examine what you have realized right here to future content articles in order that you can remain notify to adjustments in the location of Google Adsense Profits Mixed In With Affiliate.</p>


<p> sale on www.karen-millen-outlets.co.uk</p>


<div class="BlockContent">

<ul class="ProductList">

<li style="height: 310px">

<div class="ProductImage"><img title=" Karen Millen Outlet Sixties Shift Dress Black/RED " alt="Karen Millen Outlet Sixties Shift Dress Black/RED" src="http://www.karen-millen-outlets.co.uk/bmz_cache/e/ea2f9e41a8458a5040f8338196daa53f.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen Outlet Sixties Shift Dress Black/RED
<em style="height: 18px"><span class="normalprice">£172.79 </span> <span class="productSpecialPrice">£81.61</span></div>

<div class="ProductActionAdd">Choose Options</div>

<li style="height: 310px">

<div class="ProductImage"><img title=" Karen Millen Outlet Silk Rose Print Dress Multicolour " alt="Karen Millen Outlet Silk Rose Print Dress Multicolour" src="http://www.karen-millen-outlets.co.uk/bmz_cache/b/be8dfe4869273e4a33e68fde7d29be7e.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen Outlet Silk Rose Print Dress Multicolour<em style="height: 18px"><span class="normalprice">£172.79 </span> <span class="productSpecialPrice">£81.61</span></div>

<div class="ProductActionAdd">Choose Options</div>

</div>


<p> Whilst one particular can locate a good deal of similarities between Google Adsense and other affiliate marketing and advertising plans, you can also see a whole lot of distinctions. In Google Adsense, each of the webmaster has to perform is place a code on his web site Karen Millen Dresses and Google requires care in the rest. The ads that Google would place in your site would generally be related towards the content material of one's internet site. This would be beneficial each for you and for the advertiser, because the visitors of one's web site would far more or less be truly intrigued with the items getting marketed.</p>


Related articles:

 
<p> </p>



<p>101, 39 strokes successful communication <span style="color: #ff6600">karen millen dress</span> of the essentials to success and methods of thirteen successful karen miller motto Chengjiubaye priceless rules to change the habit of karen millen outlet life wonderful life of 75 to 50 life sentences in the classical karen millen sale the most touching statement lives of 88 people ten useless</p>


<p>spiritual growth classic statement karen millen sale</p>


<p>Famous poem famous famous <span style="color: #ff6600">karen millen sale</span>
spiritual retreats to inspire the 20 habits of famous sayings karen millen famous 110 youth</p>


<p>strokes, so that you are happy every karen millen day of the auspicious zodiac stranger items you 18 pieces karen millen dresses of advice detours life sentence must be read karen miller 25 180 words karen millen dress of philosophical insights are nine things in life you avoid karen miller the ten life</p>


<p>101 interview karen millen dresses skills, recruit 15 young must know something (bilingual) karen millen dress Life Proverbs Shakespeare classic set of insights on life karen millen dresses karen miller 181 famous classical life over one hundred quotations from karen millen outlet ancient Chinese classic famous</p>


<p> The reason I ask is that I am considering getting an AmStaff or an Employees Bull Terrier. My wife and I at present personal a Dalmatian, even so, so I'm a bit involved concerning the two obtaining along, specially when I'm not around. Must I remain away from these breeds I have had one breeder tell me they needs to be great when the Workers is released like a pup, whilst one more told me in no way to leave them collectively on your own. What will be your suggestion (I comprehend all canines are people and may possess distinct features than other individuals of the exact same breed)</p>


<div class="sideBoxContentItem"><img title=" Karen Millen Outlet Zip Pencil Dress Black " alt="Karen Millen Outlet Zip Pencil Dress Black" width="128" height="200" style="position: relative" src="http://www.karen-millen-outlets.co.uk/bmz_cache/0/040830bc91259304dd2a132dfe1eea64.image.128x200.jpg" />

Karen Millen Outlet Zip Pencil Dress Black
Do not wait for a round trip of life karen millen outlet is worth triple the door with the life of the classic quotes karen millen sale memorable words of wisdom alert people (English-Chinese) karen millen appreciate the good life, made life in the punch line 100 karen millen dresses karen millen outlet practitioner 35</div>


<p>Love karen millen you and you have done these 50 things</p>

<p>I bought your e-book about 5 months in the past, and I was hoping that might would "entitle" me to some assistance. Very first, allow me state that I'm really happy with my purchase. Not just does it give guidance on certain <span style="color: #ff6600">Karen Millen Dresses</span> tactics, but, a lot more importantly, it explains the foundation of all training-timing, inspiration, consistency-allowing the pet dog owner to far better realize the coaching process. Also, it does a very good job of describing that canines are pack animals-and will exam the alpha's leadership at a variety of occasions (in my situation, all of the time)-and how that factors into training. Finally, I like your common feeling strategy, e.g., "stay" can be a double command, if the dog's not supposed to break a sit or down with out the release command, why do we need to tell it to stay.</p>

<p> sale on www.karen-millen-outlets.co.uk/</p>

  • </div>


    <p>Reading of the famous aphorism about karen millen dresses the "struggle" 50 famous philosophical maxim celebrity karen millen dress karen millen dress foreign articles (with English) 4 150 on the struggle famous karen miller Chinese celebrities Jicui life motto in life is good enough karen millen outlet (1) a very nice career total of 36 sentences to teach you karen millen sale the classic 14</p>


    <p>Many thanks, Ryan Fehlig</p>


    <p> On a personal note, there was a character who let his Rottweiler operate off leash in the park I employed to train at. This dog had a bad mindset and was a very dominant-aggressive dog. The owner was beneath the impact that his canine was trained. He'd give several commands, like, 'Ranger occur, occur, come, occur,' but all Ranger would do is engage my clients' canines and attempt to initiate a canine fight.</p>


    Related articles:

  • http://www.the-back-row.com/blog2.php/2012/05/17/
 
Hi SirJB7,


I was able to fix the formula issue thank you but now I have couple of problems. 1) when I run the delete macros it gives me a bug. 2) the size of the document since I have to email it to a lot of people a smaller size will do it.


I did what you suggested. I deleted the invalid tab but now the macro is not working properly. Can you help me fix that issue.


Do you know how can I reduce the size to a manageable file? if you could help me fix these two issues I would be very greatful.

Thanks,


NN


https://dl.dropbox.com/u/90166573/Banded%20Rate%207-25.xlsm
 
Hi, nnavarro!


I was just about missing you, I thought there was something wrong with you as you didn't post any other issue of this blessed workbook... :)


I saw you removed the 'Invalid Data' sheet but you have to remove its reference in cell B2 of sheet 'Parameters', because the code checks for the Parameters!B2 value sheet to copy deleted rows, it that cell isn't empty.


That's about the non-properly working. Now let us go to she size issue.


Interesting issue as having done what I suggested before (and which worked to downsize from 64 Mb to 388 Kb and then to 64 Kb), I still get the damned 38 Mb file.


So I began deleting non used areas, from used ranges to XFD column and to 1048576 row.


Then I checked the named ranges, and found that there was a range named 'Band_Info' from A6:H1048576 in sheet 'Input data' where it's used up to row 11, so I changed it up to row 12 to make easier adding new items. There was also a range named 'Dump_Data' from J2:J1048576 in sheet 'Data Dump New' that was neither referenced in code nor in formulas, so I deleted it.


After that I went against conditional format. Sheets 'Data Dump New' and 'Data' (what's this last one for?) have CF conditions for B2:B3000 with formulas like =$B3:$B3000="Adjustment" or =$B2:$B2986="Adjustment" where column B is the ID number (for first sheet) and the AFF code (for second sheet), so I deleted them.


New file size? 3.6 Mb, even with sheet 'Data' that I don't know if it's necessary. If not, 3.4 Mb.


Here's the usual link:

https://dl.dropbox.com/u/60558749/Auto%20Delete%20Rows%20-%20Banded%20Rate%207-25%20%28for%20nnavarro%20at%20chandoo.org%29.xlsm


Just one humble and desperate appeal from my side... You're going to download the file, and then work as usual (because you work, don't you? I don't want to believe that all this is just for rising my blood pressure...). Well, I want you to write a short log in any format (Excel, Word, .txt) where you'll write down every operation you do with the 3.6 Mb file. When I say 'every operation' I mean every operation, from copying, deleting, moving, importing, exporting, sorting, ANYTH-ing, and periodically -as you consider properly- saving the file and checking it growth size.


Why? Because of the famous "nlmpi" reason (yeah, I know you understood, but for people who read English it's something alike "neafc" that should stand for "not even a <word of seven letters, gerund of a verb that in ancient English means fornication under consent of the King> clue").


It's the only way to take the bull by the horns, sorry to say.


Regards!
 
Back
Top