Macro to create formula in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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.
 
Back
Top