![]() ![]() You will want these macros to be available whenever you open Excel on your computer and regardless of which worksheet you access. To speed up the process I headed to VBA to solve the problem macro-style! ![]() For those fortunate enough to find themselves in this position, Microsoft has provided us with “ Paste Values” and “Paste as Text” to streamline the folly that can be formatting formulae, hyperlinks, etc, etc…īoth of these features can save the user a lot of time – especially if you use Excel all day like me – the only problem being that when you’re pasting hundreds of tables / cells / rows of data an hour clicking through menus is not an ideal practice. For anyone who works in analytics (or uses Excel more specifically) moving data from various sources into Excel can be a frustrating and arduous process. ![]()
0 Comments
Leave a Reply. |