I`m working on a spread for entering how many reems of paper im putting in our printers. At the moment I have a spreadsheet with 6 columns for each printer, the date paper was added down the left column, and under each printer name is how many reems of paper iv put in them.

I`m wanting to create a nice form I can fill in to insert the data but, iv just realised that where the number of reems of paper entered will be dependent on which printer I have selected in the first combo box.

I`m assuming this will be some sort of if statement but, can anyone point me in the right direction?

Thanks