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 4479 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.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
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)
0
banjomomma Posts 3 Registration date Sunday October 18, 2015 Status Member Last seen October 21, 2015
Oct 21, 2015 at 09:39 AM
How does this change the data on all sheets? Isn't VLOOKUP just for locating data? I need to change the data on the master sheet and have that change reflected on the other sheets.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 21, 2015 at 10:31 AM
What I got is
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
0
banjomomma Posts 3 Registration date Sunday October 18, 2015 Status Member Last seen October 21, 2015
Oct 21, 2015 at 01:38 PM
I apologize. I am not a skilled excel user. Do I need to add vlookup to every row in my master sheet and every row in my other sheets as well?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 21, 2015 at 02:15 PM
i think if you try what i proposed, you would get a better idea. one learn more from mistake
0