Hi!

I would like too have a pricelist in excel format on the web(webfile),
so that I can give some other people another file which gets the
information from my webfile. so when I change the value(prices) the
prices will change in there files as well when they choose too update.

How should I do that, and how would a formula look like?

Thanks in advance!


Best Regards


ZorroZ


--
ZorroZ
------------------------------------------------------------------------
ZorroZ's Profile: http://www.excelforum.com/member.php...o&userid=22825
View this thread: http://www.excelforum.com/showthread...hreadid=546169

Keep your data table as simple as possible and save it to your website.

In the user workbook, on its own worksheet, create a web query by
using
Data External New web query

In step 2. choose the entire page.

Once the query has been created, right-click on any cell in the query
area and click data range properties for further options.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=546169