Updating multiple sheets from a master sheet

Closed
Beenicki Posts 1 Registration date Wednesday 20 March 2013 Status Member Last seen 20 March 2013 - 20 Mar 2013 à 14:27
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 20 Mar 2013 à 19:55
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.

Related:

1 response

Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
20 Mar 2013 à 19:55
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.