Excel and propogating data
Hi everyone,
How do I propogate data from one worksheet to another in Excel without
having to cut and paste? Is there an easier and accurate way?
My Problem in more Detail:
Right now I have an Excel spreadsheet for listing all my Training Courses.
It's the main worksheet where I enter all my courses that I've taken, plan to
take, and ones I put on hold. Then I have 3 sub-worksheets that each are
named COURSES TAKEN, COURSES NEEDED, and COURSES PLACED ON HOLD.
So when I enter new information in the main worksheet, I also have to go to
a sub-worksheet and enter the same info into this sheet. Is there an easier
way?
Thanks,
Kessie
|