Power Edit (John Mote) - Excel 2010

**thesecretsanta** · 03-21-2011, 10:05 AM

Hi
I've just switched to Excel 2010 and am looking for John Mote's Power Edit add-in......his website (www.johnmote.com) seems to have dissappeared - does anyone know if there is an Excel 2010 version of the add-in?
Previously I've been using the 2003 version and it's been invaluable for pasting exact formulas
Thanks
Mark

**NBVC** · 03-21-2011, 11:13 AM

Not sure if this'll help...

http://www.excelforum.com/excel-gene...er-add-in.html

**thesecretsanta** · 03-21-2011, 11:15 AM

Thanks - doesn't help with that problem, but definitely helps with other problems! Very useful review tool

Maybe someone knows another way of copying a row or column or other selection of formulas, and pasting them elsewhere exactly the same ie without the references updating?

**Andy Pope** · 03-21-2011, 11:20 AM

Have you got the xl2003 version of the addin? If so does it not load in the Addins tab in xl2010.

**thesecretsanta** · 03-21-2011, 11:35 AM

I'd lost the 2003 version when I was migrated at work to 2010....have just been resent it though and it does look to be working
Only downside now is that I can't get it as a main menu on the ribbon - have to go Add-Ins, then PowerEdit, then find the function - admitedly only 1 extra step, but a backwards step all the same!
I've attached the add-in in case anyone else is after it

**Andy Pope** · 03-21-2011, 11:36 AM

Can you add a link via the QAT

**thesecretsanta** · 03-21-2011, 11:41 AM

What's the QAT? Sorry new to this

**thesecretsanta** · 03-21-2011, 11:44 AM

Quick Access Toolbar - only been on 2010 a couple of days so not quite up there with it yet! The option's grey'd out on the group and individual functions so guess not