Do I need a Form or a Macro??

[Keith24249]

Hi,

I have created a quote template (see attached) what we do at the moment is fill in every cell by clicking on it and entering the relevant data. I'm sure there must be a better way but I don't have sufficient Excel knowledge to be able to sort it out. Some people have mentioned a form and others have said a macro is the way to go but I wondered if anyone had any ideas to volunteer. Sometimes our quotes go to more than one line so the solution would have to be able to cope with multiple line entries. I have indicated the order I would like the data to go in by placing a number in the relevant cell. I hope this explains the problem in sufficient detail but if not please get back to me.

Regards


Keith