Search results

wow! that's perfect! only better would be for it to automatically run everytime you change the values in column A so there is an auto hide/unhide action, but taking into account the time it is taking me to do 500rows, I prefer not to wait 20secs every time I change a 0 to a 1. Thank you a lot...

thank you mate :)

or I could try to set up all the row numbers that I want hidden in one cell, if it helps... Do you have any more ideas?

I found my own solution. I was not googling it right: RANK function works perfectly!

Hello, Lets imagine that column A has: 10 110 1110 9 18 I would like column B to have some kind of ranking related to column A so that the result would be: 10 4 110 2 1110 1 9 5 18 3 How can I do that for a large list?

ok, tested... it is not exactly what I am looking for. Lets imagine that A9, A10, A16, A19, A200, A201.... all are marked with "1" so rows 9, 10, 16, 19, 200, 201 should be hidden. I mean, it may not be consecutive rows and it may not start in A1. What should the code be in this case...

thanks!! Testing........

Hello, I am looking for a solution for one of my workbooks to make it easier to read and make it smaller, eliminating not needed or blank areas. For it I would like to know how can VBA code help me to make: IF A1 = "1" then hide row 1, otherwise do nothing. The same for row 2, 3, 4, and so...

Hi Luke M, thank you very much for the code! I am trying it but my Excel crashes :S "Run-time error '1004': Select method of Range class failed" I thought it would be because the range was too big and I decreased it from 65536 to 500 just to test but I only got the same error... I am...

Hello, I have cut in another topic with this question, but probably it is better if I stop being lazy and write my own in the propper forum. I am thinking about a "dynamic" table showing the names of the customers in C2:IV2(?) and the product clusters in B3:B1000(?) With a function I would...

Also, and I forgot to mention, the trigger for that action could either be as soon as "x"s are changed somehow (automatic) or via button or shortcut. Thanks again

Sorry Hui, I have been erally busy these last days so I only had the chance to come back to the forum today. I am thinking about a "dynamic" table showing the names of the customers in C2:IV2(?) and the product clusters in B3:B1000(?) With a function I would then determine that if the row has...

Hi, this is great! Is there a way to instead of hiding from 1000 until the end of the worksheet, just automatically hide some columns and rows, based on the value of a specific cell? For example, I want all the rows that contain the letter "X" in the A column to be hidden, otherwise they...

Hello Hui, No, please don't apologise, you are helping me! Do it on your time, I will just thank you :) I will try it and get back to you! Thanks again

Sorry to insist, maybe it is too much to ask (I have no clue in VBA...), but any idea? thanks in advance

Hi Hui, Man, you're fast! It is just about position: D5 = D28 E5 = E28 F5 = F28 D6 = D29 ...and so on

Hello, In the same spreadsheet I have two twin data tables. One is for manually entering data, the other one shows the result of the calculation of the manual entry and some other figures. Now I would like to mark some cell somehow (patterns, font color, bold, etc.) in the first table in a...

That's great! Good teaching and examples also. Thanks a lot

I have asked for another format but the bank only has spreadsheet or pfd. I have to study UDFs; do you know a good site for beginners? Anyways, I am starting to work on the solution I explained before and it seems to work propperly. Thanks a lot for your help.

Hello, I have been trying the 7 Personal Expense Trackers from last week's post and I realized that I like some of them a lot but I know I will not use them. In the past I have designed my own Tracker for this purpose and it was great (for me). Nevertheless the updates only lasted 4 months...

WOW, that works perfectly! I must take VBA classes someday :) Thanks a lot for that.

Hi Hui, Thanks a lot; just an additional question, to put it into a code mode what do I need to do? I right clicked on Sheet1 and then View Code. Then I pasted it there bt the HMW function does not work (#NAME?). I am still a noobie in VBA so there is probably something I am not doing correctly.

Hi, I think that the link is OK now. Still no clue?

Hi again, Sorry, there seems to be a problem with the upload to 2shared, so I leave you here a mediafire link: http://www.mediafire.com/file/zwdzojjyjdj/CD.xls

Hi again, Sorry, probably my explanation was not that effective. I now post an example. http://www.2shared.com/document/J9bF86jV/CD_online.html In the first part (rows 1-23) we may see what would be the manual calculation of this coverage. The second part (rows 30-44) have an automated...