Copy Sheet information to a second sheet- dynamically

[electrichi01]

Hi

I'd like to take the details from one sheet and pull over all of the data to a second sheet and keep all of the formatting as well as keeping the data dynamic- when it gets changed on sheet 1, it transposes the changes to sheet 2.

I know I can do the -sheet1! - reference to get the data over to sheet2, but there are lots of data and formatting in sheet 1.

I've tried to cut and paste special- and it does bring it all over, formatting wise, but it doesn't change the data if it is changed dynamically on sheet 1.

Any suggestions or solutions?

Thank you

 

[bensonsearch]

HI,
The only thing that comes to mind would be to use the sheet module in vba with the change event (can specify what rang and once it is changed will do something).

this would be the below proceedure

Private Sub Worksheet_Change(ByVal Target As Range)
 
    MsgBox "You just changed " & Target.Address
 
End Sub

 

[electrichi01]

Hi

Appreciate the response, but its a little over my head.....

Can you give me a 2nd grade education first?

Thanks

 

[bensonsearch]

HI,
May be best to have a read of this page

http://www.ozgrid.com/VBA/run-macros-change.htm

explains the different things with it.