Forum Discussion

beikme's avatar
beikme
Brass Contributor
Oct 10, 2020

AUTO COPY AND PASTE

Hi all i need help with some vba or micro    so i just need to copy one cell to another   lets just say i need cell to be paste in E3  but the list is in row F it could be anything from 1 up to 1...
excel
Macros and VBA
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Oct 21, 2020

beikme 

 

Check the column F in attached sheet, find the formula in cell F4 downwards,, I hope that you are looking for this.

 

In cell F3, you need to enter number smaller/prior than H3, like is 1 then 0. This will copy automatically in H4:H54, this may vary depends on the set of numbers to want to get.

 

Remember cell H4:H54  has formula ,, need to be handled carefully.

beikme's avatar
beikme
Brass Contributor
Oct 21, 2020

Rajesh_Sinha 

 

Hi 

No that's not it 

i need it that when I copy data in starting from H2 it would automatically  copy and paste the cell to F3

ind the data i past in there is random numbers 

and it could be 5 lines of data like from H2 to H7 or it could be 100 lines off data like from H2 to H102 

i need excel to detect if and copy the cells only if they have data in them 

and i need it to be done one cell at the time 

so i can use my print vba to print the label every time f3 have bin updated 

Resources