I take it from your reply that you are not familiar with VBA code, which
can make it 'push'

Try this simple test:

In a test workbook, put the letter G in cell A1 and a monthly figure in
cells A10 and B10

In your Excel, click on View, Toolbars and tick Control Toolbox

The first icon is 'Edit Mode' (when you click, it becomes 'Exit Edit
Mode')

In Edit mode, click on the Button icon on the same bar, then click into
a cell where you want the button to be (it is moveable later)

Rightmouse on this button, and select View Code, and you will be taken
to the code in the VB editor (where your macros are stored etc)

put the code

cn = Range("A1").value
Range("Sheet2!" & cn & "10") = Range("a10").Value
Range("Sheet2!" & cn & "11") = Range("b10").Value

into that, and close and Exit Edit Mode

in A1 put the column name that you want to save to, then click the
button.

Your figures are moved.

Change the A1 letter to any column and press button again, figures are
copied.

That should provide what you asked for, and you can set the letter (in
A1 or elsewhere, it's collected in the first line of code) by any means
you wish, ie A1 can be the result of a formula.
A10 and B10 are just two test cells, you will need to adjust the names
to suit your own needs, but let me know if you have troubles.

in Edit Mode, the Properties of the button include BackColour and
Caption which can be set to your preferences.








Inneed Wrote:
Thanks Brian,

I can make it a "pull" system but I want to keep the monthly column of
data under that particular month in the annual sheet. Because I only
have the 1 column that changes in the other sheet.

The only way I can think of is to copy the whole sheet and pastespecial
"values" but then I would lose all the "pull" formula's. I just need a
way to "lock" the column in place (probably by pressing a button,
however I want to stay away from copying and pasting as I will lose
formula's and I need the spreadsheet next year).

Thanks again.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=396035