If you have previously recommended this thread, you should see a tick / check mark on the recommend button. Click the tick to undo the recommendation (the tick may appear to change to a cross as you do this.) If you added a comment with your recommendation, you will need to delete that from your facebook wall separately.
Am setting up a load of invoices which will be named sequentially 01.xls, 02.xls etc.
I need to set up another xls sheet which basically summarises the invoices, displaying the number and then info from a specific cell from each invoice. The numbers will run sequentially.
So like this...
ColA ColB 01 =[01.xls]sheet1!F36 02 =[02.xls]sheet1!F36
Can I set the formulae in column B to generate automatically from what is displayed in Col A (Column A I want to put basically the first invoice number (depending which one Im starting from, so not necessarily 01) then in row 2 do A1+1 to sequence the numbers down.
If you do Paste Special -> Values into column C, column C should now contain a formula which returns the value of F36 from the appropriate spreadsheet. If it contains the same string as Column B, I think you just did 'Paste' instead of 'Paste Special -> Values'.
Email me the spreadsheet at mr dot anchovy at mranchovy dot com and I'll see if I can patch it up.
Katy that goes for you too, send it to me and I'll take a look, but no promises .
Sorry Katy, supressing blank rows or columns or worst of all just part of a row or column and moving the remainder into the gap is something that spreadsheets just weren't designed for. You can write macros to do it but they are a nightmare to maintain.