I would like to know if a function is available.

%3CLINGO-SUB%20id%3D%22lingo-sub-1455100%22%20slang%3D%22en-US%22%3EI%20would%20like%20to%20know%20if%20a%20function%20is%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455100%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%20sorry%20if%20this%20post%20is%20the%20wrong%20format.%26nbsp%3B%20I%20am%20trying%20to%20create%20a%20spread%20sheet%20for%20Tenders%20in%20my%20field.%26nbsp%3B%20I%20have%20a%20drop%20down%20list%20for%20all%20the%20possible%20tenders.%26nbsp%3B%20is%20it%20possible%20for%20when%20one%20item%20on%20the%20list%20is%20selected%2C%20below%20auto%20populates%20from%20another%20tab%20in%20excel.%26nbsp%3B%20I%20was%20hoping%20to%20add%20each%20tender%20in%20the%20drop%20down%20list%20as%20a%20separate%20tab.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1455100%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456744%22%20slang%3D%22en-US%22%3ERe%3A%20I%20would%20like%20to%20know%20if%20a%20function%20is%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695794%22%20target%3D%22_blank%22%3E%40Cameron85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20had%20quite%20a%20few%20views%20since%20yesterday%20and%20no%20responses.%20That%20often%20indicates%20that%20people%20who%20would%20normally%20be%20willing%20to%20help%20are%20just%20confused%20by%20what%20you've%20written.%20I%20know%20I%20am.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20let%20me%20suggest%20that%20you%20upload%20the%20spreadsheet%20you%20have%20(so%20long%20as%20it%20contains%20no%20confidential%20information%3B%20if%20it%20does%2C%20then%20create%20a%20mock%20up%20that%20represents%20your%20situation%2C%20but%20is%20anonymous)%2C%20and%20then%20describe%20a%20bit%20more%20fully%20what%20it%20is%20you're%20trying%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20at%20least%20two%20desired%20outcomes%20so%20far%3A%3C%2FP%3E%3COL%3E%3CLI%3Eto%20select%20some%20item%20from%20a%20drop%20down%20list%20and%20have%20it%20%22auto%20populate%20from%20another%20tab%22....but%20wonder%2C%20%22auto%20populate%22%20what%20exactly%3F%20Getting%20data%20from%20another%20tab%2C%20no%20problem.%20But%20I'm%20not%20visualizing%20what%20you're%20hoping%20to%20accomplish.%3C%2FLI%3E%3CLI%3E%22to%20add%20each%20tender%20as%20a%20separate%20tab%22--is%20that%20what%20you%20want%20the%20selection%20from%20the%20drop%20down%20to%20do%2C%20or%20is%20it%20unrelated%2C%20a%20separate%20task%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20this%20might%20become%20a%20lot%20clearer%20if%20you%20can%20post%20the%20spreadsheet%20you've%20got%20so%20far.%20It%20needn't%20be%20perfect%20(won't%20be)%2C%20so%20we%20can%20see%20the%20setting.%20While%20you're%20at%20it%2C%20what%20exactly%20are%20%22Tenders%20in%20my%20field%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Everyone, sorry if this post is the wrong format.  I am trying to create a spread sheet for Tenders in my field.  I have a drop down list for all the possible tenders.  is it possible for when one item on the list is selected, below auto populates from another tab in excel.  I was hoping to add each tender in the drop down list as a separate tab.  

 

Thank you!

1 Reply
Highlighted

@Cameron85 

 

You've had quite a few views since yesterday and no responses. That often indicates that people who would normally be willing to help are just confused by what you've written. I know I am.

 

So let me suggest that you upload the spreadsheet you have (so long as it contains no confidential information; if it does, then create a mock up that represents your situation, but is anonymous), and then describe a bit more fully what it is you're trying to do.

 

I see at least two desired outcomes so far:

  1. to select some item from a drop down list and have it "auto populate from another tab"....but wonder, "auto populate" what exactly? Getting data from another tab, no problem. But I'm not visualizing what you're hoping to accomplish.
  2. "to add each tender as a separate tab"--is that what you want the selection from the drop down to do, or is it unrelated, a separate task?

 

All of this might become a lot clearer if you can post the spreadsheet you've got so far. It needn't be perfect (won't be), so we can see the setting. While you're at it, what exactly are "Tenders in my field"?