Changing Multiple referenced Cells

**kickme** · 11-23-2012, 05:38 AM

Hi,
I prepare charts from a table of referenced cell: e.g.

$X$10 $X$15 $X$20
$X$12 $X$17 $X$22
$X$14 $X$19 $X$24
$X$11 $X$16 $X$21

For nex set of data I need to replace all $X with $P in copy of above cells....

How I can do in least input....

Thanks
Limmil

**dilipandey** · 11-24-2012, 03:27 AM

Hi Limmil,

If the two tables are separate else you can make a copy, select any cell in new table, press ctrl + H, replace $X with $P.
Hope I got it correctly, if not please upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**kickme** · 12-02-2012, 01:49 AM

Solution worked...although I made mistake in querry....actualyy the cells contained formula like =$X$10 = $X$11 etc...

Sometimes simpler solutions are forgotten if we assume problem is complicate..

Thanks for bringing me to Basics...