Here is an example of what I'm going to do:

1)launch macro1
2)select first range (sheet "a")
3)select 2? range (sheet "b")
4)input 1 when prompted
5)input column B or C........

I also set a progressive bar into the status bar (please set status bar as visible)

Best Regards
Thank you very much for your cooperation