Duplicate text cells from worksheet to invoice

[LesHunter]

Hi, I'm sure there is a simple answer to this but I cannot find it.
I have two worksheets
one called"Worksheet" I enter Details of what I want someone to do on this sheet ie Wash and reproof rug,These instructions are in rows "E3:E26"
The other worksheet is called "Invoice" I would like this sheet to replicate the range of Cells "E3:E26" on the "invoice" sheet and update as I type out the instructions.
once I complete entering instructions into "E3:E26" I want to save then print as a job sheet, i then want to clear "WorkSheet" ready for the next Job.
Also Not to copy Blank cells across.
Thanks for your help on this.
Ls Hunter

 

[oldbrewer]

Re: Dublicate text cells from worksheet to invoice

why clear the invoice sheet if it automatically pulls E3:E26 from worksheet ?

a macro button to clear Worksheet ready for next job would do it

maybe in the macro first print out invoice sheet ?

 

[LesHunter]

Re: Dublicate text cells from worksheet to invoice

Hi oldbrewer,thanks for the response,

I need the "worksheet" to populate the "invoice " then print the "worksheet" and then clear the "worksheet"
hope this makes it clearer
thanks again for you taking the time to answer my query any further help would be appreciated
yours Les Hunter

 

[oldbrewer]

Re: Dublicate text cells from worksheet to invoice

ok a macro that copies to invoice, prints the worksheet, clears the worksheet.

do it under record macro and you are there

 

[LesHunter]

Re: Dublicate text cells from worksheet to invoice

Thanks for your help sorry I took so long to reply but my. wife as been taken into hospital
i will try to create a macro as you suggested
kind regards
Les Hunter