linking data to several worksheets

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

TJones

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Get the right language when inserting a date 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Adding data to MS Access from csv file 0
Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages 1
How to create a Header at the top of my MS Project 2013 plan? 3
Auto-Numbering in a Table in MS Word 1
Date of worksheet comes out numbers on other linked worksheet 2

Top