merging cells text between 2 or spreadsheets

G

genesius

I have 3rd party application that contains a table with 3 fields: 2 numeric,
1 text. I am able to export the table into an Excel Spreadsheet. I have
several of these spreadsheets that I want to combine as one. The reason I
have serveral spreadsheets is because when I have my PC crash, or reinstalled
the app on another PC, etc. The 2 numeric fields are counters containing the
numbers 1-31192(?). The text field contains notes from the 3rd party app.

The text field is where I am having the issue. Sheet A in the sheet to merge
all into. Sheet B is where the new data.
Compare each text cell in Sheet B with Sheet A.
If the data in Sheet B is not in sheet A, merge it into Sheet A.
If the data in Sheet B is in Sheet A, compare it. If they match excatly, do
nothing. If they don't match exactly, merge them into Sheet A. *I need a
temporary cell that indicates when this occurs so I manually correct them
later.

Thanks and God Bless,
Genesius
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Range headings 0
Identifying duplicates between 2 spreadsheets 0
How to Import Formatted text as new Slides in PowerPoint 0
External cell reference between two excel worksheets both in One Drive 0
Formating bolded text exclusively. 0

Top