Cutting value from column A and pasting it in previous row's column B

I need help writing a VBA script for Excel 2010 (Windows 7). I have thousands of entries set like this: Data ID Number1 (A1) Data Article Name1 (A2) Data ID Number2 (A3) Data Article Name2 (A4) Data ID Number 3 (A5) Data Article Name 3 (A6) Data ID Number 3 (A7) Data Article Name 3 (A8) ============= And I need it to look like this: Data ID Number1 (A1) Data Article Name1 (B1) Data ID Number2 (A2) Data Article Name2 (B2) Data ID Number 3 (A3) Data Article Name3 (B3) Data ID Number 4 (A4) Data Article Name4 (B4) I need to be able to do this as an automatic process, as I have a large amount of entries. *edit* changed the article to make it a bit clearer!
What have you tried? If you don't know where to begin, start by using the macro recorder.

以上就是Cutting value from column A and pasting it in previous row's column B的详细内容,更多请关注web前端其它相关文章!

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

评论 抢沙发

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

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

联系我们

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

支付宝扫一扫打赏

微信扫一扫打赏