| If you are having to collate information from different sources into one place, learn about Get & Transform. (It used to be called Power Query in #excel.) It will change your life. Here is an example: Seven spreadsheets, all with some columns in common, but inconsistent column headings, and the need for the client to be able to pull all the common information together. Thank Excel for Get & Transform! Seven connection only queries to link to the spreadsheets and get the required columns consistent. One append query. One refresh button. Saves opening seven spreadsheets, doing seven copy and pastes every time the information needs to be updated. One happy client! |
Custom Spreadsheet Solutions
Productivity – powered by Excel
Menu