MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy Data To Specific Row On Other Sheet Based On Date

Posted by Kevin on April 21, 2000 9:17 AM

I have workbook with about 30 sheets in it. The First sheet has a list of employees on it and we put certain stat in the row with their name on a daily basis. I then have to manually go to each sheet (one per employee) and put the same data on each sheet (choosing the appropriate row for the day) daily, so I can come up wih a monthly report for each person. I have tried to use teh IF function on indivual sheets, which works for todays data but erases yesterdays data because it evaluates it as false. Formula says: IF (cell which contains date(number)(on sheet 1)=(cell on current sheet with date(number), "(value of cell on first sheet i want)","") can't get it to leave data alone in that cell if it evaluates false. PLEASE HELP!!

Posted by david on April 21, 2000 10:07 PM

have you tried the vlookup function
i don't realy understand what you are saying but i had a similar problem
where i had a date and needed the info that matched that date
after i got tired of that i got a little more advanced
and combined the index and match functions
try to give a little more info

Posted by david on April 21, 2000 10:11 PM

think i misunderstood the problem sorry