Creating text in a column via macro [message #350] |
Sat, 12 May 2018 05:40 |
amorrison
Messages: 38 Registered: March 2016
|
Member |
|
|
Hi,
I'm trying to create a macro that will tidy up data and create some new columns. One of the columns will change every time and would need input from the user. I tried the following in the process
1) define variable - gave it a name and left value blank
2) Add calculated value - in the formula I put the variable name in step 1
When I run the macro, I get asked the value of the variable, which I complete, but it then doesn't populate all the rows of the calculated column with the variable in step 2. Is this the correct approach, if so what am i doing wrong? Or should I be doing it another way?
Thanks,
Angus
|
|
|
|
|