En cours

Create an Excel Macro to convert string text into formulas

I need a simple macro written to help us convert a string of text into a formula. For example, I have the following string of text in cell B1:

'S:\POSITION DASHBOARD\_ARCHIVE\[[url removed, login to view]]Positions'!C42

and I need this converted and treated as a formula:

='S:\POSITION DASHBOARD\_ARCHIVE\[[url removed, login to view]]Positions'!C42

We have tens of thousands of rows of data like this, so normal functions, such as INDIRECT, are too cumbersome to use and crash our systems. We will need a macro to go in and insert that first '=' sign and convert the cell to a formula.

We would like to run this macro in different files, and would like the macro to run on highlighted cells.

Thanks!

Compétences : Excel, Visual Basic

Voir plus : to string, text to string, string i, excel macro create xsd, excel macro create unique file worksheet worksheet name, excel macro create shape, excel macro create txt file, excel macro create text file, convert excel macro access macro, convert excel macro access, excel macro create permutations, convert excel macro standalone application, excel macro create directory mkdir

Concernant l'employeur :
( 2 commentaires ) Los Angeles, United States

N° du projet : #8495234

Décerné à :

cgullapalli

Hi, I am good at excel and macros. I can make it work. Looking forward to work on this project. Would like to discuss via chat.

30 $ USD en 0 jours
(64 Commentaires)
5.0

1 freelance a fait une offre moyenne de 30 $ pour ce travail

AlexandrK1

Предложение еще не подано

155 $ USD en 3 jours
(17 Commentaires)
4.8
LewisBollton

Dear You, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks!

155 $ USD en 3 jours
(0 Commentaires)
0.0