Hope, hope, hope the answer is yes and you can share your excel knowledge. I am new in my role and struggling but came up with an idea the team liked so feel I have a chance to prove myself. The idea uses conditional formatting to answer questions and then join the answers to make a file name. I can answer the questions but can't join all the answers. Please can anyone help, I am quickly deciding I hate excel! Or is there another way to do this ?
MoltenLasagne · 15/05/2023 09:58
If you want the file to just suggest the file name you can use concat to propose it.
E.g =CONCAT(A1&A2&A3) just joins whatever is in those cells together
Or =CONCAT(A1&" "&A2&"_"&A3) will join A1 then a space, then A2 then an underscore then A3
If you want the file to take cells and autosave with a file name then that requires vba.
To comment on this thread you need to create a Mumsnet account.