I made Pattern Transfer whilst working with in-flight media data. We worked with hundreds of disparate systems, and often needed to transform data from one to another.
This kind of work was achieved using everything from manual copy/paste to task-specific VBA automation. However, the automation was so specific that there were too many scripts to organise and recall, and this complication obscured the task, limiting understanding and making it difficult to troubleshoot.
Pattern Transfer was made to achieve the intuitive feel of copy/paste but with the power of specific automation. It's designed to be quickly configured each time you open it up so that the exact process is fresh in your mind.
FAQs
- Q: I selected an incorrect field whilst configuring. Can I fix just that one field? A: Yes. Hop over to the config sheet, find the affected field name in column B and look at the cell coordinates in column C/D/E/F. For example, a coordinate of 4_1 means "row 4, column 1", i.e. cell A4. Change the coordinate to that of the cell that you should have selected.
- Q: Can't Power Query do this? A: Yes. Pattern Transfer is faster to learn, and faster to use.
- Q: Why can't I transfer within the same sheet? A: It would be impossible to transfer within sheet because Pattern Transfer uses the active cells (of the source and destination workbooks) as anchor points.
- Q: Why can't I transfer within the same workbook, but from one sheet to another? A: Pattern Transfer could be adapted to work this way, but it would be less user-friendly, since it would be difficult to watch the source and destination simultaneaously.
- Q: How many cells can I transfer in one go? A: The table on the fields sheet has space for 200 field labels; however you can extend the table to up to 1000 fields if required. Keep in mind though, that configuring enormous numbers of fields would be pretty horrible. With that number of fields per record, you might be better off writing some custom automation.