Hello,
I need help please creating a "Document Builder" type spreadsheet.
The idea is that sheet 2, "Predefined Data Formats", contains predefined data tables /named ranges.
The user will only use the "Document Builder", sheet 1, to build a document.
Every cell in Column A on "Document Builder" sheet has the same data validation list drop down which is a list of predefined tables from sheet 2.
The idea is that the user selects which predefined table he wants inserted in to the document from the drop down in column A.
Excel automatically pastes that table into the document.
Then further down in the document the user selects another table to insert into the document and so on.
So the logic would work like this:
There would be predefined tables or named ranges on sheet 2.
Sheet 1 A1 would have a drop down list of all the tables on sheet 2.
When A1 on Sheet 1 is changed to the value "TOP" the "TOP" Table from sheet 2 will be pasted into cell B1.
I got example jpgs but cant get them to attach properly.
s1.jpg
Bookmarks