MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
I need help with VBA code. So following is what i want to achieve.
- I have data in column A starting from A2. The number of row changes everyday. Suppose, on Monday there were 5000 row, on Tuesday it can be either 5500 or 4327. So its not fixed.
- Column B has formula in B2. Formula is ="T"&A2
- The code should extend formula in column B till the last row corresponding to last row of column A.
For example, if last row in A is 2000 then B2="T"&A2000, if last row in A is 5000 then B5000="T"&A5000