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 string, string i, excel macro create xsd, excel macro create shape, convert excel macro access, excel macro create permutations

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