Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2014-02-13 04:11:15 +0200

ROSt52 gravatar image

I would do following:

Name area in spreadsheet 1
Open spreadsheet 2
Click at location of the top left corner of the area in spreadsheet 1
Insert > Link to external data (not hyperlink!)
in window URL of external data source click brows buttion (...) and select spreadsheet 1
available areas are listed, thus select
select update time on the bottom area
click OK
area of spreadsheet 1 is visible in spreadsheet 2 and data in these cells can be used for processing in spreadsheet 2