multiple sheet workbook

Occasional Contributor

i am working on  a project which requires multiple "Forms" created in Excel. each "form" is one sheet.

i have four separate fields on each form which require data populated from columns in a master data sheet. is there a way i can code this to automatically add the next piece of data from the column without having to code each field as " =('Master List'!D7)" on one sheet and " =('Master List'!D8)"  and so on for each sheet?

1 Reply



With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.


* Knowing the Excel version and operating system would also be an advantage.



Thank you for your understanding and patience



I know I don't know anything (Socrates)