Dynamic range that stops after a white row

[hond]

Hi,

I am looking for a dynamic range that picks up data untill it detects a white row/cell.

The range has to work with the existing cells already have, these are:

A cell with the current month, this cell changes when a month is over.
A cell with the cell address of the month in the spreadsheet.

example: (the details are in different cells)

January
31/07/1900 kjsadfkj £213.00 32432343 4.00 3.00
31/07/1900 kjjsafj £213.00 2423342 5.00 3.00
31/07/1900 kjsadfkj £213.00 -27585659 6.00 3.00
31/07/1900 kjjsafj £213.00 -57594660 7.00 3.00
31/07/1900 kjsadfkj £213.00 -87603661 8.00 3.00

February
31/07/1900 kjsadfkj £213.00 32432343 4.00 3.00
31/07/1900 kjjsafj £213.00 2423342 5.00 3.00
31/07/1900 kjsadfkj £213.00 -27585659 6.00 3.00
31/07/1900 kjjsafj £213.00 -57594660 7.00 3.00
31/07/1900 kjsadfkj £213.00 -87603661 8.00 3.00

march
31/07/1900 kjsadfkj £213.00 32432343 4.00 3.00
31/07/1900 kjjsafj £213.00 2423342 5.00 3.00
31/07/1900 kjsadfkj £213.00 -27585659 6.00 3.00
31/07/1900 kjjsafj £213.00 -57594660 7.00 3.00
31/07/1900 kjsadfkj £213.00 -87603661 8.00 3.00

when the month is entred in the cell, the dynamic range has to pick up the address cell and select the related table for only that month.

It is quite hard to explain, but I hope it makes sence.

Thanks!

[Pepe Le Mokko]

Please post a sheet so we can see the exact layout - Thx

[hond]

Hi Pepe,

Thanks for showing interest, it tried to replicate the file because I can't send you the real one. (confindentiality)

Hope this helps

hond

[:) Sixthsense :)]

In M4 cell

Please Login or Register  to view this content.

CLICK the M4 Formula cell using the MOUSE, which will take you to the respective Month.

[hond]

Hi Sixthsense,

Thanks for helping, but that is totaly not what I am looking for. I need a dynamic named range that selects range A4:H15 if L4 says January, and selects range A17:H28 when L4 says Februari and so on. Cell L5 is just a cell I made to make it easier to make a dynamic named range.

Sorry if I was not clear enough before....

Thanks

[:) Sixthsense :)]

Right click the sheet tab and select view code and copy/paste the below code in code window and return to excel. Type the Month name in L4 cell which will automatically select the range FRESH ENTRY IS REQUIRED IN L4 Cell

Please Login or Register  to view this content.

[hond]

Thanks again for helping, but I can't use this. I need a Dyanamic named range I need this because I am working with other macros and people that are going to use it do not have VBA knowledge.

Please help

[:) Sixthsense :)]

Hmm... But i am not interested to sit and write a formula solution for this. because from my point of view going for vba is a better metho when comparing to writing lengthy formula.

I hope someone will give you the expected formula solution.

[Pepe Le Mokko]

Hmm... But i am not interested to sit and write a formula solution for this. because from my point of view going for vba is a better metho when comparing to writing lengthy formula.

I hope someone will give you the expected formula solution.

re inventing the wheel does make one feel important, doesn't it ?

[:) Sixthsense :)]

re inventing the wheel does make one feel important, doesn't it ?

Sorry i am poor in understanding english, can you please explain your above sentence in simple english?

[hond]

If you want to call it that way, go ahead, but I have to change numerous lengthy VBA codes that pick up dynamic ranges if I don't do it the way I describe.

[:) Sixthsense :)]

@ hond,

I am not sure how i have to assist you in further since i already provided the code and described how to use it. So you have to let me know what drawback you are facing with it.