Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2021, 07:54 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Help with a script to find Duplicate data in the same row of a table or tables Windows 10 Help with a script to find Duplicate data in the same row of a table or tables Office 2019
Competent Performer
Help with a script to find Duplicate data in the same row of a table or tables
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default

Hello Andrew,


I'm wondering if my request is doable or not, bottom line, I need to compare two Tables or whole documents of Tables only but with different language format (ENGLISH vs FRENCH). All amounts should be alone in its cells. I'm trying to catch typo errors or amounts numbers that has NOT been updated/corrected.

I'm searching to compare the numbers only. Numbers are 95% of the time as of column 2.

This macro with the link I've provided in my initial request, uses two columns, and it highlights if the second columns have similar values to the first column on the same row, thus 222,512 (English) vs 222 512 (French), so the variables 222 & 512 were highlighted in the second column.

Maybe there's a better logical way to flag differences, that I don't know. Not sure how to go about doing this.

I can handle Find and Replace the punctuations (find all the following in a table: comas, non breaking space, period (for decimal) which could be flag with colors/highlights, I'm just new to understanding ''Duplicates'' or ''Differences'' with VBA.

Note, it will vary from table to table, so not always constant in each tables, and documents.

With my experience with VBA, I was thinking, I should trying to copy the English formatted numbers' columns unto a blank Word document, paste them on one side, and copy French formatted numbers on another side of a same table, while putting a column Gap to separate the two.

My thinking with my VBA programing experience, was to Flag/Highlight any variable on the same row (since I've copied English/French tables in the same table) that are either Similar, or is it better to flag if they are Different?
****However, as I'm thinking now, Maybe it would be better to Highlight cells Rows that are different. / to catch the errors.****

Is there a better way? Any insight would be appreciated.


Cendrinne
(I hope I wrote my question clearly?)
Reply With Quote
Reply

Tags
duplicate in tables, help please, highlight cells



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help to Script to align all the tables only as of a section to end of doc? Cendrinne Word VBA 4 04-05-2021 11:37 AM
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? jsisley Excel 1 07-21-2017 09:20 AM
Help with a script to find Duplicate data in the same row of a table or tables VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color jc491 Word VBA 8 09-30-2015 06:10 AM
Script starts nesting tables without reason selman555 Word VBA 1 10-17-2014 01:01 AM
Pivot Table Duplicate Data cnw Excel 0 08-31-2012 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 PM.


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