I have a large macro made to sort through a report and pull out specific data on the sheet. I would like to at the end of this macro copy all of the pulled cells, and paste them into a second sheet. This will be done with multiple reports being pasted onto the same sheet and i want a popup menu box to ask what column this info should be pasted in so it does not paste over the previous report. Is this possible?