Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2024, 01:10 AM
ArviLaanemets ArviLaanemets is offline Add comments to a table data Windows 8 Add comments to a table data Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by massimodfd View Post
Thank you! But I need to update the comments column of main table, how can I update my comments if there is a formula vlookup inside?
thanks for help!
You can't, unless the main table remains always same, or you update your main table manually row-wise! In case the main table can change, and you must keep old comments, you must have those comments updated in another table.



Another possible solution will be having a separate table where you copy new data, and then run a VBA procedure, which compares both new and old data row-wise, and overewrites row-wise old data when there is some difference. What I adviced is much easier, I think!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
extract data from table based on data from another table zevbn Excel 7 12-10-2023 12:46 AM
Creating a dynamic table pulling data in through data.dot file from database. njacobs Word VBA 4 12-14-2021 07:41 AM
Add comments to a table data use existing table data and not get generic excel chart data canar Word Tables 3 09-08-2015 03:36 PM
Retrieving data from cell Comments RogerB Excel Programming 3 06-16-2014 03:04 AM
Copy all comments & cell contents (i.e. data) to word? IanM Excel 0 07-03-2010 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft