How to make data in one workbook appear automatically In another

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

Guest

Hello

I have two seperate workbooks that need to have the same data in them. Is it
possible to enter the numbers in one workbook and have them automatically
fill in the other workbook?
 
not understood. do you want the same number even if you change in one
workbook. in that case copy -pstespecial-pastelink.

try some experiments.
 
Thanks for the reply
I want to have a number that I enter in one workbook to update in the other.
For example: if the number I need in the first book is 100 I want to be able
to enter this number in the first book and have it fill in on the second
book. If the next week the number is 200, I want to be able to change it in
the first book and have it update in the second book.
I am a bit of a novice--Not sure what "pstespecial-pastelink" means.

Thanks in advance for your help
 
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

Excel Protection 2
Linking data from one worksheet to another... 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Highlighting duplicates 0
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
hiden cells copied automatically to another workbook, can I stop . 2
auto populate unused rows from workbook to workbook 1

Back
Top