What we were looking to do is to make two dependent worksheets a kind of dynamic list of names that would auto-populate according to a ("YES")condition set in the primary worksheet. This way, we would never have to update any sheet other than the primary worksheet.
We were told we may need to inour an INDEX function.... would love to set up a 15 min session to go over the document we need to do this with...thank you!
11 freelanceria on tarjonnut keskimäärin $26 tähän työhön
I am very well versed in excel and have experience in linking data across different workbooks and worksheets. I am also knowledgeable in different functions of excel.