Copy Paste Macro with Values & Skipping Blanks

Hi all

I have just joined here having recently discovered the potential of macros. I came across this thread in my initial search: http://www.excelforum.com/excel-prog...ro-values.html

The code posted by Leith Ross worked perfectly except I would like it to only paste cell values as opposed to the formulas in them. Is this possible or am I looking at building a new macro?

Yes I meant jefferybrown. Sorry was reading another thread with code from Leith Ross.

Oh god I'm an idiot... I did have the wrong thread. The code is here: http://www.excelforum.com/excel-prog...ing-macro.html by Leith Ross.

Sorry for the wild goose chase, this is doing my head in. The code by jefferybrown isn't suitable for what I'm trying to achieve. I tried building a code from scratch but found myself over complicating it and running into issues. The code by Leith works, but I can't seem to adapt it to paste values only.

Thanks for your attention so far mate, any ideas?

Unfortunately that didn't remove the blank cells.

I've attached a quick sample from the data I'm using. The formula is different but it shouldn't affect the test given it's a formula?

Testing.xlsm

Perhaps I'm being too ambitious, this has been doing my head in for a couple of days. I think a slightly more manual system will have to do for this in the short term. Going to continue to learn until I get this fully automated though.

Wow you are a legend. I knew I was over complicating things. Thanks for all your help!