Delete row form closed workbook with a input box.

Hi Guys,

I am trying for days already to fix this. It has to be easy but i am not an expert, so can you help me.

I have two files.

1 Deliveries.xlsm
2 Data.xlsm (Closed)

When i am in the delivery file and by pressing a button it will ask me with a "Inputbox" for a delivery number.
Then it will search for it in Column A in Data.xlsm and delete that entire row.

That's it.

Thanks for your help.

This is like a pseudo code based on my GUESS.

Please Login or Register  to view this content.

Hi jindon,

Thanks it works.