Just recently joined as I've been struggling to find information on how I can optimise my daily workflow. I've been searching on google and other forums for a few days now and couldn't find any workable information for what I'm trying to do.
Basically, I manage Purchase Orders for different Vendors. From our SAP System, I can extract a table with the purchase and vendor data I need. I then paste into a "SAP Import" sheet in my template to begin my work.
In the leftmost column, there is a reference number that I need to be copied and pasted to the leftmost column of different existing sheets based on the vendor number in the 5th column.
The sheet names correspond to the Vendor Names. I also have another sheet "Vendor Master" where the vendor numbers and names are listed. The vendor sheets are named exactly as what I have in "Vendor Master".
At present, I filter the Import sheet and copy and paste the visible cells for each vendor one at a time to the vendor sheets. I've already set up the vendor sheets with vlookups as each vendor requests varying sets of information in various formats. It's taking a huge chunk of my day and leave me little to no time left for my other tasks.
Ideally, I'd want VBA code that I can run off of a module.
Many thanks to anyone that can contribute!
PS: I am just starting to read up on VBA and Macros so hopefully I'll be able to "pay it forward" in the near future!