Tag Archives: Vlookup

Excel – Paste a link and Paste Special transpose your data

SharynAvatarBlog120x120Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Continue reading Excel – Paste a link and Paste Special transpose your data

Excel – Using VLOOKUP to compare two lists

SharynAvatarBlog120x120
Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel.

I’ll always remember asking one of the team (a “just-out-of-school” new recruit) what he was working on after I’d observed him sitting with a red biro and a ruler, diligently drawing red lines on 2 separate sheets of paper. It turned out he was trying to reconcile a customer’s account. Continue reading Excel – Using VLOOKUP to compare two lists