Macro to Copy and Paste Values to another Worksheet

**thillis** · 02-10-2010, 01:24 PM

I have a macro that copies and pastes certain rows if they include the word "Period Hours" to another worksheet (Totals). My problem is that I need it to paste values only not the formula.

Please Login or Register  to view this content.

**JBeaucaire** · 02-10-2010, 02:08 PM

Try this:

Please Login or Register  to view this content.

**thillis** · 02-10-2010, 02:54 PM

Thanks a lot that did it. This site is great.

**JBeaucaire** · 02-10-2010, 03:13 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)