Could someone please help with creating some VBA code to create a comment in a cell depending on a value of a cell in another sheet?

TDotHanny

New Member
Joined
Sep 30, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi all,

New member here so apologies if this has been answered already, but I believe it is a pretty niche request. I've seen videos and articles relating to automatically creating comments based on other cells, but I need this to work based on an indexing in another sheet.

I've attached a link to an example spreadsheet which should hopefully explain what I'm looking to achieve. To give a bit of background, I've created a way of inputting individual 'builds' in the 'Jobs' sheet and they should then appear on the 'Gantt' sheet next to that Designer's name. What I'd ideally like to see is the contents of the corresponding cell in column D on 'Jobs' appear as a comment in the last relevant cell on the 'Gantt' chart.

I'm completely green when it comes to coding, so would appreciate any help with this. Hopefully it's not too difficult, but if it is, I hope it comes as a welcome challenge to someone!

Link to spreadsheet
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,524
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi TDotHanny,

Welcome to the MrExcel Forum. You may want to post your spreadsheet to a file sharing site such as DropBox or something similar. The way I see it, your biggest challenge would be getting someone to click on a shortened URL from the first post of a new member (I clearly would not). Good luck.
 

TDotHanny

New Member
Joined
Sep 30, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi igold,

Fair point, thank you! Didn't think of that! Would it help if I simply put the full wetransfer URL, or would I have to use Dropbox?

 

Watch MrExcel Video

Forum statistics

Threads
1,128,061
Messages
5,628,369
Members
416,314
Latest member
Dan99321

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
Top