Hi experts
Require your valuable help/ guidelines again
Can mouse selected cell will save / show in new sheet with the respective heading.
I uploaded illustration file.
Thanks in advance
Amar K
Hi experts
Require your valuable help/ guidelines again
Can mouse selected cell will save / show in new sheet with the respective heading.
I uploaded illustration file.
Thanks in advance
Amar K
Last edited by ExcelUser2707; 06-09-2014 at 06:32 AM.
Yes, you'll need to look at WorkSheet_SelectionChange event to do this.
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hi NATHANSAV
Thanks a lot for your reply.
Actually I am not getting your suggestion…can you please explain
Regards
Amar K
There is an event in the sheet, the original sheet, called Worksheet_SelectionChange this is triggered when the mouse/cursor keys select a different cell, so in that event in your workbook, you'll need to add my code line, and change the names of NewSheet to what ever yours is.
Hi Nathan
I dont see how your code will work. Amar's request was to request that selected cells are automatically copied to a new worksheet with their relevant headings. I am not sure this is possible even with VBA as how does Excel know when you have stopped selecting your required cells. Your code line relates to SelectionChange and he is not changing anything he is merely highlighting cells.
Happy to be proven wrong though .
Tony
Thanks ARGK
You are right, I don’t want to track changes…..
If there is any other solution e.g. yellow / colour highlighted will appears in new sheet etc
Thanks
Amar K
It would need to be triggered by a button then,
then
Please Login or Register to view this content.
Something like that, not in Excel at mo, so not tested.
ARGK
The OP says cell
"Can mouse selected cell will save / show in new sheet with the respective heading."
When you have time, pleas upload a code written sample file…
It will help me to understand the scenario
Thanks in advance & waiting for your reply
Amar K
Hi,
If system can’t recognize when selection is stop
There is any other way to do this task………
It is possible to colour cell will save / show in new sheet or within the sheet
Any helps in this regard will very appreciated
Thanks in advance
Amar K
Hi Amar
I am ure when Nathan gets time he will respond to you. I am not sure what you are requesting can be done but I would love to proven wrong.
Tony
My only suggestion would be to have a button to do it or perhaps a right click to determine selection has stopped.
OK SIR
thanks for your suggestion....
Hi, amar.kshirsagar,
just for my curiosity: you have 4 cells highlighted in the original post in Row 2 and 4 cells in Row 4 yet your result on Sheet2 features 6 headings, 5 cells from Row 2 and 6 cells from Row 4. Any more detailed explanations on how to handle that?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks for replay
Sir you are absolutely correct, my sample file have incorrect information.
As I shown result, i.e. sheet2. shows value of such cell which is not highlighted in colour.
Rectification of attachment is done.
Regret for inconvenience
Thanks for kind guidelines
Amar K
Hi, amar.kshirsagar,
this is one way to start towards a solution - you would have to work on copying the formats over. Basic idea is to build a range on Sheet1 whenever you select cells with the mouse. Execution of the code will start if you leave Sheet1 but only if more than 1 cell and one area is selected, contents on Sheet2 will be cleared and copied over (you may try to use .Text instead of .Value).
Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Sir,
Thanks a lot for your advice
Great code, thanks very much to share valuable guideline.
I appreciated your knowledge, god bless you
Thanks
Amar K
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks