Hi everyone

Please can anybody help me with a macro that I can use in a purchase order template.

I don't have a clue how to write one and its driving me crazy trying to find a way to do this.

I have a template downloaded in excel with the search from Microsoft I think its Garamund Grey?

I have edited the template to suit what I need but I need a way of making the numbers move on each time I make a new order plus clear the cells for the next order.

I found a video on youtube but this doesn't work either, I copied the codes given exactly and changed the cell numbers but I just get error messages all the time.

The cell I need the number in is "E5" and the cells I need to clear are "A20 to G30"

Thanks in advance to anyone who can help out


Rockhopper