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
 

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