Hello, I'm using XL07 and have a WB with 83 Sheets of text and I wish to do the following:
Each WS has data as below:
---A--------B----C---
1 text------text--text
2 text------text--text
3 text------text--text
4 text------text--text
5 text------text--text
6 text------text--text
FIRST, I wish to add 5 rows at A2, as below
----A--------B----C---
1 text------text--text
2 INSERTED ROW WITH TEXT ONLY IN A2, B to end are blank
3 INSERTED ROW WITH TEXT ONLY IN A3, B to end are blank
4 INSERTED ROW WITH TEXT ONLY IN A4, B to end are blank
5 INSERTED ROW WITH TEXT ONLY IN A5, B to end are blank
6 INSERTED ROW WITH TEXT ONLY IN A6, B to end are blank
7 text------text--text
8 text------text--text
9 text------text--text
10 text------text--text
11 text------text--text
Then I will be manually adding data in B2:B6 and C2:C6
NEXT, I wish to extract the data from ONLY A1, B2:B6 and C2:C6 and paste as follows in blank WS 84.
----A----------B---------------C-----
1 blank-------WS1 A1-------WS2 A1
2 blank-------WS1 B:2------WS2 B:2
3 blank-------WS1 B:3------WS2 B:3
4 blank-------WS1 B:4------WS2 B:4
5 blank-------WS1 B:5------WS2 B:5
6 blank-------WS1 B:6------WS2 B:6
Please advise, and thank you for such a wonderful board.
Each WS has data as below:
---A--------B----C---
1 text------text--text
2 text------text--text
3 text------text--text
4 text------text--text
5 text------text--text
6 text------text--text
FIRST, I wish to add 5 rows at A2, as below
----A--------B----C---
1 text------text--text
2 INSERTED ROW WITH TEXT ONLY IN A2, B to end are blank
3 INSERTED ROW WITH TEXT ONLY IN A3, B to end are blank
4 INSERTED ROW WITH TEXT ONLY IN A4, B to end are blank
5 INSERTED ROW WITH TEXT ONLY IN A5, B to end are blank
6 INSERTED ROW WITH TEXT ONLY IN A6, B to end are blank
7 text------text--text
8 text------text--text
9 text------text--text
10 text------text--text
11 text------text--text
Then I will be manually adding data in B2:B6 and C2:C6
NEXT, I wish to extract the data from ONLY A1, B2:B6 and C2:C6 and paste as follows in blank WS 84.
----A----------B---------------C-----
1 blank-------WS1 A1-------WS2 A1
2 blank-------WS1 B:2------WS2 B:2
3 blank-------WS1 B:3------WS2 B:3
4 blank-------WS1 B:4------WS2 B:4
5 blank-------WS1 B:5------WS2 B:5
6 blank-------WS1 B:6------WS2 B:6
Please advise, and thank you for such a wonderful board.
Last edited: