Problem, again
 

Hi again,

I've came up with another problem.
The thing is like this. In a worksheet I have 7 coulms to use
(a,b,c,d,e,f,g). The first one (a) is the most important and all other
columns depend on that one. The user that uses it inputs numbers in the
rows. The next three columns (b,c,d) are also user defined (the user inputs
also numbers in those rows). Now, the last three columns (e,f,g) should be
locked (the user can't change the result in it). The 'e' column (the rows in
it) contains products (results) of rows in a and rows in b. The 'f' column
contains products of rows in a and rows in c, and the 'g' of rows in a and
d.
Now, the thing is that when you insert numbers in a and b, the product (i.e.
A1*B1) should appear in the e column. You can conclude that rows in columns
e,f and g must conatin functions. The best one is this type (if you know
better, just say) =IF(OR(A10;B10);A1*B1;""). The rows in e, f and g must
be hidden until the user enters data in A1 and B1 (you can see that from the
formula).
But, the thing is I can't copy/paste the formula through the whole column
(so it can work) because if I just copy/paste it thruogh let's say 2000 rows
in column e (the formula =IF(OR(A10;B10);A1*B1;"") ) and I input only 20
rows (20 numbers in a and b), there would be alot of pages when I print it
that are blank.
So, the thing is this: how to hide the formulas in columns e,f and g in rows
that are not used (there isn't any data inputed in rows of columns a and b)
so that when I print the worksheet it only prints the pages that are filled
with numbers through the whole row (there are numbers in a,b,c,d,e,f and g).
Hope you understand the problem.
This is pretty much urgent!!!!!!!

Thx

--
How does it sound when Darth Vader snores?!

Hi

Set autofilter for page with data on. Set autofilter for key column to 'Not
Empty' - only those rows with some value in key column are displayed.


Arvi Laanemets


"Elbowhite" wrote in message
...
Hi again,

I've came up with another problem.
The thing is like this. In a worksheet I have 7 coulms to use
(a,b,c,d,e,f,g). The first one (a) is the most important and all other
columns depend on that one. The user that uses it inputs numbers in the
rows. The next three columns (b,c,d) are also user defined (the user
inputs
also numbers in those rows). Now, the last three columns (e,f,g) should be
locked (the user can't change the result in it). The 'e' column (the rows
in
it) contains products (results) of rows in a and rows in b. The 'f' column
contains products of rows in a and rows in c, and the 'g' of rows in a and
d.
Now, the thing is that when you insert numbers in a and b, the product
(i.e.
A1*B1) should appear in the e column. You can conclude that rows in
columns
e,f and g must conatin functions. The best one is this type (if you know
better, just say) =IF(OR(A10;B10);A1*B1;""). The rows in e, f and g must
be hidden until the user enters data in A1 and B1 (you can see that from
the
formula).
But, the thing is I can't copy/paste the formula through the whole column
(so it can work) because if I just copy/paste it thruogh let's say 2000
rows
in column e (the formula =IF(OR(A10;B10);A1*B1;"") ) and I input only 20
rows (20 numbers in a and b), there would be alot of pages when I print it
that are blank.
So, the thing is this: how to hide the formulas in columns e,f and g in
rows
that are not used (there isn't any data inputed in rows of columns a and
b)
so that when I print the worksheet it only prints the pages that are
filled
with numbers through the whole row (there are numbers in a,b,c,d,e,f and
g).
Hope you understand the problem.
This is pretty much urgent!!!!!!!

Thx

--
How does it sound when Darth Vader snores?!