Forum Discussion
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 100 line i need something that can auto detect if the cell have anything in it and copy one buy one to E3 cell
11 Replies
- It's kind of hypothetical question, please share some sample data, and be specific about, "i need something that can auto detect if the cell have anything in it and copy one buy one to E3 cell "!!
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.
something like this
So when i paste all the data in H like starting from one and down ( 1-2-3-4-5-6-7-8 are like example )
it would start copying from H2 down
copy one cell at the time to F3 so i can print it as son **bleep** its detect the call F3 have change
I need to print these labels
i dint know how many i get every time so need something that would auto detect and would not copy empty cells
Hope this helps
