Search results

Hi, I'm currently preparing some code that generates 200 reports automatically. There's just one problem i can't solve. I've got my "master" template all set up with page breaks, and at the end of the line it's saved to PDF (Yuck, PDF. don't shoot me, it's how they want it :) ). The problem...

Hi, I've decided to switch out my pencil&paper tracking of my power consumption at home to a digital version. This is a personal project so no pressure, but still, I wouldn’t be myself if I didn’t try to push my Excel software to the max :) I have some idea’s with time filters, comparisons...

Hi, I'm trying to add a portion of a worksheet to a userform with the hopes of manipulating it (pleast note, this will be used in powerpoint etc as well, so I cannot rely on excel solely, hence the reason why I need a worksheetlike table on a userform). I have googled plenty and saw that...

Hi, Can anyone help me to figure out how to make bar charts (so bar's going up vertically) with rounded tips? example here : http://blog.visual.ly/wp-content/uploads/2013/04/rounded-bars.png?547b7b Am using office 2010. I tried different methods (error bars, secondary chart with dots, ...)...

Hi, I'm looking for a way to do a vlookup for a partial of the text. example lookupdata: COL A |ColB Store 1 |Belgium Store 2 |UK Store 3 |Netherlands so then i'd like to place a vlookup in the data below to find the store location (col B) COL A |ColB XXXXX Store 1...

Just curious, and hoping to draw more inspiration to add to my existing add-in: What are your most used / handy / ... VBA functions, userforms, macro's, ... ? example: My most handy piece of code is my personal Add-in. It has many features I use daily, one of which is a selection rotator...

Hi Guys, I'm working on a VBA code to generate reports. It works great, but it's slow... I've read the "speeding up" part of this page (and many more) but still, it's slow... My main obstacle for speed seems to be the lookups over different sheets (the report uses 3 sheets, that are filled...

Hi Y’all, I’m a fresh father (5 months and counting YAAAY) so logically, my first thought is: How do I get my child started with excel asap! So I figured I’d write a cool VBA script that makes stuff happen :-) Here’s the contest (no prizes other than the warm fuzzy feeling for bringing...

Hi, I've just created a vlookup UDF using the excel find function. I wanted to find a way the use vlookup to find columns BEFORE the column where the data is in (Vlookup only works to columns behind the data column). I allready had a UDF for this, but it was extremely slow and volitile. This...

Hi, I'm tryin to find the best/fastest VBA method of find and listing unique value's. the first bit and end bit will be implementend in my current VBA, but basicly the idea is: - A list of approx 8000 cases will have to be processed - there will be around 100 unique values with variating...