[thelist] OT Excel question
Geoff Sheridan
evolt at premonition.co.uk
Wed Apr 7 13:15:08 CDT 2004
Forgive me - I spend all day in XPress, Photoshop or BBEdit and
haven't much of a clue about Office Apps.
I am setting up Excel spreadsheets for my accounts.
A lot of information has to be repeated in both 'sales' and 'bankings' sheets.
I have discovered Links so that in the banking sheet
=Sales!A7
Will copy info from A7 in the Sales sheet.
But I'd like to copy various cells from the sales sheet.
I don't need every column copied.
They need to be re-ordered - the sale in row 12 might be paid before
the sale in row 8:
=Sales!A7 =Sales!E7 =Sales!G7
=Sales!A12 =Sales!E12 =Sales!G12
=Sales!A8 =Sales!E8 =Sales!G8
... so really I need to replace the row numbers (7,12 and 8 in the
example) with a variable which persists across the row, so they fill
in automagically. Any ideas?
<tip type="dirty type in photoshop" author="geoff sheridan">
Make any type dirty, quickly. If you apply the spatter filter to a
type layer in photoshop, the result is rubbish. (It spatters only
inside the text.) SO: fill a layer under the type layer with white,
select the type layer and 'merge down' in the layers palate. Then
apply the spatter effect. Sorted. Lose the white by setting the layer
blending properties to 'multiply'.</tip>
--
-------------------------------------------------------
Premonition Design Ltd
http://www.premonition.co.uk/
East London, UK
More information about the thelist
mailing list