Previous Topic Next Topic

Master Sheet Data

Closed
banjomomma Posts 3 Registration date Sunday 18 October 2015 Status Member Last seen 21 October 2015 - 18 Oct 2015 à 19:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 21 Oct 2015 à 14:15
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Oct 2015 à 14:31
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)
banjomomma Posts 3 Registration date Sunday 18 October 2015 Status Member Last seen 21 October 2015
21 Oct 2015 à 09:39
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.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 Oct 2015 à 10:31
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
banjomomma Posts 3 Registration date Sunday 18 October 2015 Status Member Last seen 21 October 2015
21 Oct 2015 à 13:38
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?
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 Oct 2015 à 14:15
i think if you try what i proposed, you would get a better idea. one learn more from mistake

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response