I am the President of a Volunteer Fire Department and I am working with a spread sheet for our yearly fund drive. I am trying to seperate my information in to 2 sheets. Currently I have on sheet 1 all of my control information. Name, address, City, State, Zip and amount donated. What I am trying to do is find out if there is a formula that once i enter an amount in to the donation column it will copy the entire row over to sheet 2. this way I can print out 1 sheet that will show me all persons that have donated to the department for that particular year so thank you cards can be returned. I hope I have explaned this correctly. Thank you all in advance for your help on this.
