OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

creating complex sheet, data from internet and calculating

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ta22
Newbie
Newbie


Joined: 04 Feb 2005
Posts: 1

PostPosted: Fri Feb 04, 2005 5:16 am    Post subject: creating complex sheet, data from internet and calculating Reply with quote

Hello,
Need some advice creating a calc sheet with some links to internet and movind data to other cell and calculating data.
Scenarion;
- I would like to copy some data from internet page to one sheet and update it cintinuously
-then have an another sheet where I would do some calculations based on one information in sheet where internet data.

Sheet B: Internet page link, data in table mode.
A B C D
Name "changing data which I need in sheetA"

SheetA
A B C D E

Name from sheetA Count "X" Fixed number =B*C =SheetA;B * SheetA;B

I would need to have automatic Value from SheetB Column B (the changing data) to the SheetA Column E and have calculation B*E.

Also would be nice to have function to search this data in ColumnE based on name in ColumnA

I have tried to use VLOOKUP but I didn't know how.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group