Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells in active row
I would like to know the best way to copy specific cells from selected
row to specific cells on another work sheet. I have one worksheet that I keep adding new data to each cell what I need to happen is what ever cell I select I would like the cells in the selected row pasted into other cells on another formatted worksheet. The formatted worksheet cells are always the same the data will overwrite I just need it for a printout. Any help would be much apprieciated. Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells in active row
set sh = Activesheet
rw = Activecell.Row With Worksheets("Report") .Range("B9").Value = sh.Cells(rw,"A").Value .Range("C11").Value = sh.Cells(rw,"B").Value .Range("B3").Value = sh.Cells(rw,"C").Value End with -- Regards, Tom Ogilvy "MikeDDD" wrote in message oups.com... I would like to know the best way to copy specific cells from selected row to specific cells on another work sheet. I have one worksheet that I keep adding new data to each cell what I need to happen is what ever cell I select I would like the cells in the selected row pasted into other cells on another formatted worksheet. The formatted worksheet cells are always the same the data will overwrite I just need it for a printout. Any help would be much apprieciated. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Copy Active Worksheet | Excel Programming | |||
Copy Paste from Active cell | Excel Programming | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |