How to update single data in different sheets

[satish12]

Hi,,

How to update data that is in a table in sheet1 and the same data should appear in table in Sheet2 without copying and pasting.

For Ex:-

Sheet 1

the table contains Cost =1000

And this cost should also appear automatically in sheet 2 Cost =1000 table when ever some changes are made in Sheet 1.

Also please let me know if data can be updated in different Work books and not work sheet.

i,e. Can i update data in one work book and that data should be changed or reflected in a different workbook..

Thanks for the reply in advance.

[kadghar]

Hi,,

How to update data that is in a table in sheet1 and the same data should appear in table in Sheet2 without copying and pasting.

...i,e. Can i update data in one work book and that data should be changed or reflected in a different workbook..

Thanks for the reply in advance.

yeap, remember you have a list of workbooks and of worksheets for each workbook. Lets say you have Book1 and Book2 and each one has Sheet1 and Sheet2

so if you want to put "hello" in the cell A1 or the first sheet of Book2 just do something like:

workbooks("Book2").worksheets("Sheet1").cells(1,1) .value = "hello"

well HTH

[satish12]

yeap, remember you have a list of workbooks and of worksheets for each workbook. Lets say you have Book1 and Book2 and each one has Sheet1 and Sheet2

so if you want to put "hello" in the cell A1 or the first sheet of Book2 just do something like:

workbooks("Book2").worksheets("Sheet1").cells(1,1) .value = "hello"

well HTH

Hi,

I am sorry but i dint get that,


Well first lets take only 1 work book thats, for ex:- there are 3 sheets if i update any data in sheet 1 the same changes should take place in sheet 2. As i told previously if the a Sheet 1 Cell A1 =1 then it should update in cell A1 = 1 in sheet 2 spontaneously.

Thanks in advance

[mcreary]

Easily, if it is not a complex workbook or worksheet you could copy the cells on spreadsheet 2 and paste special, then paste link on spreadsheet 1 in the cells for update, then when you make an entry on spreadsheet 2, it will automatically update spreadsheet 1.

Hope that helps.

[kadghar]

Hi,

I am sorry but i dint get that,


Well first lets take only 1 work book thats, for ex:- there are 3 sheets if i update any data in sheet 1 the same changes should take place in sheet 2. As i told previously if the a Sheet 1 Cell A1 =1 then it should update in cell A1 = 1 in sheet 2 spontaneously.

Thanks in advance

That was the syntax to make reference to any cell, now if you want the changes to take efect when you change the cell, write the code in the sheet's change event, try this little example

Lets say you have sheet1 and sheet2, go to the vba editor, and 2ble click on
sheet1, then write something like:

Private Sub Worksheet_Change(ByVal Target As Range)
    worksheets(2).cells(target.row, target.column).value = target.cells
End Sub

so when you change the value of a cell in sheet1, the same cell will be changed in sheet2.

HTH