Hi,
Please help
I have sheets with two separate regions separated by blank columns. i need to copy the second region. in this case K1 to S10. i cant figure out how to include the blank cell in K1.
so much appreciation in advance!
thanks for looking folks
Please help
I have sheets with two separate regions separated by blank columns. i need to copy the second region. in this case K1 to S10. i cant figure out how to include the blank cell in K1.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
K | L | M | N | O | P | Q | R | S | |||
1 | case1 | case2 | case3 | case4 | case5 | case6 | case7 | case8 | |||
2 | item1 | value1 | value1 | value1 | value1 | value1 | value1 | value1 | value1 | ||
3 | item2 | value2 | value2 | value2 | value2 | value2 | value2 | value2 | value2 | ||
4 | item3 | value3 | value3 | value3 | value3 | value3 | value3 | value3 | value3 | ||
5 | item4 | value4 | value4 | value4 | value4 | value4 | value4 | value4 | value4 | ||
6 | item5 | value5 | value5 | value5 | value5 | value5 | value5 | value5 | value5 | ||
7 | item6 | value6 | value6 | value6 | value6 | value6 | value6 | value6 | value6 | ||
8 | item7 | value7 | value7 | value7 | value7 | value7 | value7 | value7 | value7 | ||
9 | item8 | value8 | value8 | value8 | value8 | value8 | value8 | value8 | value8 | ||
10 | item9 | value9 | value9 | value9 | value9 | value9 | value9 | value9 | value9 | ||
Sheet1 |
so much appreciation in advance!
thanks for looking folks