LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Copy and Replicate exact formulas

Hi

I have a range with formulas in, say A1:F50. I want to copy the exact
formulas over to G1:L50, but if I select the range and copy and paste,
it changes all the values in the formulas, when I want an exact
replica, not adjusted ones? How can I do this? At the moment I'm doing
it and just doing a bulk find and replace for each bit back to the
original. I've been into paste special, and just selected formulas,
but is still amends the formulas.

Cheers

Rich

 
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
How to replicate formulas Crisco Kid Excel Worksheet Functions 4 March 18th 07 05:32 PM
Exact Copy Saxman Excel Discussion (Misc queries) 3 May 25th 06 07:21 PM
Exact formula copy. Richard Excel Discussion (Misc queries) 2 December 20th 05 05:21 PM
How to do the exact copy of a formula Michal Excel Worksheet Functions 8 October 20th 05 04:27 PM
Re post the exact formulas Juco Excel Worksheet Functions 2 January 31st 05 01:16 AM


All times are GMT +1. The time now is 12:18 PM.

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

About Us

"It's about Microsoft Excel"