I have an excel workbook that has a Master Job spreadsheet, Current Job spreadsheet and sheets A-Z that I use to track jobs by job number as well as by customer. I am currently copying and pasting information from the "Master Job Sheet" to sheets "A" - "Z". It is way too time consuming.
I am looking for a way to avoid copy and paste and only have to type the information in once to the Master Sheet and have it automatically update to the coresponding alphabetical sheet in the workbook.
Can I use a macro to copy information from one sheet to another