Macro to create formula in cell

[Guest]

I have a workbook with numerous tabs in it and I need to create a macro that
will pull information from the previous tab. I want to copy this macro onto
multiple sheets without having to change it. The formula needs to reference
the tab directly preceeding it. I recorded a macro and entered = and then
hit control / page up. However, when I copy this onto other tabs, it still
references the original tab that I linked too. Control / page up works in a
macro for other functions (copy/paste, etc), but not to create a formula.
Any ideas on how to make this work?

I hope this post isn't too confusing, sometimes it's hard to explain what
I'm doing.

Thanks!!!

 

[Guest]

check out
http://tinyurl.com/2z6chj
thanks to a response by vezerid to a question in worksheet functions

 

[Guest]

Thank you! The post on that site had the answer, but I actually used the VB
code posted by Gord Dibben to solve my problem.