Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
appending to second worksheet from a Master Sheet
I have one worksheet, "wsA" where I'll do all the work and calculations.
Upon completion of the calculations, I want to copy the results to a single row in a second worksheet, "wsB." If I do another set of calculations in "wsA," I want the capability to append the second set of calculations to "wsB," preserving the data from the first calculations. If I do 30 sets of calculations in "wsA," when I'm finished I want 30 unique rows of calculated results in "wsB." Can someone get me out of the blocks? Merci Bien |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
appending to second worksheet from a Master Sheet
dim rw as long, i as long
dim rng as Range With worksheets("wsB") set rng = .Cells(rows.count,1).End(xlup)(2) End With rw = 0 With worksheets("wsA") for i = 1 to 10 .cells(3,"B").Value = i ' with automatic calculate, values should be recalculated ' before the next line is executed. .cells(3,"B").Resize(1,10).Copy rng.offset(rw,0).PasteSpecial xlValues rw = rw + 1 Next i End With -- Regards, Tom Ogilvy Driver wrote in message ink.net... I have one worksheet, "wsA" where I'll do all the work and calculations. Upon completion of the calculations, I want to copy the results to a single row in a second worksheet, "wsB." If I do another set of calculations in "wsA," I want the capability to append the second set of calculations to "wsB," preserving the data from the first calculations. If I do 30 sets of calculations in "wsA," when I'm finished I want 30 unique rows of calculated results in "wsB." Can someone get me out of the blocks? Merci Bien |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
appending master list data | Links and Linking in Excel | |||
appending master list data | Links and Linking in Excel | |||
appending master list data | Links and Linking in Excel | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Appending data from one sheet to another. | Excel Programming |