User Profile
J_How
Copper Contributor
Joined Jun 09, 2020
User Widgets
Recent Discussions
Linking data across worksheets
I'm sure this question has been addressed many times in different forms. So if someone has a link to direct me to, please help. I have not found anything to explain what I would like to accomplish directly. What I'd like to do is link data from a master list to multi sheets of the same workbook. Here's the set-up. The master list is an inventory list comprised of part #, type, description, and price. These parts are used in different sheets to catalog inventory for different things. What I want to accomplish is this: I want to link the master so that if I update anything (mostly frequently the price) it will automatically update across the entire workbook. I understand I can match cells. However if I update the master list with another part and that adds a new row, this changes the cell destination. Ideally I want to create it in a way that revolves around the part number. If I add a part number or change the price of an existing part number, it will update on any other sheet that utilizes that same part #. Is it even possible to link multiple columns for the same row. example : part # type description price 12345, misc. electric, on/off switch, $12.00 If I create a new table on a different sheet and input part # 12345 into one cell it will fill in the columns in the row with the linked data, that way anytime I update the master it syncs everywhere that part # is used.960Views0likes2Comments
Recent Blog Articles
No content to show