Trying to copy data from one worksheet to another based on cell text [closed]
up vote
0
down vote
favorite
I have my data in columns A:L in Sheet2 and wish to copy each block based on the starting point, as certain cell text and the end point, again as certain cell text!
So in the example the cell start text should be "Tank Engine" and the cell end text would be "INFORMATION: Tank Engine". Therefore, column A:L, rows 4:21 should be copied into Sheet3 at cell A1, but only where the cell text exists as this can be dynamic. I need to reference column A to paste to in Sheet3, and copy only the rows that begin with "Tank Engine" and end with "INFORMATION: Tank Engine", which are rows 4:21. The next block would be Columns A:L, rows 32:48 based on the string "Weatherman" and this being pasted into Sheet3 Cell M:X etc.....
The rows are dynamic the columns are static.....
Many Thanks!!
microsoft-excel vba
asked Nov 19 at 11:58
Mike
1
closed as unclear what you're asking by bertieb, Burgi, Anaksunaman, G-Man, Ben N Nov 22 at 1:50
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
0
down vote
favorite
I have my data in columns A:L in Sheet2 and wish to copy each block based on the starting point, as certain cell text and the end point, again as certain cell text!
So in the example the cell start text should be "Tank Engine" and the cell end text would be "INFORMATION: Tank Engine". Therefore, column A:L, rows 4:21 should be copied into Sheet3 at cell A1, but only where the cell text exists as this can be dynamic. I need to reference column A to paste to in Sheet3, and copy only the rows that begin with "Tank Engine" and end with "INFORMATION: Tank Engine", which are rows 4:21. The next block would be Columns A:L, rows 32:48 based on the string "Weatherman" and this being pasted into Sheet3 Cell M:X etc.....
The rows are dynamic the columns are static.....
Many Thanks!!
microsoft-excel vba
asked Nov 19 at 11:58
Mike
1
closed as unclear what you're asking by bertieb, Burgi, Anaksunaman, G-Man, Ben N Nov 22 at 1:50
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
3
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have my data in columns A:L in Sheet2 and wish to copy each block based on the starting point, as certain cell text and the end point, again as certain cell text!
So in the example the cell start text should be "Tank Engine" and the cell end text would be "INFORMATION: Tank Engine". Therefore, column A:L, rows 4:21 should be copied into Sheet3 at cell A1, but only where the cell text exists as this can be dynamic. I need to reference column A to paste to in Sheet3, and copy only the rows that begin with "Tank Engine" and end with "INFORMATION: Tank Engine", which are rows 4:21. The next block would be Columns A:L, rows 32:48 based on the string "Weatherman" and this being pasted into Sheet3 Cell M:X etc.....
The rows are dynamic the columns are static.....
Many Thanks!!
microsoft-excel vba
asked Nov 19 at 11:58
Mike
1
I have my data in columns A:L in Sheet2 and wish to copy each block based on the starting point, as certain cell text and the end point, again as certain cell text!
So in the example the cell start text should be "Tank Engine" and the cell end text would be "INFORMATION: Tank Engine". Therefore, column A:L, rows 4:21 should be copied into Sheet3 at cell A1, but only where the cell text exists as this can be dynamic. I need to reference column A to paste to in Sheet3, and copy only the rows that begin with "Tank Engine" and end with "INFORMATION: Tank Engine", which are rows 4:21. The next block would be Columns A:L, rows 32:48 based on the string "Weatherman" and this being pasted into Sheet3 Cell M:X etc.....
The rows are dynamic the columns are static.....
Many Thanks!!
microsoft-excel vba
microsoft-excel vba
asked Nov 19 at 11:58
Mike
1
asked Nov 19 at 11:58
Mike
1
asked Nov 19 at 11:58
Mike
1
asked Nov 19 at 11:58
Mike
1
asked Nov 19 at 11:58
Mike
1
1
closed as unclear what you're asking by bertieb, Burgi, Anaksunaman, G-Man, Ben N Nov 22 at 1:50
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by bertieb, Burgi, Anaksunaman, G-Man, Ben N Nov 22 at 1:50
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
3
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22
add a comment |
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
3
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
3
3
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sorry, it won't let me post pictures!
– Mike
Nov 19 at 12:15
3
please upload your picture to a hosting site (imgur.com) and edit your question with a link to it. Someone with enough reputation will post it for your. If you could also post the code you have so far, it would be helpful
– cybernetic.nomad
Nov 19 at 12:22