please help

J

jpoltor

When I input an expense number in a cell I would like the cell to ask me
if it is one of three options refurbishment, foundation, or marketing.
Once one of those options are chosen it then extracts that number and
puts it in one of three categories or columns on another worksheet.
 
E

EdMac

Not entirely clear what you want to do. If you want to produce
summary of the totals it can be done easily, if you want the whole se
of cell for each type copied, thgat would require code.

For a summary:

Sheet1
Col A - amount
Col B - set up Data Validation List with the expense type

Sheet2
Enter in a cell =SUMIF(Sheet1ColBRange,Expense type,Sheet1ColARange
substituting as required.

HTH

E
 
D

davesexcel

jpoltor said:
When I input an expense number in a cell I would like the cell to ask m
if it is one of three options refurbishment, foundation, or marketing.
Once one of those options are chosen it then extracts that number an
puts it in one of three categories or columns on another worksheet.

I dont know how to better explain

Thanks
Click to expand...

What happened to the answer I gave you last night?
 
Top