Copying a column to another column

[Scary123]

Hi everyone,

I have a workbook where I want to be able to use a command button to select which will move data from 1 column to another in the same worksheet.

The following is what I am looking for: -

1. Copy Data that is in Column C4:C23 [Range Name is Calculations]
2. Paste Data into column A4:A23 while using paste special (Values) [Range name is Copied_Cells]
3. The Sheet name is called (Calculations)

I can do a form control and record the macro but when I change the file name I have to redo the macros.
I want to be able to change the file name and have the button work without re-doing the macro.

My file is a football league and the only thing that I want to do is get this button working if it is possible.

Mark

Football League.xlsx
	A		C
3	Positions		Rank
4	13		11
5	5		8
6	17		17
7	16		16
8	6		9
9	15		14
10	4		7
11	18		18
12	11		12
13	3		3
14	1		1
15	8		5
16	2		2
17	14		15
18	20		20
19	9		6
20	7		4
21	19		19
22	10		10
23	12		13
Calculations

 

[Fluff]

If you are using SaveAs, then there should be no need to record the macro again

 

[Scary123]

If you are using SaveAs, then there should be no need to record the macro again

I wasn't but I have just saved it by SaveAs and it works thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.