As I have much more time in this lockdown, I'm trying to write from scratch some Excel workpapers for my company to use. As a fairly novice Excel user, so bear with me…
My first request for help, is how do I set up a sheet as a tailoring checklist, that will then generate other sheets or hide them as necessary?
E.G. – Q1 would be “does the entity have any assets?”. if I answer yes from the data validation I've set up, it generates:
A subsequent series of questions in the sheet about E.G. “Does the entity own a motor vehicle”, with yes/no answers,
2) Once these have been answered, other sheets in the document that can be edited for the specific details of E.G. motor vehicles. For example, A1 a lead schedule of all assets, A2 a breakdown of motor vehicles owned where the vehicle can be detailed as necessary.
There is probably a guide on Excel for this, but I have no idea what you call this function, so can't find it on a search
This thread is archived
New comments cannot be posted and votes cannot be cast
You can't do this with functions, it will need to be with VBA
Op · 1y
OK – how do I do that/is there a guide link you could send me please?
Continue this thread
To dynamically display the next question, you can
Create the Question Lookup Table
Lookup the next question based on the answer to the last question
Similarly, you can create dynamic content by
Create the content Lookup Table
Lookup the relevant content based on the answers in the questionnaire
Hope This Helps!
View Entire Discussion (6 Comments)
More posts from the excel community
Continue browsing in r/excel
Discuss and answer questions about Microsoft Office Excel and spreadsheets in general
Formulas being written
Created Mar 11, 2009
Top posts april 1st 2020Top posts of april, 2020Top posts 2020
helplingocard.vn Applingocard.vn coinslingocard.vn premiumlingocard.vn gifts
Back to Top