Excel: automatically move data to another worksheet

I am not sure which section this would come under. I work for a company that has 8 or 9 holiday parks. We have a spreasheet for the company credit card. The first sheet has all the credit card transactions, one of the columns on this sheet is named "Park" where we input the name of the park that the transaction is for. then there are 8 other sheets one for each of the parks. Is there a formula or anything I can do that when we input the name of the park into the "Park" column that it automaticall transfers that row of information into the correct sheet for that park. I did try to do one with a macro and it worked however, I had to click the update entry button (i created to run the macro) everytime I entered a line, and also if i had 2 entries for one park the second one would overwrite the first one (it wouldnt go to the next available row)

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of November 25, 2013.

For more resources for Microsoft Excel