LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default Help please with cut paste and formulas

I have a worksheet which when I have a duplicate entry, I cut and paste the needed information to the original. However, when I do this, the formula of the orginal then changes and has #ref in it. How do I prevent this?
Also, is there a way that I could use a macro to then go to the item I just copied and paste and delete that row.

Any help would be great.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel wont Paste Special wont paste formulas it says Unicode text Stephen Karanja Excel Discussion (Misc queries) 12 April 4th 23 10:52 AM
Paste formulas and keep them the same Josh Craig Excel Discussion (Misc queries) 7 March 11th 09 03:27 AM
Paste Formulas Only Brett Excel Discussion (Misc queries) 6 March 26th 05 07:13 PM
Dynamic Copy/Paste Special Formulas/Paste Special Values Sharon Perez Excel Programming 3 August 7th 04 09:49 PM
Copy & Paste without the formulas Steven Cheng[_2_] Excel Programming 2 July 31st 03 09:43 PM


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"