LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default copying groups with formulas

Hey,
When I have a group of cells, all with formulas that inter-relate to
other cells, and I try to copy them to another section of a spreadsheet, the
formulas all reset themselves to new cells, relative to their new location.

How do I move cells and keep their formulas relating to the cells they were
related to before the move?

Thanks as always everyone,

Kyle P.
 
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 - Sorting groups in groups due to subtotaling [email protected] Excel Worksheet Functions 3 April 4th 08 06:13 PM
Copying formulas [email protected] Excel Worksheet Functions 1 March 28th 08 08:23 PM
Formulas using the same data types but with varying size groups MAC253 Excel Discussion (Misc queries) 0 October 3rd 06 04:31 PM
Copying groups of dates TBoe Excel Discussion (Misc queries) 4 February 3rd 06 09:06 AM
how do i view all groups under excel in google groups JulieD Excel Discussion (Misc queries) 2 December 16th 04 04:33 PM


All times are GMT +1. The time now is 10:57 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"