Ok, I found it.

/David Pettersson

David Pettersson wrote:

I can't see how to use DataPilot for this.

What I need to now to do what I want is:
Is there a function to test if a cell is empty?
How do I concat a constant string to a cell content?
When I copy a formula, how do I prevent cell H4 to change to H5, H6, H7 ...
(while H6 in the same formula still should change this way)?

If I get the last questions answer I can complete my work, if I get all answered I can understand what I have done next month as well :)

/David Pettersson


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to