I am trying to to do data entry for an accounting journal, and I want t
have the seperate sheets copy their respective information as the dat
is entered. For example, if I enter a Cash transaction on the entr
page, I want the cash worksheet page to copy that information as well.
I can do it with an if statment already, but that leaves blank spaces i
the cash sheet if you have blanks in the entry page
--
e_shoopma
Posted from - http://www.officehelp.i
Roger Govier - 04 Oct 2006 18:28 GMT
Hi
Perhaps you could Sort the Cash sheet, when all the blank rows would
fall to the bottom of the list, leaving your true transactions as one
continuous range.

Signature
Regards
Roger Govier
> I am trying to to do data entry for an accounting journal, and I want
> to
[quoted text clipped - 4 lines]
> in
> the cash sheet if you have blanks in the entry page.