0MM0
05-10-2013, 03:31 AM
On my job I am every day dealing with one problem. Because of that I need solutioN for doing it automaticly.
Description:
When I open Excel document there is a lot of cells from A1,A2, ...
I want next: when I (CTRL+mouse click) on 7 different places randomly choosen, I want to VB software remember order of selected cells from 1-7. Then I want to copy those cells to a new excel file named "L1".
You can see example of exc. document where are thoose 7 cells that I want to copy.
postimg.org/image/dexdw08df/
New excell file looks like on next picture ( NEW second file is not empty, it has before created base like on picture BELOW). and 7 selected cells have to be coppied always on positions: A14, C14, D14, F14, A6, I1.
postimg.org/image/i3b1es8e9/
Every time when I select another 7 cells and run VB code it has to be created a new excell file in specified folder lik on picture below
postimg.org/image/5qn3wmn43/
I hope somoeone will help me to solve this problem. Be free to ask me additional questions.
Sincerly,
MM
Description:
When I open Excel document there is a lot of cells from A1,A2, ...
I want next: when I (CTRL+mouse click) on 7 different places randomly choosen, I want to VB software remember order of selected cells from 1-7. Then I want to copy those cells to a new excel file named "L1".
You can see example of exc. document where are thoose 7 cells that I want to copy.
postimg.org/image/dexdw08df/
New excell file looks like on next picture ( NEW second file is not empty, it has before created base like on picture BELOW). and 7 selected cells have to be coppied always on positions: A14, C14, D14, F14, A6, I1.
postimg.org/image/i3b1es8e9/
Every time when I select another 7 cells and run VB code it has to be created a new excell file in specified folder lik on picture below
postimg.org/image/5qn3wmn43/
I hope somoeone will help me to solve this problem. Be free to ask me additional questions.
Sincerly,
MM