[off-topic] Spreadsheet question

[Dion]

Hi,

Nice idea. It may be handy to know which spreadsheet application you're 
using.

In Libre Office and probably OpenOffice too, just highlight the block of 
cells you want to change and then do a find and replace. Replace 
cellnumber with sheetname.cellnumber  eg "A7" with "Sheet2.A7"

For many references, I don't know if it can do a regular expression. It 
depends on the complexity of your spreadsheet whether this is worth 
exploring.

Regards,
D.

On 12/03/12 3:23 AM, Jim Householder wrote:
> Hi
>
> I'm keeping a daily record of my power usage in a spreadsheet.  After 
> I set it up, I decided I wanted a summary by month.  Now the area for 
> the summary is getting tight.  I would like to move it to a second sheet.
>
> Is there a simple way to move an 8 x 46 block of cells, each of which 
> has a reference to a single cell, to a second sheet without manually 
> adjusting every cell?
>
> TIA
> Jim
> _______________________________________________
> Off-topic mailing list
> Off-topic at plug.org.au
> http://lists.plug.org.au/mailman/listinfo/off-topic


-- 
"Never ascribe to malice that which may adequately be explained by incompetence." - Napoleon Bonaparte