Master Sheet Data
Closed
banjomomma
Posts
3
Registration date
Sunday October 18, 2015
Status
Member
Last seen
October 21, 2015
-
Oct 18, 2015 at 07:51 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 21, 2015 at 02:15 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 21, 2015 at 02:15 PM
I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. The second sheet is sorted numerically by hat number and the person assigned to each hat. The third sheet is just coats and the last sheet is pants. My question is: If Gordon needs to replace his coat, how can I change just the master sheet with Gordon's new coat number and have the value change on the coat sheet just for Gordon?
I have 300+ uniforms I need to keep track of and I don't want to spend a lot of time changing each sheet, each line and risking errors. Thanks for your input.
I have 300+ uniforms I need to keep track of and I don't want to spend a lot of time changing each sheet, each line and risking errors. Thanks for your input.
Related:
- Master Sheet Data
- Master royale - Download - Strategy
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Typing master 11 mod apk - Download - Education
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 20, 2015 at 02:31 PM
Oct 20, 2015 at 02:31 PM
you can use vlookup to pull up the name from the master sheet
Master sheet
A1= "Gordon"
B1=#4 hat
C1=#22 coat
D1=#88 pant.
E1= =A1 (formula to make name also the last column to allow use of vlookup)
Coat Sheet
A1=#22 coat
B1 = VLOOKUP(A1, 'Master sheet'!C:E,2, FALSE)
Master sheet
A1= "Gordon"
B1=#4 hat
C1=#22 coat
D1=#88 pant.
E1= =A1 (formula to make name also the last column to allow use of vlookup)
Coat Sheet
A1=#22 coat
B1 = VLOOKUP(A1, 'Master sheet'!C:E,2, FALSE)
Oct 21, 2015 at 09:39 AM
Oct 21, 2015 at 10:31 AM
1. there is a master sheet where you have all the name, and the assignments of articles
2. for each ariticle, you have a separate sheet
3. you would like each article sheet, to show that name to whom that particular article has been assigned.
Vlookup, is showing the updated information in each article sheet, based on the data on the master sheet
This is how i read your question. Is this not what you seek
Oct 21, 2015 at 01:38 PM
Oct 21, 2015 at 02:15 PM