From 1 sheet to the next?
 

I use excel to do my small business accounts.
It has 12 sheets, 1 for each month.
If I am entering data in January, is it possible to copy all the data
in one single line to another sheet automatically, for example if I
could use a key word such as the month or a date in a particular cell,
I would then want that whole line to be copied to the appropriate
sheet.
Thanks for your time.


---
Message posted from http://www.ExcelForum.com/