0
votes
0answers
18 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
1
vote
2answers
73 views

Importing an XML file into excel

I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows. Is there any way I can ...
2
votes
3answers
3k views

Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
4
votes
1answer
259 views

Excel - including data from a remote (web) sheet?

As a part of providing dynamic dashboards / reports, I've been investigating having a static Excel workbook that would contain a raw data sheet periodically updated from a web source. I'm currently ...
2
votes
1answer
285 views

Import data in Excel that doesn't have a row delimiter, but number of columns is known

So i have this text file that looks something like this: Header1 Header2 Header3 Header4 A1 B1 C1 D1 A2 B2 C2 D2 and so on. When imported, I'd want the data to format itself in 4 columns. I ...
1
vote
0answers
122 views

Ms Excel 2010 Importing Data in One ROW and getting sum particular CELL

I am importing data by using .txt file to MS Excel and whole data is imported in ONE ROW. I want to get SUM of those values which corresponds to a particular Month. For Example :- Name Month Total ...
1
vote
1answer
382 views

Excel 2010 on importing Access datasource: Can I just dump the data into the worksheet without maintaining a connection to the Access table?

I am able to successfully import an Access .accdb table into my Excel 2010 worksheet. However, it still seems to maintain a connection to the data. This is an inconvenience for me because I have to ...
3
votes
1answer
2k views

Importing external worksheet data into Excel 2010 workbook

Is there a way within an Excel 2010 workbook to link data stored in a specific tab of an external workbook, and have it update automatically in the same way as you can with data imported from CSV, ...
2
votes
1answer
175 views

Excel Help: Data Input Help

Everyday I download data from a site that will have rows each filled with individual data for clients. I'm able to input the data into excel as a whole but after that I'm having trouble figuring out ...