Recent content by nutmegy

Hi I have a few documents that are driving me mad.... When i insert a caption enter the text required, then start a new paragraph, the language keeps on changing to German in the spellchecker and i have to keep on resetting it. i checked the styles and there's no mention of any German text...

i'm using 2002, as I said I saw it there previously, because I set a default chart already, but I need to change it

i cant see the button... I know it use to be there, but it isn't there anymore....

for some reason it isn't giving me the option to add

Hi I have set a default chart in Excel but now when I try to setup an alternative default the option isn't there to do so. How do I reset the default chart?

cheers guys.....

Hi Glenn So can you explain to me each section of that as I would really like to understand it to apply it to other cells Thanks Andrew

Nice one mate... here's a star for ya both.... I really do have to learn how that function works... it seems bloody useful

Sorry about this Geoff... it still isn't doing the right stuff What it's doing now is Sheet1!C4=Data!C4 Sheet1!D4=Data!D4 Sheet1!E4=Data!E4 Sheet1!C5=Data!F4 Sheet1!D5=Data!G4 Sheet1!E5=Data!H4 What I need to do is Sheet1!C4=Data!C4 Sheet1!D4=Data!C5 Sheet1!E4=Data!C6 Sheet1!C5=Data!C7...

oops apologies I am starting on Sheet1 populating cells C4 to E4 .. C5 to E5 obtaining data from Data!C4 to C6 ... C7 to C9 etc...

AAArrgghhh it's still not working What i've entered is =OFFSET(Data!$C$4,0,(ROW()-1)*3+COLUMN()-1) into Sheet1 Cell C4, when i copy it across it's giving me figures from Data!H4 to Data!j4 in the first row and M4 to O4 in the next row etc... so it's jumping by 3 columns each time. I am...

Glenn... i've tried your suggestion, but it comes up with the same value from cells A1 to C1 and blank on the rows further down. Any ideas?

Hi I am trying to populate a spreadsheet with other data obtained from another sheet. ie cell formula is "=Sheet2!A1" which works fine but takes ages as i need to do the following Sheet1 is where i need the info to be re sorted so... e.g. Sheet1 Cell A1 =Sheet2!A1 ... cell B1 = Sheet2!A2...

Thanks for that Geoff.... It works a treat... One final thing I also have a column with pre-filled targets which need to be moved down a similar way, how would i do that? The above works with new data, is there a way I can offset the selection. Thanks

Thanks for this Peter So do you have any ideas on how to make this a moving 12 month range? Thanks Andrew