atlas215
02-14-2010, 03:21 PM
Hello All -
I am a first time poster on this forum though i was looking for a little help to what i believe is a simple issue.
I have an excel sheet where the user will load raw data onto the first tab of the sheet - on the second tab I am looking to code formulas and such to perform analysis on the data. What I am looking for help on is an easy way to define and reference the last row of data on the first tab. This sheet will be used daily or so with different sets of data and so the last row will not be defined.
For instance -on day one i have 2000 rows of data - i would like my sheet to perform all of the analysis in the second tab and copy them down and such for all of those 2000 lines but no more and similarly on day two if the data is not 5000 lines i would want the referential analysis to be done for each of the 5000 lines.
I know i could do this with a loop until statement though i am looking for a more efficient way to define this range.
Thanks -- and please let me know if this is unclear.
AA
I am a first time poster on this forum though i was looking for a little help to what i believe is a simple issue.
I have an excel sheet where the user will load raw data onto the first tab of the sheet - on the second tab I am looking to code formulas and such to perform analysis on the data. What I am looking for help on is an easy way to define and reference the last row of data on the first tab. This sheet will be used daily or so with different sets of data and so the last row will not be defined.
For instance -on day one i have 2000 rows of data - i would like my sheet to perform all of the analysis in the second tab and copy them down and such for all of those 2000 lines but no more and similarly on day two if the data is not 5000 lines i would want the referential analysis to be done for each of the 5000 lines.
I know i could do this with a loop until statement though i am looking for a more efficient way to define this range.
Thanks -- and please let me know if this is unclear.
AA