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)