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
Go To Solution
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.
About Julio R Boyd
Questions
1
Answers
13
Best Answers
0
  • Posted on -
  • Question Category:
Best Answer
Best Answer
Answered By 65 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.

About Wade S Veith
Questions
17
Answers
102
Best Answers
33
  • Posted on -
  • Question Category:
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:

 

About Reginald E Cosentino
Questions
18
Answers
26
Best Answers
11
  • Posted on -
  • Question Category:

Where is the location of the MS Outlook Emoticon list?

Previous

How to lock mac address

Next

Related Questions