ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   data input into cell a1 drives c1 data gathered from a list (https://www.excelbanter.com/charts-charting-excel/146088-data-input-into-cell-a1-drives-c1-data-gathered-list.html)

petlover

data input into cell a1 drives c1 data gathered from a list
 
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


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com