Issue with Range and copy Code

[cartica]

HI-

I have 2 questions. My first question is instead of having all these lines of code, can I just have?

Please Login or Register  to view this content.

Currently I have

Please Login or Register  to view this content.

My 2nd question is, Everyday the below fills down. I have one stagnant line F25, and G25. I want those to equal the most current date that the above range fills down too. My code below doesn't seem to work. Any ideas?

Please Login or Register  to view this content.

[cartica]

any ideas?

Thanks

[Norie]

1 Yes you can do that.

2 How does the code not work?

[stnkynts]

To answer your first question, yes that would work (provided a couple of things are true) but it would probably be better to come from the bottom up.

Please Login or Register  to view this content.

To answer your second question, not enough information. If you want today's date in F25 & G25 this would work:

Please Login or Register  to view this content.

[cartica]

Daily Performance Report 4.24.14.xlsm

The below didn't work when trying to combine the lines into 2. Also pleas see what I mean for f/g 25.

Seem my attached example

[Norie]

You didn't mention there was a totals row below the data.

Try this.

Please Login or Register  to view this content.

[cartica]

Norie. That worked. Thank you so much. Can you please explain your code to me? I have given you rep.