Copy + paste not working as "normal"

Hello,

I don't know why this is happaening.

But I have formula like =January!A1+1 on sheet 2. Then when I normally copy that cell to sheet 3, the formula normally would chance to "February!A1+1". Now it keeps the same formula "January!A1+1" even if I try to use any of paste methods.

Any idea? I do not use the $-signs of course..

Best Regards,

T

I would expect that what you describe is correct - if you are talking about sheet2 being called "January" and sheet3 being called "February" then if you copy
=JanuaryA1+1 from sheet2 to sheet3 it would remain = JanuaryA1+1
if you copy
=A1+1 from sheet2 to sheet3 it would remain =A1+1 when moved to the next sheet, in essence changing the sheet reference.

So if you copy and paste across sheets with a sheet reference typed in it stays the same.

Unless you are talking about in one workbook where you had some sort of macro set up to deal with the sheet renaming.

Hi,

Otherwise correct, but Sheet 1= "January", Sheet 2 = "February" Sheet 3= "March". On sheet 1 A1="1" and on sheet 2 A1=JanuaryA1+1.
I have always done this, in excel and open office, and never had the problem. Now Im using the newest Excel and previous I've used 2010/2003.

How can that be.. How can Ithen get formula to funtion as wanted?

I use excel 2003 and it doen't really work for me.
I would suggest
=MONTH("01/"&(MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,100))&"/2013")
woudl return the values that you want (i.e. it will put the sheet name in A1 as a month number)

Ehrr, can not be! One way is to do this with prev sheet macro, but I rather not use that as it may now work in every computer. Your example does not do, because I have like 20 sections to which I should use previous sheet reference and therefore it is way too effortable to do it like this.

Weird thing.. Well, no can do.

Thanks anyway!