Excel values in different sheets

I have an Excel sheet like the one below Sheet name:`Raw` Data: > 1. Blue value1 value2 value3 value4 > 2. Green value5 value6 value7 value8 > 3. Black value9 value10 value11 value12 > 4. Blue value13 value14 value15 value16 > 5. Green value17 value18 value19 value20 . . . I want to automatically create different sheets named Blue, Green, Black and add these rows in there. So I would like to have: Sheet name:`Blue` > 1. Blue value1 value2 value3 value4 > 2. Blue value13 value14 value15 value16 Sheet name: Green > 1. Green value5 value6 value7 value8 > 2. Green value17 value18 value19 value20 Sheet name: Black > 1. Black value9 value10 value11 value12 Any idea?

以上就是Excel values in different sheets的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏