Locking values

[hermithead]

Hi,
How can go about the following?

I have a worksheet with a macro that when clicked will update a data w/sheet with that months data.
I then have an output w/sheet that displays the data in monthly columns.
The problem is every time I run the macro to get the latest months data
it changes the previous months data in the output w/sheet as well eg When I run the maco in August it also updates the column for July. I know I can lock the cells but can I lock the values so they dont change for July?

Or can anyone suggest a more robust way of doing this?
I've thought about doing some tedIous macros that will copy/paste/tanspose the values but like I said tedious.

Example s/sheet provided for the interested...

[DonkeyOte]

Please provide the code you are using presently.

The best approach IMO would be to store the Month on the Monthly Data sheet this gives you added flexibility in that you can

a) override existing data should there have been an error historically

b) establish appropriate column to write to on Output sheet by means of simple Match

As is your only option is to determine last column used and offset by one column but this means you can never amend/reload historic data.


EDIT: just re-read your file and noted the reverse logic but points above remain in essence ... please post your existing code.

[hermithead]

I've modified the example spreadsheet which i hope is more clearer.

Sub Get_New_Data()
'
' Get New Data button
'
'
Range("A1").Select
Windows("Calculation WORKBOOK.xls").Activate
Columns("G:M").Select
Selection.Copy
Windows("Monthly Data.XLS").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Application.CutCopyMode = False

Range("A1:G100").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

[arthurbr]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here