How to write variable value in next available cell in an excel column?

Refer the link , it will help you

Next time make sure , you create new topic for the new issue as it is not relevant to the discussion going on here in this topic category