Report

Auto populate into a different tab based on cell value

Ask a question Nate - Last answered on Oct 6, 2016 at 06:26 PM by vcoolio
Hello,

My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with differing tabs (titled for each vendor). What I would like to see happen is, I input information (site id, address, PO #, Vendor) into the first master tab. then have a formula/macro take that info and based on the vendor name a populate the info into the corresponding tab by PO #. The trick is to pull information for different vendors to different tabs.


I am trying to do this so it makes everything much smoother. Is there any way to do it without having to key in the PO # in the vendor tab then VLookup everything else? Again I am dealing with a lot of data so creating something like this would be amazing.


Please Advise. Thanks!


See more 
Helpful
+0
plus moins
Hello Nate,

Have a look at the following link:-

https://www.dropbox.com/s/obp4l610rw4yrh8/Excel620%28Master%20sht%20to%20multi%20shts%29.xlsm?dl=0

It is a query I solved for another Poster a few months ago and I believe that it is a similar scenario to yours.

The code associated with that particular work book creates sheets based on Store numbers in Column A and then transfers each relevant row of data to the relevant sheet.

Let us know what you think.

Cheerio,
vcoolio.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!