Print todays Report using todays date

I want to use todays date and select the data in its row (just two columns)
and copy it into another worksheets (or even that some workbook if easier).

There may be blank rows though..I was hoping to use todays data as a checker and then : If now() = columnA's date then add the copy statement.

Sounds easier. Tried to do this with the other post the last few days and the date thing and checking the dates is confusing me. I have used before a comand like this: see code and it worked to copy data but this of course is alittle different.

Sorry to ask for alot of help here, but again I am not sure where to go. Like I said before I have came along way..and will soon be able to offer some help to others.

Please Login or Register  to view this content.

I think maybe you make things a bit more complicated than it needs to be. Here is a couple of tips:

It could be better to redesign the "Slurry delivery" sheet only using Excel cells instead of using an embedded Word document. Then it's much more easy to automaticly put in the data you want, using simple formulas, Eg like VLOOKUP i showed you in another thread.
It's no problem getting the result to look the same, with some simle formatting.

Don't look to much at VBA for solving every problem. A lot of problems can be solved simly using Excel formulas. I recommend to learn as much as you can about Excel's formulas before you start with VBA.

I think you should format the dates in column A on Sheet1 as full dates and not just days of the month. This makes the use of lookup formulas easier.

I'm not sure I understand exactly what you are looking for but I think it could be solved simply using a combination of the Excel functions VLOOKUP and TODAY.

Actually, I followed your recommendation and it worked great!

Thank you for everything...made my life nice!!!