Posted by rayn on June 04, 2001 8:45 PM
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