CHALLENGE! Issue sorting data containing relative references on a separate tab

		Microsoft Office Forums > Microsoft Excel > Excel
CHALLENGE! Issue sorting data containing relative references on a separate tab

FAQ

Thread Tools

Display Modes

01-07-2010, 11:28 AM

mcjohn

Windows Vista CHALLENGE! Issue sorting data containing relative references on a separate tab

Office 2007

Novice

Join Date: Jan 2010

Posts: 15

I'm sorry I made a typo which might be confusing. My FYI should have said there were unnecessary references to Data2!A2 (for example) in the Data2 sheet. The sheet name doesn't need to be referenced when refering to a cell within the sheet the formula is in... Anyway you know all that.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot open two separate MS word window	bunny_biceps	Word	2	08-17-2010 01:51 PM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.	psmaster@earthlink.net	Excel	0	11-24-2009 11:54 AM
Challenge: Get Custom Form to Show up in Reader Pane in 2007	JohnGG	Outlook	0	08-21-2009 05:44 AM
attaching (relative,logical or virtual) path to template word document	wissam	Mail Merge	0	08-04-2009 05:09 AM
Icon issue with Office 2000 data files	bankboysb	Office	0	01-24-2006 10:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:16 PM.