Compare 2 Worksheets and Only Update Particular Columns

[superdrno]

Hey,
Thank you for taking the time to help me out. Please see attachment.

I have this workbook. In it are 3 works sheets.
-Main Database: This contains the latest most up to date database
-Export Data: A program is run to ouput the data from a different application
-Updated Database: Using the new Export Data it updates the Main Database.

Challenges:
-New rows could be added in. Ex: A new 1.1 was added in bumped everything down one and it created a new 1.4 as a result.
-Rows can be deleted like Section 3
-Columns C, D, E, H and I do not change
--It needs to be repopulated to in the updated Database

[vichopalacios]

Hi @ superdrno

I was checking your file and its needings.
I'm not sure to understand exactly what you want to do, but we can go step by step
Please check the new tab in the attached spreadsheet.
if you place the cursor over the cell in which you want to insert the new row, and right-click
you'll have done a procedure, that may be, fulfils your requirements.

If it's OK for you, we can go further on.
Keep in mind that this a first approach only.

[superdrno]

Hello vichopalacios,
Thank you. So from here if new information is taken in like the Export data. I need the new tab to add in new rows and remove rows that have been removed in the export.

Best,
Superdrno

[vichopalacios]

I'm sorry, I don't get your point...
I don't understand how you will use the different sheets in your workbook.
Just to clarify:

You have a sheet where you receive exported data from somewhere else ...("Export Data")
You need to have a sheet in which you make all changes...insert and delete rows....("Update Database")
then you copy this updated database to a sheet named "Main Database"

forget about sheet "New"; I just put it to show you how to do the job

Did you check if the right click accion is working properly?
Is it doing what is supposed to do?

[superdrno]

You are absolutely correct. The Updated Database tab will contain the latest database from the combination of Main Database and Export. Could you help me achieve this please.

And the right click did not work. It kept bugging out.

[vichopalacios]

Hi Superdrno

Just to know if I'm in the correct way, please re-check the right click:
Notice that you MUST do it over a cell in the first column
Captura1.JPG

and immediately appears a new row , and modify all the numbers downstream.
Captura2.JPG

if you right click anywhere else, it'll give you an error....we can manage it later.

[superdrno]

Vichopalacios, you are right. I see how it adds an extra row above the row you click on.