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
Bookmarks