Search results for query: *

Is there a way to fill the prompt box with a default answer (which the user is able to change, of course)? Thanks, MK

Ok, thanks. It looks like the right stuff, I just don't get how I can grow the range. How could I add a cell(either up or down) to a, say, single column range of five cells? I need to do that with a formula or function, not manually. Thanks again, MK

=MATCH(1;E49:E52;0) Looking for number 1 with the above formula, but since the array changes from time to time, I would like to change the array address as well. Is there a way to manipulate cell addresses so that instead of fixed cell addresses I'd have two inner functions that return the...

Tried that, didn't work. I'm particularly interested in the web archives, but I get them neither because I have no password/smthng. Hmm, perhaps someone does and is willing to post it here for all to see:)?

Does anyone know what happened to this? I've tried to send them mail and register a couple of times, I even mailed the webmaster but it just seems dead.

I would break the table into smaller bits and then add the rows. After that you can put the pieces of the table back together. Extra rows are easy to add by adding a whatever calculation to the bottom of the table. Replace the formulae with your own, delete possible extra cells and that's it.

What kind of a query did you have in mind? If the query is run within the universe, it should be possible and even easy.

Disassociate LOV from date, if feasible. If you need date's LOV later on, you can always create a copy of the date object and use it instead for this trick. Create a copy of the bill number object (BN2 from this on). In the BN2's "Where" box, create a restriction where billing# date...

I can't see why you couldn't just go ahead and insert a row below the GM row, then enter the gm/sales-formula in there. That row would then appear throughout the report in the same place...? What exactly goes wrong when you try to insert a new row?

Of course, you might want to try creating an alternative object into the universe that prompts you for the society. Then you should be able to prompt for the members of that society on a report level. Worked for me, at least.