Posts by senpai

    [xpost][/xpost]

    Hi All,


    I need help with VBA code. So following is what i want to achieve.

    1. 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.
    2. Column B has formula in B2. Formula is ="T"&A2
    3. 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