woodydapogi
New Member
- Joined
- Oct 30, 2019
- Messages
- 1
Hi,
I'm a newbie when it comes to excel, to be honest all I know was the basic stuff, I just learned the word macro earlier this day from my boss, currently reading some of it. I was tasked to sort/clean output of data to our sheets, I would like to ask on how to copy the rows with the same values to another sheets.
i.e:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]HR[/TD]
[TD="width: 64"]John[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Paul[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Denver[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Allan[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Hoyu[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Ukis[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Mo[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Ketdin
[/TD]
[/TR]
</tbody>[/TABLE]
Those names with "HR" will be copied to "HR Sheet" and those names with "IT" will be copied to "IT Sheet"
Thanks and regards,
Woody Pogi
I'm a newbie when it comes to excel, to be honest all I know was the basic stuff, I just learned the word macro earlier this day from my boss, currently reading some of it. I was tasked to sort/clean output of data to our sheets, I would like to ask on how to copy the rows with the same values to another sheets.
i.e:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]HR[/TD]
[TD="width: 64"]John[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Paul[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Denver[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Allan[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Hoyu[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Ukis[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Mo[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Ketdin
[/TD]
[/TR]
</tbody>[/TABLE]
Those names with "HR" will be copied to "HR Sheet" and those names with "IT" will be copied to "IT Sheet"
Thanks and regards,
Woody Pogi