'If A1 is Company B, reference cell (list) G2'Įtc. 'If A1 is Company A, reference cell(list) G1' just trying to figure out a template to help me sort some stuff out for work.Įdit: for my second challenge, I'm trying to think outside of the box, so if I select from my list 'Company b' under A1, then under A2 have some formula to reference a list in another cell. I select Company B, then a list next to it will populate with employees from that company.

I select say a company from the first list, then in the second list I get to choose which employee from that company? The Apache OpenOffice User Forum is an user to user help and discussion forum for exchanging information and tips with other users of Apache OpenOffice, the open source office suite.

Is it possible to setup a second list to auto populate depending what i select? I figured how to do a drop down menu with the Data > Validity > Allow: List (and then I can input list items) Secondly, I would like the cell immediately below that field to auto populate with a day 10 days later. I was wondering if its possible to click an open cell and have a calender pop up and I can select a date and it will input the date for me.

Openoffice calendars