Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: How to import data from webpage (from ajax)

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to import data from webpage (from ajax)
Dear Members, I would like to download data from the following webpage with ajax on that page. http://www.dukascopy.com/tradercontest/?action=liveForecast When I want to download data from page 2, the website does not generate a new web address and one of the great members have already...

Excel Help Forum - Excel Programming / VBA / Macros: Still learning arrays, not sure how to work with a particular range input/edit

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Still learning arrays, not sure how to work with a particular range input/edit
Attached is the demo for a scheduler program I'm nearly finished developing. The final part I'm having to deal with is entering in a particular range of information (the start times and lunch times) from the userform (AddNew) into the active sheet and then using the EditPrior to pull the data back...

Excel Help Forum - Excel General: Complex Batching Problem

Feed2Mail notification - new post on Excel Help Forum - Excel General
Complex Batching Problem
I have a file a 60k excel spreadsheets and I need to figure out a way (if possible) to pull them into a single excel worksheet. I know if push comes to shove I can code this in C# but my company isn't wanting to give me access to visual studio thanks -Jacob

Excel Help Forum - Excel Charting & Pivots: Calculating Weighted Averages in Pivot Tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Calculating Weighted Averages in Pivot Tables
Does anyone know the best way to have a pivot table return a weighted average instead of the standard average? Within the attached spreadsheet I have a pivot tab. I'd like to create a weighted average for the APR. Currently it shows 4.62%. On the data tab I calulated the weighted average at...

Excel Help Forum - Excel Programming / VBA / Macros: Filter one column with multiple checkboxes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Filter one column with multiple checkboxes
Hi excel guru's!! I am in need of some VBA coding that will allow me to filter a specific column with multiple check boxes. For example, I have a worksheet with over 100 rows of data and each row in column B has a month. Can I have check boxes for each month and filter my data based on the...

Excel Help Forum - Excel General: Excel 2010 Slicers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel 2010 Slicers
I have 3 different pivot tables on the same sheet. It's an employee commission sheet. The employee sold policies for 3 different products. On the sheet, it has his/her break down laid out in 3 pivot tables. Each different pivot table is for a separate product, and all 3 pivots are based off 3...

Excel IT Pro Discussions Forum: Excel using Processor but not RAM

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel using Processor but not RAM

When we run Excel 2010 x64 (large calculation) it consumes all of the processor 100% but less than 1% of the ram. How can I force (or firmly request) excel to utilize all of the RAM (24GB) that the machine has available. 

If I add another processor - what settings can I manipulate to let excel utilize multi-core processing?

Windows 7 PRO 64bit, 

Thanks,

SJ

Subscribe to: Posts (Atom)