VLOOKUP after returning, delete the value base

[marreco]

Hi

I have a code that works well.
now I need to delete this code from my database if it finds the value that was returned to guide called "NOVA.BD"

That is, I need to look for the code on the sheet "BASE.DADOS.ANTIGA" value "X" to copy to the sheet "NOVA.BD" and eliminate the respective row in sheet "BASE.DADOS."


Cross-Post
http://www.thecodecage.com/forumz/mi...alue-base.html

[marreco]

HI

Any idea?

Thank you!!

[marreco]

Hi

I need the result returned from VLOOKUP, be excluded from my spreadsheet where my database

[excel-walker]

HI

So there is no need to delete the code from the file. Can you please explain us what exact output you are looking for?

Thanks
Excel-walker

[marreco]

Hi.
my VLOOKUP returns a value from a database, which called "BASE.DADOS.ANTIGA", this data will be returned in the "NOVA.BD"
after returning I need this data to be deleted from the database "BASE.DADOS.ANTIGA"

[marreco]

Hi
I need a VBA code to look in column "D" on the worksheet called "NOVA.BD"
after finding these values​​, go to the worksheet "BASE.DADOS.ANTIGA" and check if there is these values
if you encounter eliminate (delete) the row containing this value

Thank you!!

[HaHoBe]

Hi, marreco,

please give this code on a copy of your workbook a try:

Please Login or Register  to view this content.

Ciao,
Holger

[marreco]

once again was perfect!!
I can not click on the star

[HaHoBe]

Hi, marreco,

I can not click on the star ´

No problem with that - it should be a setting in vBulletin from the administrators on how many days should pass or many other users you need to spend some rep on before you may "donate" on me again (ar least it was like that when I was working with vBulletin 3.5.something and may still be).

Glad you got the problem solved.
Holger

[watersev]

different approach

[marreco]

Hi
great, tested it and it looks great!