By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,642 Members | 2,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,642 IT Pros & Developers. It's quick & easy.

How to update single data in different sheets

P: 5
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.
Dec 10 '07 #1
Share this Question
Share on Google+
4 Replies


kadghar
Expert 100+
P: 1,295
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
Dec 10 '07 #2

P: 5
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
Dec 11 '07 #3

P: 4
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.
Dec 11 '07 #4

kadghar
Expert 100+
P: 1,295
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:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.     worksheets(2).cells(target.row, target.column).value = target.cells
  3. End Sub
so when you change the value of a cell in sheet1, the same cell will be changed in sheet2.

HTH
Dec 11 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.