Copying based on a condition

[Guest]

To anyone who can help...

I would like to know if anyone knows a way in Excel 2000 to copy a cell or range of cells and either paste or insert as a series after a test to see if a condition is TRUE or FALSE.

For example, I have a Formula in J3 that calcs A3:G3. I want to test a condition on J1, if the condition is TRUE then I would like to copy the Formula in J3 to J4 and still have the Formula change its references.

 

[Frank Kabel]

Hi
maybe
=IF($J$1,SUM(A3:G3),"")
and copy this down

-----Original Message-----
To anyone who can help...

I would like to know if anyone knows a way in Excel 2000

to copy a cell or range of cells and either paste or
insert as a series after a test to see if a condition is
TRUE or FALSE.

For example, I have a Formula in J3 that calcs A3:G3. I

want to test a condition on J1, if the condition is TRUE
then I would like to copy the Formula in J3 to J4 and
still have the Formula change its references.

 

[Guest]

The test against J1 is really to see if anything has been written and the copy or insertion part is to be done automatically with some function or macro - something. Basically what I need to do is test to see how many lines of data have been written and then copy formulas for each line of the list of data, where the number of lines in the list of data always changes.

Thanks for the imput.