Updating multiple sheets from a master sheet

[Closed]
Report
Posts
1
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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.