Pages

Search

Excel Help Forum - Excel General: Wearout Determination

Feed2Mail notification - new post on Excel Help Forum - Excel General
Wearout Determination
I have this solved through some helper columns, but I was curious if anyone can deduce a single formula solution... Basically, I have a piece of equipment that can make 4000 units before it breaks. I have a yearly forecast of units needed. I would like to determine at what time the equipment...

Office IT Pro General Discussions Forum: mailmerge issues with coping excel spreadsheet

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
mailmerge issues with coping excel spreadsheet
i am trying to make a mailmerge with my excel spreadsheet and word document. when i merge the two together, the word document has 12:00:00 AM where it should be blank information. how do i correct that. i have 2007 office

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...