Hello everyone,
I am using Excel 2007
I have a question that I am hoping someone can help me with. I have a list of numbers that i need to extract all the unique numbers from and paste them in another sheet.
The list is on sheet1
The unique numbers are to be posted on sheet2, starting at B3 and skip 3 lines, then paste the next number at B7, skip 3 lines and so on until the unique list is complete.
Then if my theory is correct, I should be able to create a macro to paste a formula in the row if there is a value in B3, B7, etc. Once there isn't a value in one of the cells, no formula would be pasted.
Does that make sense? I apologize if I am not clear, I am new to vba and I'm not good at coding yet. I hope to be someday!!
I appreciate and help/advise anyone can give me and thank you in advance for any assistance.
Take care.
I am using Excel 2007
I have a question that I am hoping someone can help me with. I have a list of numbers that i need to extract all the unique numbers from and paste them in another sheet.
The list is on sheet1
The unique numbers are to be posted on sheet2, starting at B3 and skip 3 lines, then paste the next number at B7, skip 3 lines and so on until the unique list is complete.
Then if my theory is correct, I should be able to create a macro to paste a formula in the row if there is a value in B3, B7, etc. Once there isn't a value in one of the cells, no formula would be pasted.
Does that make sense? I apologize if I am not clear, I am new to vba and I'm not good at coding yet. I hope to be someday!!
I appreciate and help/advise anyone can give me and thank you in advance for any assistance.
Take care.
