Hi guys. I'd appreciate any help on this.
I have a basic spreadsheet with the first column being 'ID'. I want to be able to delete any row with data in by using VBA to code a macro that when ran by a button will open an input box - "Enter ID number of row you want to delete". The ID number will be entered and all data from that row will be deleted and the rest of the rows will move up to fill the space.