Generate report with no blank cells

Hello,

I need to create a macro to copy the entire D row from the tab "generate" to the tab "report".

This is not the reaseon I create a new Tread :-D.

I need the data to be copied as paste value and without blank cells into the report worksheet.

In fact in the "generate" worksheet in D column, I generate a report where data can change. So I need when I click on the macro button "Generate Report" to copy the current data in D column into the "Report" worksheet. The most would be to have the date of the day then the report without blank cell.
As I need to keep a history I would need the report to be copied in the column with no data.

To be clearer I attached a sample. Just imagine that I have push the button "Generate Report" the 10/23/2013 and push it again the 10/24/2013. I would need the data to ba as it is in the Report worksheet.

I hope I have been clear enough. If not please do not hesitate to contact me.

many thanks in advance.
Graig

It is almost what I need

When I put a formula in the column D The script doesn't work properly (which is why I need to copy and paste values because I have in the original file formulas)
Also I need to have the date of the day at the top of the row. I thought about doing a dim of the date of the day =NOW() but I do not know how to implement it into your macro

Thanks for your help !
Graig

I do not know which one is not working.
The code is very simple. Copy all non-empty cells in column D- values ONLY in to next empty column.
I am not sure why are you referring to as "Formula"
I can add today's date to be copied in to report sheet D1.

If you type a formula instead of a player or even enter above "Group A" the =NOW() to get the date. The entered formulas in the D column are not copied in the "report" worksheet

Is your question regarding copying today's date in to D1 or the rest of the code is not working? If it is the former, as I said on my last post, I can add a line which copies the date.
Infact, you can add this line just before the application cut line.

Please Login or Register  to view this content.

I am sorry I do not manage to make it work.

I attach the "original" file. In the column A:A I just copy past my generated report or even remove manually the players OR add exceptions in the "except" worksheet.

As you can see in the column "D" I have formulas to check whether players should be taking out of the report.

Can you please help me to make it work?

Many thanks in advance,
Graig

Okay,
I know the issue.
You do not have non-blank cells, but have formula with blank values.
It can easily be done by a loop, but there is a short enumerate number code (Forgotten it now) which can copy these type of data.
So, If you are not in a rush, I need to dig and find the code. If you are, I will do the loop.

I am not in a rush ! Thanks a lot for your help. I appreciate.
Graig

Hi AB and Graig,
maybe so (see attachment)

Graig,
I was unable to find the enumerate number and has asked Nilem.

He has nailed it down. This avoids loop which was my intention.

Thanks Nilem!

It is just perfect !! Thank you both!
Graig