Hello
I have some code which works really well:-
However in page 1 I sometimes have formulas. I want my in page2 to copy over and clear the formula as the formula is then changing the pasted data.
Please Login or Register to view this content.
Can anyone please help!!
Last edited by JBeaucaire; 03-03-2015 at 11:03 AM.
You want the formula pasted into sheet two, calculated THEN copy+paste values?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Why not just make a (full) copy of the source sheet, complete with formulae, then select all the cells and Copy and Paste Special | Values? Then you have an exact copy of the source data with no formulae, just values. And then do whatever processing is required on the target sheet with the values.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks