Copy Cells to Different Sheets based on a criteria column

Hi,

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.

Here goes:

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!

Hi JBeaucaire!

Many thanks for the link. In a world where all my vendors accept the same format, I could make this work. However, they all want a specific format for the reports, that's why I only want the reference number in the left most column copied over to their respective sheets. Is there a way I can modify this to just copy that?

Cheers!

I'm guessing this bit is for the copying:

Please Login or Register  to view this content.

What edit should I make to make it copy just the left most cells?

Cheers!