HELP - Selected cell will display in new sheet

[ExcelUser2707]

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

[nathansav]

Yes, you'll need to look at WorkSheet_SelectionChange event to do this.

Please Login or Register  to view this content.

[ExcelUser2707]

Hi NATHANSAV

Thanks a lot for your reply.

Actually I am not getting your suggestion…can you please explain

Regards

Amar K

[nathansav]

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.

[ARGK]

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

[ExcelUser2707]

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

[nathansav]

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.

[nathansav]

ARGK
The OP says cell

"Can mouse selected cell will save / show in new sheet with the respective heading."

[ExcelUser2707]

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

[ExcelUser2707]

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

[ARGK]

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

[nathansav]

My only suggestion would be to have a button to do it or perhaps a right click to determine selection has stopped.

[ExcelUser2707]

OK SIR

thanks for your suggestion....

[HaHoBe]

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

[ExcelUser2707]

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

[HaHoBe]

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.

Please Login or Register  to view this content.

Ciao,
Holger

[ExcelUser2707]

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