Hello Excel Forum,
I'm a new member to the site. Thank you for considering my question.
I'd like to populate "baby worksheets" from a "master worksheet" as seen in the attached example. I'd like the population to be done by matching the Row and Column headings.
For example, in the contact worksheet, I'd like the empty cells to automatically update themselves from the master sheet based on the column titles (First Name, Last Name etc) and the Row heading (1, 2, 3, 4 etc.).
The master sheet will be changed frequently and I'll likely need to add columns as as I go (which is why I'd like population to match by column title). I'm looking for an elegant solution and would prefer a formula because I have no experience with Visual Basic or Macros.
~Thank you for the help
Example.xlsx
Bookmarks