Updating multiple sheets from a master sheet

Closed
Beenicki
Posts
1
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
- Mar 20, 2013 at 02:27 PM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Mar 20, 2013 at 07:55 PM
Hello,

Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and therefore require an efficient way to do so.

1 reply

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
70
Mar 20, 2013 at 07:55 PM
Hi Beenicki,

By the expression "mapping between multiple sheets" if you mean "Lookup" or getting information from one sheet to the other using a fixed value in one column or row, you can use Microsoft Excel's VLOOKUP() worksheet function for this. Please check the below mentioned link for details about this worksheet function:

https://ccm.net/faq/12503-how-to-use-the-vlookup-function-on-excel

Please revert for clarification.
0