Microsoft excel help needed. please give me solution

Asked By Jake D Woods 30 points N/A Posted on - 04/09/2013

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. 

• Status: Open
• Question Views: 964
• Answer Count: 3
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Wade S Veith

Go To Solution

Answered By Julio R Boyd 0 points N/A #184398

Microsoft excel help needed. please give me solution

 

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

• Vote Up 0 Vote Down

• Posted on - 04/22/2013
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Wade S Veith 65 points N/A #184400

Microsoft excel help needed. please give me solution

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

• Vote Up 0 Vote Down

• Posted on - 04/25/2013
• Question Category: MS Excel

Answered By Reginald E Cosentino 40 points N/A #184399

Microsoft excel help needed. please give me solution

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

• Vote Up 0 Vote Down

• Posted on - 05/01/2013
• Question Category: MS Excel