linking data to several worksheets

  • Thread starter Thread starter Bob Taylor
  • Start date Start date
B

Bob Taylor

I'm setting up a register of information, which will link
information from a main page, containing all of the
projects, to several individual project pages. How can I
set it up so that the info I put on to the main page
automatically links to the individual project pages. What
I 'd like to do is have a column, in which you enter the
project number. So for instance, if you make the entry "
$1000 May 22, 2003 project #22" how can I have excel read
that line and automatically post the entry to a separate
sheet, (same workbook) which contains only those entries
referenced to "project 22" Any help is MUCH appreciated!!
 
I, too, want to know about this. More specifically, I
want to know about how to get Excel to
1. cycle through about 70 sheets
2. pick up a certain formula on each sheet, and
3. place the results of that formula on a new sheet.
Any help available?
 
Back
Top