Hi everyone,
I want to copy a variable amount of rows from a sheet to another and extract columns from them. I reckon I could start choosing the rows manually and then launch the macro. (Perhaps implement a search function later.) For example in the case below I would like to copy all columns B,C,D and J to another sheet and have them pasted at a position i wish to choose manually and paste them in a different column order. How can I achieve this? Any ideas? Cheers
A B C D E F G H I J
company | 2010-04-03 | 13:45 | 15:45 | 13:45 | 15:45 | 120 | 213,60 | EUR | 89494
company | 2010-04-04 | 13:45 | 15:45 | 13:45 | 15:45 | 120 | 150,60 | EUR | 89495
company | 2010-04-06 | 13:45 | 15:45 | 13:45 | 15:45 | 120 | 100,60 | EUR | 89496
Bookmarks