I have some probably basic questions:
I have created a multi sheet document which records the plant species in a set location. Each sheet represents the data collected at a particular visit data. I have created a summary sheet to keep a running total of the different species frequencies in order to look at multiple years data at a glance and see trends. The summary sheet links back to each year's visit data (some of it). What I am trying to do is to create some sort of autogenerated set of cells to represent any new sheets and thus new years data as it is recorded, if it is possible. If not I would just like to know how I can change the summary sheet cells in question to link to a different sheet. This way I could at least copy some rows then make them look at the new data easily.
By the way I am pretty new at the program and not very savy as I have seen on this site already. Please be very descriptive in your responses because I am just a newbe.
Thanks for the help!!!!
I have created a multi sheet document which records the plant species in a set location. Each sheet represents the data collected at a particular visit data. I have created a summary sheet to keep a running total of the different species frequencies in order to look at multiple years data at a glance and see trends. The summary sheet links back to each year's visit data (some of it). What I am trying to do is to create some sort of autogenerated set of cells to represent any new sheets and thus new years data as it is recorded, if it is possible. If not I would just like to know how I can change the summary sheet cells in question to link to a different sheet. This way I could at least copy some rows then make them look at the new data easily.
By the way I am pretty new at the program and not very savy as I have seen on this site already. Please be very descriptive in your responses because I am just a newbe.
Thanks for the help!!!!