linking and series

[almagg]

disregarding the sheet name and row, the source cells follow the pattern:
...DL, DN, DP...
and new columns are added

i copied and linked the three cells, but now when the user extends the source cells, she will go to the destination and extend those also, but when i selected and used the fill handle, i got: DO, DQ, DS

when i tried two cells: DL, DN
i get: DN, DP

i tried the series command on the file menu but no luck. is what i want to do clear? is it possible? maybe with a macro? i can write some basic vba if you point me in the right direction.

thanks.

 

[PaddyD]

Hi - welcome to the board!

If this is right:

Problem: Create a series of the form "Dx" where x is increases as every second letter of the alphabet.

...it should be fairly straightforward to do with a formula if you can't get the Fill...Series to work.

See the example below:

Book3
	A	B	C	D	E	F	G	H
1	DB	DD	DF	DH	DJ	DL	DN	DP
2
3
Sheet1

...check out the help files for how char() works if you need to & post back....

Paddy