Dinesh Menghani

I have 2 excel files. I want to copy all the data from 1 excel to another excel. Criteria.: - In second excel one of the cell we have wherein we can only type the numericals we cannot paste the data copied from the first excel. so, I want to set a macro where the numbers get changed in serial manner as macro repeats itself each time. Like in ROW 1: I got the number 89 than when macro repeats in 2 ROW the number has to be changed to 90.