Im looking for code to loop through column A, starting at the the last cell, pull the contents of the cell into a msgbox/input box "how many duplicates of '&label'? and enter the amount of duplicates into the cell/s right above of right below the cell being checked

some sort of psuedocode for this i think would be

Loop Column A starting at bottom
Pull Contents of First cell code comes to
input the contents of that cell into the prompt "how many duplicates of 'contents of cell'?"
user inputs integer for duplicate number
code inserts the amount of duplicated cells directly above of directly below the cell initally pulled into the msgbox
next cell up
repeat until top of column reached.


this is for a form where there could be 1000 different cell contents but all on column A

any ideas also helpful for completing this. duplicate number is always a user imput at this time until something else can be figured out with the other software.