Good day.
I'm looking for a macro that could help me copy the next number in a column (the amount of numbers can vary every time) and paste the number in a specific cell.
I have attached a sample sheet.
What I would like to achieve is: the number displayed in Cell A5 be copied and pasted in Cell K1, once I press a macro button, it goes down to the next number (A6) and copy that and paste it into K1 again. This function continue until there is no number left in Column A to copy and paste. As the number list varies, one month there could be 2 numbers (A5 and A6) and other months there could be more than 1000 numbers.
If someone can help me with this, I would appreciate it alot.
Bookmarks