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前端其它相关文章！