Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 51

Updating Absolute References

Is it possible to do a global update to all absolute references? I have a
large worksheet that links to another and it must be updated each month to
change the link and move it one cell below, i. e. from say A23 to A24. I
want to be able to do this at one time rather than changing each link
individually.
--
Allan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
convert relative cell references to absolute cell references via amacro?	Dave F[_2_]	Excel Discussion (Misc queries)	1	May 15th 08 04:43 PM
Help with converting a block of cells with Absolute and mixed references to relative references	Vulcan	Excel Worksheet Functions	3	December 13th 07 11:43 PM
Absolute References	Dan Beard	Excel Discussion (Misc queries)	3	October 16th 07 03:20 AM
Absolute References	[email protected]	Excel Worksheet Functions	1	November 29th 06 12:41 AM
Turn off Absolute references	Carolyn	Excel Discussion (Misc queries)	1	November 2nd 06 08:08 PM

All times are GMT +1. The time now is 01:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us