User Profile
MattChisholm
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Auto-populate worksheets from a source worksheet based on data input
Hi MS Tech Community, I have a dilemma that I have been trying to search a solution to for quite a while. I manage a massive inventory of cannabis excise tax stamps. I am constantly issuing thousands of stamps for multiple work orders across multiple provinces everyday. My tool for tracking all these transactions is Excel. My question is in regards to auto populating multiple tabs across a workbook based on data inputted into a source sheet. I know how to use the formula based option however that is more work than I really want to spend time doing. Can I assign specific columns to recognize the data and correlate that information to the correct tab and column in the dependent work sheets? Example. Date Province Line W/O Number Issued Used Damaged Unaccountable Returned 1-Jul British Columbia Pre-Rolls 1502641 902 888 14 0 0 1-Jul Nova Scotia Pre-Rolls 1502642 297 288 9 0 0 1-Jul Alberta Pre-Rolls 1502630 5,419 1,680 6 -6 3,727 1-Jul Newfoundland Pre-Rolls 1502638 2325 1200 17 0 1108 1-Jul Manitoba Pre-Rolls 1502639 3,531 1,200 3 +1 2,329 1-Jul Quebec Pre-Rolls 1502640 1,678 1,200 8 -2 468 I would like to be able to have column B (Province Column) recognize 1 of 10 tabs. If I type in Newfoundland it will recognize to populate the information into the Tab that's titled NFLD. Then have the information from column D (W/O #) auto-populate the W/O cell in the dependent NFLD tab. The same of Column E (issued) and I (returned). Essentially the top row of the dependent province work sheet will have the complete inventory amount for that province and as I populate the source sheet, I would like the dependent province sheets to auto-populate and keep track of the inventory automatically. Is this something that is possible? Any tips or tricks would be greatly appreciated. I have attached a test copy of the work book. Much Thanks Matt4.8KViews0likes5Comments
Groups
Recent Blog Articles
No content to show