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 1...
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 "!!
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