Quote:
how to in one sheet place values from different sheets (30 row for each sheet).
|
Based on that much information, copy and
paste as values.
Quote:
Also is it possible to have that in sheet that collect values, hide empty cell but when cells in multiple sheet are filed, hidden cell are visible again
|
What do you mean by that?
To my knowledge you can hide a row (16,384 cells) or a column (1,048,576 cells) but not single cells.