VBA Code to only copy cells with data within a range

Dear Experts,

Can someone please help?
In Excel 2010 I have a spreadsheet in which I enter data on one sheet and then the data gets copied to another Spreadsheet. What I would like to do is have the code only copy Cells in range "e5:j55" that only have values instead of all.
So for example one day I may enter 50 records of data, and the next I may enter only 10 records. The amount of records will vary from day to day and will never exceed 50 records.

The current code is :

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.