Macro to create formula in cell
 

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!!!

Macro to create formula in cell
 

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

"WendiL99" wrote:

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!!!

Macro to create formula in cell
 

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.

"bj" wrote:

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

"WendiL99" wrote:

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!!!