Shazir
Banned - Rules violations
- Joined
- Jul 28, 2020
- Messages
- 94
- Office Version
- 365
- Platform
- Windows
I do not know that where from i should start so posted my problem here to get the solution.
I have two sheets named Sheet1 and Sheet2.
Sheet1 has data which is available in row 4 and 5, where code will fetch that in row 4 has word "KP" then code will copy the exactly data available under word "KP" to end of the data (Data of row 5 will be copied). Row can be changed up to 10 rows to fetch the word "KP".
The code will not copy the data which is before the word "KP" that is highlighted. If "KP" is available in any of the row that is up to 10 rows then data will be copied from below row of that specific word "
I have pasted the required data into Sheet2 which is required from Sheet1.
Help would be highly appreciated in this regards.
That is Sheet1
That is Sheet2
I have two sheets named Sheet1 and Sheet2.
Sheet1 has data which is available in row 4 and 5, where code will fetch that in row 4 has word "KP" then code will copy the exactly data available under word "KP" to end of the data (Data of row 5 will be copied). Row can be changed up to 10 rows to fetch the word "KP".
The code will not copy the data which is before the word "KP" that is highlighted. If "KP" is available in any of the row that is up to 10 rows then data will be copied from below row of that specific word "
I have pasted the required data into Sheet2 which is required from Sheet1.
Help would be highly appreciated in this regards.
That is Sheet1
That is Sheet2