Naming cells using info from multiple nearby cells

Thanks FDibbins, however I'm not sure this helps. I don't need to name a range of cells, I need to name individual cells using a defined nomenclature. The 'name' of each cell could be derived from information in nearby cells e.g. by using a formula - the formula output being the text of the 'name' (nearby cells as formula input). However I cannot work out any way to turn a formula output into an actual cell name.

Thank you for helping Ali

I definitely did upload an attachment, to be sure I have now removed it and attached it again. its named "example for excel forum.xlsx" Here is a screen snip showing what I see...

Hi Ali -did you look at the cell that I have named -they are the grey cells where a response to the question gets filled in. If you look at the cell names that are there you can see how that name is build from info in the surrounding cells.

To use an analogy if I were naming a bunch of cells in a series of novels say the 'name would look something like "Title_chapter_page_element_detail" am I making sense?

I'm really not sure how else to explain it - I'm not trying to do an analysis at this point, just to get all my data collection set up so I can analyse easily later. Think of the spreadsheet like it's a questionnaire (which it is). The questionnaire will be completed every 6 months by the same respondents as they report on their progress. Labeling each cell where they give response will enable easy comparisons as the project progresses and the 6 monthly reports accumulate.

Because the cell names are formulaic - much like a street address - there should be an easier way than manually typing each one.

I'm guessing I'll need to repost this is the VBA group, is there a way to transfer the whole string?

thanks again!

Thanks heaps for moving the thread for me Ali

Thanks Steven - I appreciate your advice.
Even if it's possible to automate part of the cell name it would hep me greatly.
The cells already named were done so manually, and there is a component that is not done by algorithm - however that can be changed!
Frankly even if I could get part of each cell name done automatically it would save me a huge amount of time and frustration.

Please consider cell D10 (I've pasted an image in for convenience - it's from t same as the attached workbook)
I've colour coded the components of the cell name and where they come from on the work sheet (CH is the first two letters of the name of the Sheet - not shown).
The only part that could not be derived by algorithm is the fewest pertinent words to describe the metric "Number of potential clients provided education and tailored client advice."
I could change this easily change this - it could instead be the first 3 letters of each word e.g. "Num_of_pot_cli_pro_edu_and_tai_cli_adv"

tempsnip.png

Perhaps you could also advise me on the best way to set up for analysis in the future: should each cell name cell also include a reference to the data reporting period (which is every 6 months).
As the data comes in I'll need to look for trends and relationships and graph change over time (time being the reporting periods).

If that last bit is too basic - perhaps you can point me to recommended resource and I'll educate myself. I've not been able to find something sufficiently detailed but not overwhelming.

Again thank you!

Thanks swaatacba

That is disappointing, the example shown is just a small portion of the the entire spreadsheet which mostly still needs to be done, and then becomes the template for annual use.

That there is no simple way to automate the naming of cells explains why I can't find appropriate training resources.

I appreciate the time you've taken to consider this for me.