Microsoft excel help needed. please give me solution

Asked By 30 points N/A Posted on -
qa-featured

Hi experts,

Please help me i want to make a spreadsheet and i want to make column which will get the data from a website.

means i want that i have a list of products with prices on internet. I want to make spreadsheet which will update the prices in excel sheet automatically if i change the price on internet. 

SHARE
Best Answer by Wade S Veith
Answered By 0 points N/A #184398

Microsoft excel help needed. please give me solution

qa-featured

 

You can create that type of spreadsheet by following these steps:
1. Go to Data Menu.
2. Check for a tab named get external data
3. Click on From Web.
4. Now enter the address of the website.
5. Use the arrow button to select the data.
Best Answer
Best Answer
Answered By 60 points N/A #184400

Microsoft excel help needed. please give me solution

qa-featured

Hi Jake,

In order to solve your problem, grab a copy of Share Trade Tracker Pro online. It has combined the most powerful excel spreadsheets. You cannot bring it anywhere. It is not free.

With just a click of a mouse, price list of products are automatically updated by the use of this software.

Go to download page, by clicking it here.

Answered By 40 points N/A #184399

Microsoft excel help needed. please give me solution

qa-featured

Hi,

First of all, follow the link:

Automatically Update Excel 2013 Spreadsheets with Online Data

To get necessary guideline for your work. Here are some pictorial representation of your requirement:

 

Login/Register to Answer

Related Questions