Brian Barker <b.m.barker <at> btinternet.com> writes: > > At 20:11 18/12/2010 +0000, Mark Knecht wrote: > >Is it possible to link two Sheets in a Calc spreadsheet to two > >external CSV files? [SNIP] > > >Is there a way to do this? > > Yes. Use Insert | Sheet from File..., browse to the .csv file, and > tick the Link box in the Insert Sheet dialogue. You'll want two > sheets linked to your two data files and a third sheet (probably in > front) in which to perform the comparison. > > I trust this helps. > > Brian Barker >
I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? I don't want to have to do an Insert every time by hand. That's what I'm doing now, albeit using copy/paste. Thanks, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
