how to type in 1 workbook & automatically insert in another book?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I am trying to create account balances and I have two different
worksheets. How do I type information in one worksheet and automatically have
that information inserted into the other work sheet with the same values
without copying and pasting a link?
 
It probably depends on how many cells you need duplicated and whether you
have a standard set up or whether it will change often but if you go onto the
2nd sheet and insert the address of the cells from sheet 1 in sheet 2 you
will get the results automatically in sheet 2.

For example if you want to enter data in A1 of sheet 1 and have it show up
in A1 of sheet 2 you would double click on A1 of sheet 2 and enter =Sheet1!A1
(Or you can double click the cell enter = and then click on the cell in
sheet 1 and hit enter, that will stick the address in for you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Linking data from one worksheet to another... 2
information automatically changes 2
HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET 1
Relative worksheet reference for multiple worksheets in a workbook 5
move worksheet to end of another workbook 3
Working with worksheets in the same workbook 1
Formula, Macro, or VBA code to find and insert 3

Back
Top