On my job I am every day dealing with one problem. Beacause of that I need solutio 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.

Izrezak troskovnika.PNG

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.

Izrezak list.PNG

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

Izrezak FOLDER.jpg

I hope somoeone will help me to solve thgis problem. Be free to ask me additional questions.

Sincerly,

MM