Copiyng From one sheet to the other (excel)
Posted on 2006-03-22
I have a issue:
In SheetA I have:
Cell A1 = bla bla
Cell F2 = bla bla
Cell G3 = bla bla
Is there any code that can help me to bring the contents of these cells and copy them to
A1 = Sheet cell 1A
B1 = Sheet cell F2
C1 = Sheet cell G3. Because on sheet A this cells will be refreshed cotiniously so I was trynig to insert a commandclick nammed save that every time the user click on the command cotton the contents of these cells should be added on the next sheet in a row and the next time the contents of sheet a should be added again in sheet B but on the next row and so on.
Resume: In sheet a I have: |John | Frederick| class 1b| this should be copied on the second row of sheet b then when I click on the command botton next time will have
|Maurice| Antonius | class 5d| and so on so sheet 2 will be creating lika a sort of list with multiple rows.
Please if anyone can help me I will higly apreciate it .