Obtain data from other sheets

HHave imported a workbook from Ms excel containing 15 worksheets.

how do I access data from one worksheet to another?

iMac, OS X Yosemite (10.10.5)

Posted on Sep 21, 2015 3:54 AM

33 replies

Dhand4711 Author

Level 1

10 points

Oct 3, 2015 8:38 AM in response to Badunit

$D70 is the condition I wish to summarise

Dhand4711 Author

Level 1

10 points

Oct 3, 2015 8:55 AM in response to t quinn

Yes I did not have enough rows in the detail cell.

Have adjusted the formula accordingly and it now works.

Thank you for all your efforts I am very grateful that you stuck at it.

Dhand4711 Author

Level 1

10 points

Oct 3, 2015 8:57 AM in response to SGIII

Thanks for everything you have done.

The last help from t quinn has finally sorted my problem.

I am impressed with the effort everyone has put in, many thanks again.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Obtain data from other sheets