P
petlover
I input bills into an excel spreadsheet I would like to have to info I input
into cell a1 automatically populate data in cell c1- an example of what i am
trying to say: Right now:
cell a1= telephone bill
cell b1 = description (which varies so I do not have a drop down list
attached to it) cell c1= cost center numbers pulled from a drop down list
what i would like to do is type into cell 1 'telephone bill' and cell c1 to
autopopluate with 1500- telephone equipment
this, of course, would not work for all the entries but the monthly or
reoccuring bills it sure would be nice
I cannot change alot on the worksheet, as it comes from our CPA- but I
should be able to manipulate it enough to do this task- hopefully without
writing a maco for each bill
thanks
into cell a1 automatically populate data in cell c1- an example of what i am
trying to say: Right now:
cell a1= telephone bill
cell b1 = description (which varies so I do not have a drop down list
attached to it) cell c1= cost center numbers pulled from a drop down list
what i would like to do is type into cell 1 'telephone bill' and cell c1 to
autopopluate with 1500- telephone equipment
this, of course, would not work for all the entries but the monthly or
reoccuring bills it sure would be nice
I cannot change alot on the worksheet, as it comes from our CPA- but I
should be able to manipulate it enough to do this task- hopefully without
writing a maco for each bill
thanks