Copying data between sheets

December 9, 2010 at 09:31:44
Specs: Windows XP, 1gb
i want that whatever im working in sheet 1 the same work automaticly be copied in sheet 2 and also another sheet to ........ Help Plz

See More: Copying data between sheets

Report •

December 9, 2010 at 11:19:47
The simple solution is to fill every cell in Sheet2 and "the other one" with formulas.


Of course, while that is "simple" it's also very inefficient.

You'll need to give us some more information about what you are trying to accomplish before we can offer any assitance.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

December 12, 2010 at 03:08:53
DerbyDad03 thanks for your replied on my Question
its was really helpful for me .......
Sir i just want that i'm working in Sheet 1 and i want that what im working at the same time its automatically copy to sheet 2 there any Easy formula u have then tell me ........
ok take care

Report •

December 12, 2010 at 09:22:36
I already gave you the "Easy formula". =Sheet1!A1, =Sheet1!A2, etc.

However, if you don't want to pre-populate Sheet2 with a bunch of =Sheet1 formulas, you'll need to use a macro.

Right click the sheet tab for Sheet1 and choose View Code.

Paste this code into the window that opens:

Private Sub Worksheet_Change(ByVal Target As Range)
 Sheet2.Cells(Target.Row, Target.Column) = Target
End Sub

Everything you enter into any cell in Sheet1 will be copied to the same cell in Sheet2.

However, once again, I'm sure that there is more to this than you are telling us. I see no point in having an exact duplicate of a given worksheet in the same workbook.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

Related Solutions

Ask Question