How to copy selected column to another page under a specifik field?

Hey. How do you make a macro that copies the selected column to another sheet/page in the same file, the contents of the selected column will go in specifically for a column where a WEEKNUM be indicated. Thus, the column is selected, the user presses for x a button where macro is run, the user will be asked, for example, through a dialog box (To which WEEKNUM want to copy the column to?). User types such as 23, and click OK. 23 is actually located in as: Y:2 in another page. The column to be copied must therefore fall directly under Y:3

(The dialogbox isnt important, the user could type the weeknum elsewhere).
Someone who can help me?

Please attach a sample file.

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.