Mark Knecht wrote:
In my case, since the values in the X column remain valid for the rotated version I could even accept that these values weren't changed at all, but unfortunately it's a huge amount of work to go back and make every entry $X$64, $X$65, etc. I'll do it if I have to but I'd rather not. Any ideas how I get around this? If this is too complicated to do in words I'll post a small spreadsheet as an example. Thanks, Mark
Hi Mark, As a quick fix, you can use find and replace to change X64 to $X$64. tc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
