G
Geo
I have created a workbook with multiple worksheets, one for each month of the
year.
Each worksheet has four columes: DESCRIPTION, DATE, AMOUNT, TYPE
Example: JAN (worksheet name)
DESCRIPTION DATE AMOUNT TYPE
Maple St. 6/1/06 $1200.00 Check
Davis St. 6/2/06 $1300.00 Credit
Wilson St. 6/1/06 $ 900.00 Cash
Brown Ave. 6/4/06 $2250.00 Credit
Mare St. 6/1/06 $1150.00 Money Order
Sikes Dr. 6/10/06 $1000.00 Credit
At the end of each month, the data needs to be copied, arranged by date,
sorted by TYPE and moved to their respective summary worksheets (Check
Transactions, Credit Transactions, Cash Transactions and Money Order
Transactions).
Example of results:
Check Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Maple St. 6/1/06 $1200.00
Credit Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Davis St. 6/2/06 $1300.00
Brown Ave. 6/4/06 $2250.00
Sikes Dr. 6/10/06 $1000.00
Cash Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Wilson St. 6/1/06 $ 900.00
Money Order Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Mare St. 6/1/06 $1150.00
I’m fairly new to complex formulas, so any help would be appreciated.
Thank you.
year.
Each worksheet has four columes: DESCRIPTION, DATE, AMOUNT, TYPE
Example: JAN (worksheet name)
DESCRIPTION DATE AMOUNT TYPE
Maple St. 6/1/06 $1200.00 Check
Davis St. 6/2/06 $1300.00 Credit
Wilson St. 6/1/06 $ 900.00 Cash
Brown Ave. 6/4/06 $2250.00 Credit
Mare St. 6/1/06 $1150.00 Money Order
Sikes Dr. 6/10/06 $1000.00 Credit
At the end of each month, the data needs to be copied, arranged by date,
sorted by TYPE and moved to their respective summary worksheets (Check
Transactions, Credit Transactions, Cash Transactions and Money Order
Transactions).
Example of results:
Check Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Maple St. 6/1/06 $1200.00
Credit Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Davis St. 6/2/06 $1300.00
Brown Ave. 6/4/06 $2250.00
Sikes Dr. 6/10/06 $1000.00
Cash Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Wilson St. 6/1/06 $ 900.00
Money Order Transactions (worksheet)
DESCRIPTION DATE AMOUNT
Mare St. 6/1/06 $1150.00
I’m fairly new to complex formulas, so any help would be appreciated.
Thank you.