vba. help. reference formula
 

New to vba, I beg for patience.
My workbook contains a master (sheet1) of maturity dates and coupons. I've
added one new sheet per maturity to perform schedules for each bond. I want
each new sheet to reference the respective bond on the master sheet. how can
i do this?

vba. help. reference formula
 

One way might be to use VLOOKUP

--
Don Guillett
SalesAid Software

"MFR" wrote in message
...
New to vba, I beg for patience.
My workbook contains a master (sheet1) of maturity dates and coupons. I've
added one new sheet per maturity to perform schedules for each bond. I
want
each new sheet to reference the respective bond on the master sheet. how
can
i do this?

vba. help. reference formula
 

Since you said vba have a look in the vba help index for FIND or FINDNEXT

--
Don Guillett
SalesAid Software

"MFR" wrote in message
...
New to vba, I beg for patience.
My workbook contains a master (sheet1) of maturity dates and coupons. I've
added one new sheet per maturity to perform schedules for each bond. I
want
each new sheet to reference the respective bond on the master sheet. how
can
i do this?