custom invoice with drop down selections. idiots guide please!

asked 2018-05-02 18:08:38 +0200

mark norman gravatar image

I am trying to create an invoice in Calc.
A fairly simple design, whereby I have a drop down box in cell 1 to select a venue. Each venue has a separate costing, which when selected in cell 1, will display the individual cost in cell 2.
Cell 3 will show the number of days , and then cell 4 will show the total.

Stuck on the first bit , I've played around with data range and validity, and have gt the drop down, just cant associate it with the cost to go in the next cell.

I'm a real novice so any help is most appreciated. Many thanks

edit retag flag offensive close merge delete


You're trying to automate it so that when you select Venue A from a drop-down list in cell 1, cell 2 auto-populates with its associated cost of $____. I don't know that there's a way to do that. Macros, maybe. Would be cool to be able to do that.

Liberty Belle gravatar imageLiberty Belle ( 2018-05-03 02:55:39 +0200 )edit

exactly that. someone must have wanted to try it before me! ........ anyone?

mark norman gravatar imagemark norman ( 2018-05-04 20:54:38 +0200 )edit

Calc does not have a way to automate this. Maybe post a new question asking how to write a macro for this and tag it with 'macro' as well.

Liberty Belle gravatar imageLiberty Belle ( 2018-05-06 21:43:56 +0200 )edit