J
jonco
I have a spreadsheet that I'm trying to set up that keeps tack of some sale
figures (all visible on one screen) in sets of 5 columms with each set
containing 4 cells on each row (Amt, Date, By, Note):
Set 1 (Colums A-D): Amt (Col A), Date (Col B), By (Col C), Note (Col D) for
each transaction. 27 items in rows 5 - 31
Set 2 (Column E-H): Amt (Col E), Date (Col F), By (Col G), Note (Col H) for
each transaction. 27 items in rows 5 - 31
Set 3 (Column I-L): Amt (Col I), Date (Col J), By (Col K), Note (Col L) for
each transaction. 27 items in rows 5 - 31
Set 4 (Column M-P): Amt (Col M), Date (Col N), By (Col O), Note (Col P) for
each transaction. 27 items in rows 5 - 31
Set 5 (Column Q-T): Amt (Col Q), Date (Col R), By (Col S), Note (Col T) for
each transaction. 27 items in rows 5 - 31
Now, what I want to do is to have Excel start by going down Colum A (for the
first group) (starting at Row 5) and find the first empty cell. If it
reaches the last cell in that column (A31) and it has data in it, I want it
to go to cell E5 (the start of the 2nd group of columns) and do the same
thing there... only stopping when it hits an empty cell. This would
continue through all 5 sets of data (if necessary) until it finds the first
empty cell in the Amt column.
Thanks for any help I can get.
Jonco
figures (all visible on one screen) in sets of 5 columms with each set
containing 4 cells on each row (Amt, Date, By, Note):
Set 1 (Colums A-D): Amt (Col A), Date (Col B), By (Col C), Note (Col D) for
each transaction. 27 items in rows 5 - 31
Set 2 (Column E-H): Amt (Col E), Date (Col F), By (Col G), Note (Col H) for
each transaction. 27 items in rows 5 - 31
Set 3 (Column I-L): Amt (Col I), Date (Col J), By (Col K), Note (Col L) for
each transaction. 27 items in rows 5 - 31
Set 4 (Column M-P): Amt (Col M), Date (Col N), By (Col O), Note (Col P) for
each transaction. 27 items in rows 5 - 31
Set 5 (Column Q-T): Amt (Col Q), Date (Col R), By (Col S), Note (Col T) for
each transaction. 27 items in rows 5 - 31
Now, what I want to do is to have Excel start by going down Colum A (for the
first group) (starting at Row 5) and find the first empty cell. If it
reaches the last cell in that column (A31) and it has data in it, I want it
to go to cell E5 (the start of the 2nd group of columns) and do the same
thing there... only stopping when it hits an empty cell. This would
continue through all 5 sets of data (if necessary) until it finds the first
empty cell in the Amt column.
Thanks for any help I can get.
Jonco