MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula


Posted by rayn on June 04, 2001 8:45 PM

Hi

i am doing some contracts administration. i have contracts
with codes next to them. for example cell A1 contains the code
and cell B1 contains the name of the contract. i would like the codes to appear on seven differents sheets.
i would be entering new contract codes on regular basis.
i would like to enter the code on one sheet only and the new sheets to be updated
with the same new code automatically. i have tried entering fomulas to do the following
but this restricts the filter function because it detects the codes as formulas not values.
is their a way of doing this. Maybe a macro !!!!!

Thank you for your help regards
Rayan


Posted by steve w on June 05, 2001 9:43 PM


How about just pasting a link
=Sheet1!$A$1
on all your sheets.
Im not sure what your looking for,what are you filtering for and how are you doing it.Let me know if you need more help.

steve w

Posted by rayn on June 06, 2001 6:21 PM

Hi steve

i have tried doing that. But sorry not when i filer but whne i do a search, the function does not work.
because there is a link in the cells not values. the reason i do a search
because i might have hundreds of contract codes, so when i want to look for
a contract i do a search for its code.

so i want is to enter the new contract name and code, however i would like
the code and name to appear on another 4 or 5 different sheets. i would like to automate the process
because i will be entering hundreds of contract codes and names.

Thank you for your help

Posted by steve w on June 06, 2001 10:00 PM

It sound like the match, index and vlookup functions mayhelp you. You can use the to lookup the information bymatching your names or contract codes.

steve w