welsh_decs
New member
- Joined
- Nov 25, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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) - i have attached this spreadsheet
View attachment Credit Card Spreasheet.xlsm
Please help
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) - i have attached this spreadsheet
View attachment Credit Card Spreasheet.xlsm
Please help