Automatically copy formula to next cell when i enter something in perticular cell

**sanketgroup** · 09-08-2007, 05:38 AM

Hi,
I need to copy formula to next cell when i enter something in perticular cell.
i.e

Colomn A --- Colomn B --- Colomn C
1 01-09-07 --- John --- =vlookup(b2,$s$1:$t$10,2,false)
2 01-09-07 --- Smith --- =vlookup(b3,$s$1:$t$10,2,false)
3
4
5

Now if i enter date in cell A3 then cell C3 should be automatically filled/copy formula as celll C2. and so on......
then if i enter data to A4 then cell C4 should be automatically filled/copy formula from cell C3.

how can i do this. any idea?

S.

**corinereyes** · 09-08-2007, 05:47 AM

Hi sanketgroup,

Use the fill series to copy the formula down. Select the formula in cell C1, move your cursor the right bottom of the cell, your cursor will change to a black + cursor, hold down the right mouse button and drag down to fill the series.

**sanketgroup** · 09-08-2007, 06:45 AM

i need to copy formula to the next cell automatically only when i type in previoud raw and colomn.

I dont want to define all the formulas to at this time in colomn C. It should be inceased or copied to next row only when i type.

If i type in A3 then macro should fill up C4 with formula in C3
If i type in A4 then macro should fill up C5 with formula in C4
If i type in A5 then macro should fill up C6 with formula in C6

**sanketgroup** · 09-08-2007, 05:55 AM

Hi,
I need to copy formula to next cell when i enter something in perticular cell.
i.e

--Colomn A --- Colomn B -- --------Colomn C
1 01-09-07 ----- John ----------=vlookup(b2,$s$1:$t$10,2,false)
2 01-09-07 ----- Smith -------- =vlookup(b3,$s$1:$t$10,2,false)
3
4
5

Now if i enter date in cell A3 then cell C3 should be automatically filled/copy formula as celll C2. and so on......
then if i enter data to A4 then cell C4 should be automatically filled/copy formula from cell C3.

how can i do this. any idea?

S.

**StephenR** · 09-08-2007, 06:09 AM

Tools > Option > Edit and check Extend List Formats and Formulas is checked.

**sanketgroup** · 09-08-2007, 06:50 AM

i need to copy formula to the next cell automatically only when i type in previoud raw and colomn.

I dont want to define all the formulas to at this time in colomn C. It should be inceased or copied to next row only when i type.

If i type in A3 then macro should fill up C4 with formula in C3
If i type in A4 then macro should fill up C5 with formula in C4
If i type in A5 then macro should fill up C6 with formula in C6

all4excel · 09-08-2007, 06:57 AM

Hey sanket,

What about the value in the columns B3 and B4?

You r wanting to have vlookup if the cell a3 and a4 are filled but what about wht col b?

**sanketgroup** · 09-08-2007, 07:02 AM

that one i will fill up. i will define the Values in B3 and B4. but as soon as i fill A3 or B3, macro should automaticall copy the formula from C3 to C4

**corinereyes** · 09-08-2007, 07:07 AM

Hi sanketgroup,

Can you attach an example xl file? (Don't forget to zip the file)

**sanketgroup** · 09-09-2007, 02:27 AM

any luck corinereyes?

**corinereyes** · 09-09-2007, 05:05 AM

Hi sanketgroup,

I dont think it is possible to construct a formula that would do that. If you want you could try xl VBA or can ask someone in this forum to write an example VBA that would do your task.