![]() |
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