I have this condition
as you can see in the image,
1. D3 are need data from B3 with formula =$B$3 & " and Indonesia"
2. I need to make B7 until B15, when i type "USA","Australia",etc in those cell one by one it'll do task like point no 1, so the result will be "USA and Indonesia"
example : I type "USA" in B7, then B3 change to "USA", then D3 become "USA and Indonesia"
3. after point 2 done, when i press enter, B7 will automatically copy and paste as value from D3, and this command/procedure can be done repeatedly.
example : after type "USA" and press enter, D3 > copy > paste as value > B7 > B7 become "USA and Indonesia", then i'll go to B8 to do the same procedure from step 2 to 3
for point 3, can i just use record macro?
it sounds simple, but my hair just falling apart because of this.... very big thanks for the help...
[/IMG]
as you can see in the image,
1. D3 are need data from B3 with formula =$B$3 & " and Indonesia"
2. I need to make B7 until B15, when i type "USA","Australia",etc in those cell one by one it'll do task like point no 1, so the result will be "USA and Indonesia"
example : I type "USA" in B7, then B3 change to "USA", then D3 become "USA and Indonesia"
3. after point 2 done, when i press enter, B7 will automatically copy and paste as value from D3, and this command/procedure can be done repeatedly.
example : after type "USA" and press enter, D3 > copy > paste as value > B7 > B7 become "USA and Indonesia", then i'll go to B8 to do the same procedure from step 2 to 3
for point 3, can i just use record macro?
it sounds simple, but my hair just falling apart because of this.... very big thanks for the help...