• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How Do I Cause Excel To Place Data in Consecutive Rows

J

JRM

New Member
I'm using Excel 2010 to handle an Offering process we use at my Church. Offerings come in envelopes. We record the offering amount in a columns (5 in total). Immediately to the left of each column there's a check box column to indicate whether the envelope contained a check or cash. If the envelope contained a check, the check box is checked, if cash, no check mark in placed in the check box. All the checks and only the checks are transferred to a Check Processing sheet in the workbook where we process only the checks, cash is handled in another way. The checks that are transferred to the Check Processing sheet mirror the input sheet with gaps between entries as there was cash entered between some of the checks. My question is how can I eliminate the gaps between checks on my Check Processing sheet? Thanks for any help you can provide.

Grace and Peace,
jrm
 
You must log in or register to reply here.
Back
Top