Joined: 04 Feb 2005
|Posted: Fri Feb 04, 2005 5:16 am Post subject: creating complex sheet, data from internet and calculating
Need some advice creating a calc sheet with some links to internet and movind data to other cell and calculating data.
- 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"
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.