Report

Automatically populating other sheets based on a certain range

Ask a question Boone Treitz - Last answered on Jun 9, 2017 at 04:26 PM by ac3mark
Hello,

I'm making an Inventory workbook for a small manufacturing company I am assisting over the summer, and I've run into a problem.
On the first sheet "Inventory" I input information into various columns (i.e. Date, Farmer, Buyer, Location, Produce, Farmer Unit, Farmer Total, Buyer Unit, Buyer Cost, Profit, Payment, Payment Date [In this order]) for all of the companies inventory for that year, on a table that goes from (B3:N3), and on down for every entry. One of the columns in the table is labeled "Farmer" and refers to who the produce was purchased from. There are currently 9 farmers that the company deals with on a regular bases in this workbook.

What I would like to do, is have each individual farmer's sheet automatically populate with data when it's inputted onto the main "Inventory" sheet, and have it based on the Farmers column in the table. So basically, if the sector says "James", I would like for the entire row to be transferred to the sheet "James". And so on for each individual farmer. As the more entires for that specific farmer is inputed into the main "Inventory" sheet, the Farmers sheet inputs that information in the row below the one before.

That way I don't have to copy and paste the hundreds of transactions to individual pages manually.

I also what the main "Inventory" sheet have a autofiltering and a continuous table as entires are inputed.

Any tips or suggestions?


Helpful
+0
plus moins
Use a Database, not a spreadsheet!
Boone Treitz- Jun 8, 2017 at 09:39 AM
What is a good and free database
Reply
Leave a comment
Helpful
+0
plus moins
Open office is a good suite of business applications.

Take a look:https://www.openoffice.org/

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!