I hope you're well and safe. I am trying to create a macro to delete line items in another workbook but i am a total novice. After hours of research I am still struggling badly to the point where i feel useless. I was sincerely hoping some good people on this forum could help save me from throwing my laptop out of the window.
What i am trying to achieve;
Workbook 1 (2 x sheets)
- Sheet 1 - has a cell where the user inputs the file name of Workbook 2 which is to have line items deleted from it e.g. "Workbook 2 22-04-2021" which will be closed. Also has a button to run the macro.
- Sheet 2 - contains data in many columns but column A will be the deciding factor of which rows should be deleted in Workbook 2 - Sheet 1.
Workbook 2 (1x sheet)
- contains the data and the line items which are to be deleted if present in Workbook 1, Sheet 2.
Any help from the geniuses on here would be much appreciated and i would be forever grateful! X