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,
and;
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
Thanks!
Đang xem: Excel tailoring vietnam company limited cr0004539
6 comments
share
save
hide
report
72% Upvoted
This thread is archived
New comments cannot be posted and votes cannot be cast
Sort by
top (suggested)
level 1
· 1y
1
You can't do this with functions, it will need to be with VBA
1
Share
ReportSave
level 2
Op · 1y
OK – how do I do that/is there a guide link you could send me please?
1
Share
ReportSave
Xem thêm: Tuyển Tập 30 Đồ Án Tốt Nghiệp Tu Dong Hoa, Đồ Án Tốt Nghiệp
Continue this thread
level 1
· 1y
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!
1
Share
ReportSave
View Entire Discussion (6 Comments)
More posts from the excel community
Continue browsing in r/excel
r/excel
Discuss and answer questions about Microsoft Office Excel and spreadsheets in general
365k
Spreadsheet Warriors
926
Formulas being written
Created Mar 11, 2009
Join
Top posts april 1st 2020Top posts of april, 2020Top posts 2020
helplingocard.vn Applingocard.vn coinslingocard.vn premiumlingocard.vn gifts
aboutcareerspressadvertiseblogTermsContent policyPrivacy policyMod policy
Xem thêm: bài tập giới từ chỉ vị trí trong tiếng anh
Back to Top