Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Formulas
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Formulas
set Labelpage = worksheets("Sheet3")
Labelpage.Cells(lprow,lpcolumn).formula = "=" & _ worksheets("sheet1"').range(row,column).Address(Tr ue, True,,True) -- Regards, Tom Ogilvy "animal1881 " wrote in message ... Hey all! This is my first time here, my boss gave me an assignment and I cant finish it. Maybe someone could please help me... What I would like to do is take a single worksheet "sheet1" with lots of data about individual circuit breakers entered row by row, and turn each row into its own worksheet with data mapped to certain labeled cells on the new worksheet. Essentially making a single label page for each circuit breaker. If I change a value on sheet1, I would like the value on the corresponding label page to change as well. I have tried this: LabelPage(lprow, lpcolumn) = sheet1(row,column) but that only copies the data once. If I go back and change something 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 like this: Labelpage(lprow,lpcolumn) = "=worksheets('sheet1').range(row,column)" but that doesnt work. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming in VB | Excel Programming | |||
Programming lag | Excel Programming | |||
Programming Array Formulas in VBA - Can they be intermediate results in RAM? | Excel Programming | |||
programming vba in vb | Excel Programming | |||
Array formulas into VB programming | Excel Programming |