Report Copy Text from a file and Type in another file in Macro Express and Macro Express Pro Posted May 14, 2011 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.
Copy Text from a file and Type in another file
in Macro Express and Macro Express Pro
Posted
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.