First Sheet,Same Data Second Sheet Automatically

[leitethomas26]

Hi..
I want to ask something because i am not sure if can work....

I have create a file in Excel....
In first sheet i have 4 columns that take data from a database...
I also use a macro button that refresh the data when user hit on it....

Now i wanna ask something in that case and general for excel....
When i make some changes in first sheet (sheet1) i wanna do the same in sheet 2 automatically....

For example if i type in a cell in first sheet a value i want excel do the same in second sheet... Can this happen??????? How i can do that????? Any ideas???

Thanks in advance for your help

[mubashir aziz]

You can paste code in 1st sheet to copy data in 2nd sheet ... so whenever u'll make any change below macro will run ....

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

[leitethomas26]

Hi
Sorry i didnt get you....Can you explain little more.... I have already one button in first sheet... I want my second sheet clear from buttons just have the data from first sheet... Can you give me some steps??Do i need to write code? I dont wanna do again button with macro because its the same

[mubashir aziz]

you can call below macro in ur first macro which is using to bring data from other sheet mean just call clear_sheet2 macro start of ur 1st macro which will firstly clear 2nd form then copy the data from sheet1 to sheet 2 .....

Sub ClearSheet2()
'

' If you are on Sheet 1 and want sheet2 contents clear then please call this macro in First button
' macro


Sheets("Sheet2").Select
Cells.Select
Selection.Clear
Range("E8").Select
Sheets("Sheet1").Select


End Sub

[leitethomas26]

Hi again....
I wrote that code in my button in first sheet and doesnt work... i think i do something wrong... In this button i had only record the process of refresh.. Can i use the same button to copy the data to second sheet??????

[leitethomas26]

Can you give me exactly the steps so to be sure i do the same thing???
Sorry for disturb you again

[mubashir aziz]

My code is only refreshing the data of 2nd sheet ... can you attach the file with your requirements so that i can check it out .....

[Hein]

Maybe the easiest way to do this is by selecting both the 1st and 2nd sheet simultaneously

Any changes you make in the 1st sheet will automatically be made in the 2nd sheet


And maybe another sulution is to do your thing in the 1st sheet and than copy it

Hope this helps
Hein