Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #734 Sep 05, 2012 www.energyefficientbuild.com.
user jjspierx said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/KUrDGzDtC_A)
Export 2 sheets in same spreadsheet as web pages - I can only get one to export
....
I have two worksheets that have linked data. I would like to be able to publish both sheets to embed on a website, on 2 different pages, but only the most recently published page linked works. So I can't just hide an sheet, as I need the info from both sheets. And I can't separate the sheets into two workbooks, because I am linking data between the sheets. Is my only option here to have the data combined onto one webpage? This would be highly undesirable, but if need be, I guess that is what I will have to do. I was hoping somebody else had another idea that would allow me to display the data from both worksheets separately on 2 different web pages.
Thanks in advance for any suggestions anyone has to offer.
----------------------------------------------------------------------------------------
following is a solution to the problem
and here is Sheet2 -----------------------------------------------------------------------
No comments:
Post a Comment