Question by MICHELLE B: I have an excel workbook, on office 2010 and need help?
I have an excel workbook on office 2010. it has 2 pages. On one it has the dates people took part in training and the other has statistics of how up to date we are. The statistics are percentages of the people who completed the training in the last 6 months, and i need it to update automatically. so basically as i put on one sheet that a staff member has attended by entering the date, on the other sheet i want the percentage to update. Anybody any idea how this is done please?
Best answer:
Answer by Artemisc
I assume by two pages you mean two tabs. If your source data is on tab one, click on the source sell, hit the equals sign (=), then go to the target cell and hit enter. The data from the source cel will be copied over. Then open the target cell and put in whatever your formula is using the source cell data.
Assuming I understood your question correctly, that should work.
Give your answer to this question below!
A few nice office 2010 images I found:
Microsoft-to-Detail-Office-Mobile-2010+powerpoint-sharepoint+windows+mobile+7+windows+mobile+6.5+free+download
Image by Shekhar_Sahu
Free office mobile 2010 for windows mobile 6.5 and 7
www.whitehatandroid.com/2010/05/office-mobile-2010-for-wi…
The office
Image by drewsaunders
I have an excel workbook, on office 2010 and need help?
No comments:
Post a Comment