Formula

[Dorothychin]

To all experts
Is there any formula I could use to copy India to A2 & A3, Brazil to A5 & A6 and Australia to A8 & A9.

Book2
	A	B	C	D
1	India	Oven
2		Fridge
3		Machine
4	Brazil	Oven
5		Fridge
6		Machine
7	Australia	Oven
8		Fridge
9		Machine
10
Sheet1

 

[Dorothychin]

Please help..thanks
Dorothy

 

[Tuner]

I'm not sure if I'm oversimpifying your request or not so please forgive me if this is too basic. Could you enter formula =A1 in cell A2 and copy this formula into all remaining 5 blank cells in column A.
Or are you providing merely a sample of a much larger more complex dynamic sheet?

 

[Yogi Anand]

Hi Dothychin:

The formulatic approach is a little tricky to describe, so I have provided a worksheet simulation with steps delineated in the simulation.

y021106h1.xls
	A	B	C	D	E
1	India	Oven		incolumnA,entriesinRedBoldexist
2	India	Fridge		nowletusfillprogramaticallyA2,A3,A5,A6,A8,A9
3	India	Machine
4	Brazil	Oven		StepbyStep
5	Brazil	Fridge		1.SelectA1:A9
6	Brazil	Machine		2.Edit|Goto|Special|Blanks
7	Australia	Oven		3.Clickintheformulabarandkey-in=
8	Australia	Fridge		4.PointtocellA1
9	Australia	Machine		5.CTRL+ENTER
Sheet17 (2)

</SPAN>

Regards!
Yogi Anand

 

[Dorothychin]

Thanks!! this is perfect!