Text transfer from worksheet to worksheet into a comment box?

vaseline3194

New Member
Joined
Mar 7, 2014
Messages
6
Hi,

I was interested in creating a spreadsheet that would drastically save my time.


Essentially this is what I have:

I have a table in one of the tabs called Time.
The other tab is called Output.

Basically, I have track my every day time in the table from the time tab and in every row I put a description of what I did for that specific slot of time.
For example, I would have 9:00AM to 10:00AM. The description/comment would be “Team Meeting about cost cutting measures”
Is there a way (maybe using VBA) to take the “Team Meeting about Cost Cutting Measures” from theTime Tab and transfer that to the Output Tab?
I know you can link text, however, is there to make a popup if you click a certain cell, and in that cell, the text would be there?
Or, is it possible to transfer the “Description of Activity” to a comment box in the “Output tab”?

Thanks
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,223,897
Messages
6,175,271
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top