Excel Tailoring Vietnam Company Limited Cr0004539, Nguyen Phuong

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

Xem thêm bài viết thuộc chuyên mục: Excel