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 hope this all makes sense to you, If i need to clear any details up I will try.

Please help