automatically transferring data to another worksheet

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
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Good morning,

Please see the attached file. I made a "flag" on the first sheet that numbers each record, then on the subsequent sheets, the index-match calls based on the sheet name and the row number.

Best of luck,
 

Attachments

  • Credit Card Spreasheet_sample.xlsm
    183.4 KB · Views: 28

aj203akash

New member
Joined
Dec 6, 2013
Messages
3
Reaction score
0
Points
0
Hi, I have a one questions also. I have employee master list there has been some around 300 rows of employee list, there are including left employee also. o.k now what is the question there is one column is the date of birth. now what is the problem is that every day i find out that who is the birth day of today.

So is there any formula any conditional formatting formula that i am in morning coming in office and open the excel files and i have show that the today is so and so employees are birth day and that birth date column are appearing with back ground cell color so that i have seen easily that and find the employee.

Pls. reply me and solve the matter
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
You could use conditional formatting. Just use a formula like if(c2 = today(),1,0) and set a format.
 

aj203akash

New member
Joined
Dec 6, 2013
Messages
3
Reaction score
0
Points
0
Please send/attached the example excel file

Thanks & Regards
 
Top