how can i make a formula that will expand with the data?
Posted by need advice on July 18, 2001 12:11 PM
i need to make a total profit report for products
each product will appear in a diffrent line
the range of data is changing and i dont know how many products it will have.
can i make a formula for one row and make it expand as many rows as needed?
and also how can i design the cells (borders extra..)
and how do i know where to put the total sum line?