Hi.
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?