Need help making a script

Question

Can someone help me make a script that combines any runoff names (for example how row 672 has a longer name that leaks into column D) into the appropriate cell in column c?and is it possible for a script to scan the worksheet and do it to any names that look like that?

hansvogelaar · Answer

Kevinmax&nbsp;
Does it need to be an Office Script or would VBA be OK?
&nbsp;
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

kevinmax · Answer

HansVogelaar&nbsp;Office script if possible.&nbsp;https://docs.google.com/file/d/10D4Kkz6Cik5IxLSeOeIRNPBK1Gf_ypdu/edit?usp=docslist_api&amp;filetype=msexcel

hansvogelaar · Answer

Kevinmax&nbsp;
&nbsp;
I get Access Denied...

kevinmax · Answer

HansVogelaar&nbsp;sorry it’s my first time sharing like this&nbsp;https://docs.google.com/file/d/10D4Kkz6Cik5IxLSeOeIRNPBK1Gf_ypdu/edit?usp=docslist_api&amp;filetype=msexcelhopefully this works&nbsp;

hansvogelaar · Answer

Kevinmax&nbsp;
Thanks, that works. I hope that someone else can create a script for you based on that workbook.

Forum Discussion

Need help making a script

Share

Resources