It is useful sometimes to read a worksheet line-by-line and selectively take data from it. An example below shows how to do this. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not,...
Read more »Excel can do virtually anything; whether it should be made to do everything is another matter. While the spreadsheet is very powerful in manipulating data, it isn’t too great at storing normalised data. Harnessing Excel to a relational database like...
Read more »It is easy for you to sort data in a range in the worksheet. Furthermore, now you can also sort data in a column chart by the 2 effective methods that are introduced in this article. When you demonstrate data and information in a column chart,...
Read more »