I
Ivan Koh
Hi all,
Is there a function that i could use to compress empty blanks together?
For example if rows 2, 5, 10 have entries, could i collapse row 2 to row 1,
row 5 to 2 and row 10 to 3?
Also is there a way that i could lock information to prevent editing to it
unless it's from the main worksheet?
I.e to say that information from cell A of worksheet A is pulled to cell A
of worksheet B. Information from cell A of worksheet B can't be edited but
cell B of worksheet B can be edited.
Cos currently i realise that if i were to edit information in a cell that
had information pulled over from cell a of worksheet a, it would cause the
information to disappear.
Also does this function contradict with my previous request to collapse the
cells together?
Thanks
Ivan
Is there a function that i could use to compress empty blanks together?
For example if rows 2, 5, 10 have entries, could i collapse row 2 to row 1,
row 5 to 2 and row 10 to 3?
Also is there a way that i could lock information to prevent editing to it
unless it's from the main worksheet?
I.e to say that information from cell A of worksheet A is pulled to cell A
of worksheet B. Information from cell A of worksheet B can't be edited but
cell B of worksheet B can be edited.
Cos currently i realise that if i were to edit information in a cell that
had information pulled over from cell a of worksheet a, it would cause the
information to disappear.
Also does this function contradict with my previous request to collapse the
cells together?
Thanks
Ivan