I have a formula that I need to copy to cell below it. However, the first
code of the formula needs to remain the same value.

EX: =((E5*'GSP Guest Counts'!B5)+'GSP Guest Counts'!B5)

The B5 in the next cell should be B6 and E5 stays the same. A manager
deleted all the formula's and I figured out the formula, however can't get in
copied to other locations.
--
Lisa