Insert list of dates from a my WKS

Originally Posted by harryhill

One tab of my working sheet I list certain days in the year arranged by months..

Jan Feb etc etc
1 3
2 4
3 5

I would like to just type in: Jan in another part of my WKS and then all those Jan dates would be inserted below. Same option for Feb....Dec

Seems like Vlookup might do it but I cannot figure.

Hi,

the various VLookup, Match etc cannot do that, mainly because of the variable number of rows that will follow, a formula can set a value in ONLY the cell in which the formula resides.

You could have a small VBA macro to detect entry, via a WorkSheet_Change event, in a specified column (or range of columns) and then add 'found' data to the following rows.

hth
---

Originally Posted by harryhill

Phew!...this is getting tougher.

I will try and figure that out. As it stands now, the person just copies the dates from that area and pastes them where needed. Sort of low tech but it works.
Thanks.

Hi,

A macro could do that if . .

but you need to decide the definition of what is to be copied, and the definition of the place to be copied to, whether added to the end of a sheet (which column defines the 'end' of data) or inserted at some point, which point.

hth
---

Plenty of links for beginners here

http://www.excelforum.com/showthread.php?t=584092

Originally Posted by harryhill

Well..I guess a Macro will do it. I made 12 macros. I had to learn that 'Paste Special' has some meaning over just 'Paste'.

Not elegant. I wanted for someone to just select 'Jan' and the dates would appear in the correct space.

Thanks...Exel is plain slave labor. But...I enjoy it even although I am down at the bottom-knowledge wise.

Hi,

you should not need more than 1 macro, can you paste the code from one (or two) of your macros.

---