Hi, Try following code
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim sht As Worksheet
Dim shtname As String
If Target.HasFormula Then
For Each sht In ThisWorkbook.Sheets
If sht.Name <> ActiveSheet.Name And sht.Cells(Target.Row,
Target.Column).Value = "" Then
sht.Cells(Target.Row, Target.Column).Formula =
Target.Formula
End If
Next sht
End If
End Sub
Pls find attached excel for ref.
Above code will work fine if no. of sheets and formulas are limited.
Regards,
Swapnil
On Tue, Oct 4, 2011 at 5:46 PM, renuka chari <jva.ch...@gmail.com> wrote:
> hi experts!
>
>
>
> i am having a excel workbook, it contains 10 sheets
> my query is "if i enter a one formula in first sheet in specific range
> in one column that formula should be add in specific range in other
> sheets at single time" is it possible
> if any macro or macro sheet cna you send as soon as possible
> Plzzzzzzzzz
>
>
>
>
> thanks in advance
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Copy formula.xlsm
Description: Binary data
