Solved how to transfer data values between spreadsheets

March 26, 2015 at 08:45:56
Specs: Windows 8
is it possible to transfer data values from one spreadsheet to another - if numerical date is entered in one spreadsheet - can it be automatically transferred to another one?

See More: how to transfer data values between spreadsheets

Report •

#1
March 27, 2015 at 03:12:11
It has been possible since the DOS days. How it's done depends partly on what program you use. The example below is for MS Excel 2003.

http://www.exceldigest.com/myblog/2...

Nigel

Wind slow


Report •

#2
March 27, 2015 at 04:20:45
✔ Best Answer
It depends on what you are trying to do. More details would help.

A simple formula can accomplish your goal.

If you put this formula in a cell on any sheet in the workbook, it will always reflect what is in Sheet 1 cell A1

=SHEET1!A1

There are many other ways, but we would need more details before we could offer other suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question