I am creating a template for to manage data. My problem is that when I enter
a formula I need it to read the last cell in a colom with data in it. For
example, I am entering data for items where I have three months of data or
ten years of data. How do I create a formula in sheet 1 that will plug in
data for the last cell weather it be c6 or c66 on Sheet 4? If I specify a
specific, it may or may not be that last one in the colum for example my
formula in the template is ='Data Streams'!J16 which is great for one
product, but it doesn't work with another product with a longer history.
Please advise if this is possible.
Thank you in advance=0)

Try this... to the left of the number you need to identify, type "Total" or
"Last" (just something for the formula to "find"). On sheet 1, use a sumif
formula that references the other sheet. Make the range for the formula go
well beyond the end of the data. Or, you can put the data in a named range
and use the range name in the formula.

Another option would be to record a macro that goes to sheet 2, goes to the
bottom of the column, copies, goes back to sheet 1 and pastes. You could
record one for each product (sheet) and put buttons on sheet 1, beside each
product.

Yet another option would be to reverse the order in which the data is
entered. Insert a row at the top of the sheet and enter the data there,
instead of at the bottom. You can then always reference the same cell at the
top of each sheet.

"Bridget" wrote:

I am creating a template for to manage data. My problem is that when I enter
a formula I need it to read the last cell in a colom with data in it. For
example, I am entering data for items where I have three months of data or
ten years of data. How do I create a formula in sheet 1 that will plug in
data for the last cell weather it be c6 or c66 on Sheet 4? If I specify a
specific, it may or may not be that last one in the colum for example my
formula in the template is ='Data Streams'!J16 which is great for one
product, but it doesn't work with another product with a longer history.
Please advise if this is possible.
Thank you in advance=0)