Formula to re-populate data from one sheet to another

[Biologist2331]

Hi,

I am hoping I can learn how to write a formula or a macro to help organize our bird species data. The problem is that we enter a bird name in one column and the number seen in a different column and it totals at the bottom. The date changes each day, as do the birds seen and the number counted. We end up having to enter the data twice (once to the report that gets sent out and once again to the sheet that keeps a running total for every day).

Is there a formula that will let us enter it once and then that data will automatically populate the correct day, bird species and number seen on a different sheet?

I have seen additional questions on this forum that were very similar and the answer was a macro. I would have attempted it, if I knew how to get started on a macro.

I appreciate any help!
Rhoni

[FDibbins]

So you enter your data in Species Account, for that day, and you want it transferred to AUGUST sheet each day - then you delete the data in SA, and repopulate it tomorrow?

If that is teh case, then no formula will do what you want, you will need VBA, however, have you considered using 1 big database for ALL your data, just keep adding on at he end, and have a column for the date? That way, you could use a relatively simple formula to pull in the daily data. Also, instead of a sheet per month, you could have 1 sheet, with a drop-down for trhe month, and it would pull out all your data for you

[Biologist2331]

Okay...I was afraid of that.

Thanks for the help!
Rhoni