About Us

bala_vb

Quote:

Originally Posted by Tola

How do I change a range of Formula linked to 3 other files ?

Example:
Cell Reference:
A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7
A8:='[AAA.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8

Want to change one of the references to '[BBB.xls] to '[CCC.xls] using
wildcard characters but * and ? does not seam to be regognized in find and
repalce ?

Hi Tola,

What I understand is that, your are looking to change the existing formulae from BBB to CCC in the third summation part

A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7

1. Place the curosr in A7 Cell
2. Goto Formulae bar
3. Edit the formulae manually in third summation from BBB to CCC
4. Drag the formulae from Cell A7 to till end

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use of Wildcard characters with replace	tonuab	Excel Discussion (Misc queries)	2	November 6th 09 09:39 PM
find & replace - digit wildcard	DonnaP99	Excel Discussion (Misc queries)	2	November 25th 08 09:49 PM
Find and Replace Command Using Wildcard Help	rgilbreath	Excel Discussion (Misc queries)	1	October 10th 08 04:01 AM
Find Replace Wildcard	dk	New Users to Excel	9	September 23rd 08 03:45 AM
How do you find and replace a Wildcard character in Excel?	Wildcard	Excel Discussion (Misc queries)	8	August 18th 05 01:18 AM

Menu

About Us