S
stevemyers
I have a spreadsheet (duh) structured as below:
A B C D
1 123 aa bb cc
2 231 ad sd cf
3 123 sw dr fr
4 123 ws fr ft
5 321 gr te gt
I wish to dynamically read this worksheet and transfer the data t
another spreadsheet. i.e. Reading column "A", transfer all of the row
containing "123" to another spreadsheet without blank rows, as follows
A B C D
1 123 aa bb cc
2 123 sw dr fr
3 123 ws fr ft
I can read the info as I want using an array formula, except it insert
the blank rows. Thanks for the help
A B C D
1 123 aa bb cc
2 231 ad sd cf
3 123 sw dr fr
4 123 ws fr ft
5 321 gr te gt
I wish to dynamically read this worksheet and transfer the data t
another spreadsheet. i.e. Reading column "A", transfer all of the row
containing "123" to another spreadsheet without blank rows, as follows
A B C D
1 123 aa bb cc
2 123 sw dr fr
3 123 ws fr ft
I can read the info as I want using an array formula, except it insert
the blank rows. Thanks for the help