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!!