Excel 2011 for Mac Mixed Reference Macros Issues

[IrinaK]

Hello!

I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing.
No problems with recording separate macros with relative or absolute reference.

Problems description:

I have few sheets with tables of the same format, but the amount of data in columns is different, thus I need a macro that would have both relative and absolute references.

I do every step exactly as they have to be done, following this instruction from 10:44 to 21:48
https://www.youtube.com/watch?v=ihfHz8e2fic

Once again: when I separately record macros with relative or absolute references, these guys work.

After following all steps, I check what is being recorded (the code) and it shows this (relative nothing, no steps, no records):

Sub Macro25()
'
' Macro25 Macro
' newmacro
'
' Keyboard Shortcut: Option+Cmd+q
'
End Sub

Thank you!

PS I've no idea how to write codes yet, I'm not that technically informed yet.

 

[mikerickson]

I haven't looked at the video, but it sounds like you are putting a formula in a cell. What cell are you putting the formula in and what formula do you want to go in the cell?

 

[IrinaK]

I haven't looked at the video, but it sounds like you are putting a formula in a cell. What cell are you putting the formula in and what formula do you want to go in the cell?

Thank you for your reply. I don't see how to explain all moves, it's a table; if you have two minutes, could you, please, check the video (only the part I mentioned, it's a short one). I did accordingly.

 

[IrinaK]

Hello!

Can anyone help me, please, with this issue? Is there any Mac user who had the same issue?

Thank you!