whitefeather
New Member
- Joined
- May 9, 2016
- Messages
- 29
Hello,
I am using a macro (say, Macro 1) which delivers a value on M8 cell based on the value given on 6 cells (M1 to M6). Now, I have a worksheet of six columns (A to F) and 1000 (variable) rows, which will populate the six cells mentioned earlier for every row and after getting the value by Macro 1, the value will be written in last cell of every row (i.e. G1). Meaning, Macro 1 will be run as the same time as the row count of second worksheet and will write the yielded value at the end cell of every row. How may I achieve this?
Thanks in advance.
I am using a macro (say, Macro 1) which delivers a value on M8 cell based on the value given on 6 cells (M1 to M6). Now, I have a worksheet of six columns (A to F) and 1000 (variable) rows, which will populate the six cells mentioned earlier for every row and after getting the value by Macro 1, the value will be written in last cell of every row (i.e. G1). Meaning, Macro 1 will be run as the same time as the row count of second worksheet and will write the yielded value at the end cell of every row. How may I achieve this?
Thanks in advance.