Automated copy between worksheets
 

I'm new to Excel so I'm not even sure this is possible.

What I'm trying to do is set up a workbook to record our familys
bank/monthly transactions.

My question is, I've set up a drop down list for the different categories
(i.e. Household bills, Vehicles etc), is it possible that when the category
is selected in the monthly worksheet, the date, description, and debit can be
automatically copied into the Category worksheet?

The drop down list is in the monthly statements worksheets, and I'd like the
categories to be yearly.

Im sure it could be done in VB, but that all looks Greek to me.

Any help would be greatly appreciated, and possibly prevent a brain aneurism!

Automated copy between worksheets
 

Todd

Use Data Validation for in-cell drop-down for selecting a category and VLOOKUP
for the filling-in part.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

Since you already hav the DV list you can ignore the following if you choose.

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 09:45:37 -0800, Todd wrote:

I'm new to Excel so I'm not even sure this is possible.

What I'm trying to do is set up a workbook to record our family’s
bank/monthly transactions.

My question is, I've set up a drop down list for the different categories
(i.e. Household bills, Vehicles etc), is it possible that when the category
is selected in the monthly worksheet, the date, description, and debit can be
automatically copied into the Category worksheet?

The drop down list is in the monthly statements worksheets, and I'd like the
categories to be yearly.

I’m sure it could be done in VB, but that all looks Greek to me.

Any help would be greatly appreciated, and possibly prevent a brain aneurism!