Recent content by huwwilliams

Thanks for the replies guys. Sounds like my time would be better spent studying the apparently excellent 'First Steps'. Regards, Huw.

Wayno, Sorry to be so long getting back - been busy. Yes, I think PivotTables may be a good solution, but you may have to learn a bit about using them. I see you have further requirements and another thread going. I'll take a look later and see if I have any ideas for you. I think in general...

Does anyone have any knowledge of the 'Winters Investment Network' free seminars being offered by email via ADVFN? Cheers, Huw.

Sorry, Wayno, wasn't concentrating! Is this what you mean?

spreadsheet Hi Wayno, I think I've got what you mean, I've amended the first two rows to do what I think you want, with a summary at the bottom. It's a bit rough, but I think you'll figure out what I mean. Datatable / PivotTable may still be more elegant, but I'll need a bit more time to put...

P/L Spreadsheet Wayno, I don't yet trade myself, but do know spreadsheets. Not sure of your exact requirement, but suggest you consider a database format, with a pivottable to summarise the data. I've attached an example (Excel 2000) to give you an idea what I mean. Regards, Huw.