I shudder at the sight of merged cells in a spreadsheet. Sure, they may make Excel scorecards look neat and pretty... They also make them a pain to maintain since merged cells interfere with sorting and pasting as values There's nothing more annoying than being unable to paste as values on top of cells that … Continue reading How Do I Quickly Un-merge cells with VBA?
Do you want to analyse what people say about your product on Amazon Marketplace? • Or the reviews that people leave on your Facebook page? Not a problem! You can do some basic sentiment analysis with VBA! As an example, I'll be analysing 1000 fine food reviews posted on Amazon. Since I am mostly interested … Continue reading How Can I Colour Individual Text in a Text String with VBA?
Indeed, VBA could be a super handy way of applying some conditional formatting on your data. It has couple of advantages over the Excel built-in conditional formatting: • It is more robust - cells additions or deletions are much less likely to cause unnoticed shifts in conditional formatting references • It does not bloat your … Continue reading How Can I Colour cells with VBA?
Being a Reporting Analyst for a huge enterprise often means that there might be no single centralised data warehouse where all enterprise data resides but rather a number of business intelligence systems, each of which tackles a different set of business operations data. Thus, you get one system for your sales analysis, another for P&L … Continue reading How Do I Quickly Re-state Values with VBA?