Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy & paste to all Sheets to the same cells
Hi,
The below macro copies a value entered to Sheet1 A1 to other two Sheets A1's. Can I generalize it so that it is adoptable to "any" cell on Sheet1?. I need to be able to automatically copy any value entered to Sheet1' to the same cell on all other Sheets!. (e.g.: if I write a number or a text to Sheet1 K4, I want excel to automatically copy the same value to all existing Sheets K4' cells. Here is my macro: ------------------------------------------ Sub Macro1() ' ' Macro1 Macro ' Macro recorded 22.06.2004 by Martyn ' ' ActiveCell.FormulaR1C1 = "3" Range("A1").Select Selection.Copy Sheets("Sheet2").Select ActiveSheet.Paste Sheets("Sheet3").Select ActiveSheet.Paste End Sub --------------------------------------------- TIA Martyn --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.708 / Virus Database: 464 - Release Date: 18.06.2004 --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.708 / Virus Database: 464 - Release Date: 18.06.2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy&paste of several sheets | Excel Discussion (Misc queries) | |||
Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
copy from one sheet and paste into other sheets | Excel Discussion (Misc queries) | |||
MS Excel Sheets...how to copy and paste ? | Excel Programming |