Previous Topic Next Topic

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.

Related:

1 response

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
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