Programming Formulas

[animal1881]

Hey all! This is my first time here, my boss gave me an assignment an
I cant finish it. Maybe someone could please help me...

What I would like to do is take a single worksheet "sheet1" with lot
of data about individual circuit breakers entered row by row, and tur
each row into its own worksheet with data mapped to certain labele
cells on the new worksheet. Essentially making a single label page fo
each circuit breaker. If I change a value on sheet1, I would like th
value on the corresponding label page to change as well. I have trie
this:

LabelPage(lprow, lpcolumn) = sheet1(row,column)

but that only copies the data once. If I go back and change somethin
in sheet1, then I have to run the whole program over again.

I need to know how to set up excel formulas using vba, something lik
this:

Labelpage(lprow,lpcolumn) = "=worksheets('sheet1').range(row,column)"

but that doesnt work

 

[Tom Ogilvy]

set Labelpage = worksheets("Sheet3")
Labelpage.Cells(lprow,lpcolumn).formula = "=" & _
worksheets("sheet1"').range(row,column).Address(True, True,,True)