Need help/ideas for a tricky row and column delete Macro

Hello! I'm new to the world of Excell Macro's and was wondering if anyone might have a simple Macro I could run that would compare Columns A and B then Delete Columns B through E for every row where Columns A and B do not match.

It gets tricky because the macro would need to start at row 1 and makes its way down the spreadsheet row by row shifting the cells up (columns B through E) as it deletes them. I'm sure this might be a simple thing to do for anyone with experience in this area but I'm somewhat baffled by it and could use any assistance provided. Thank you!

Sincerely,

Mr Noob

Hello Sixthsense!

Thank you for your reply. Column B to column E cells need to be deleted and shift cells up method should be used. I really hope this isn't a difficult one. Thanks again

Hi -

For me the deletion process is not needed, seems like finding a match between column A and B then pull those records in another sheet is much simple.

Regards,
event

I wonder if that could work. Its tricky because Column A goes 1,5,8,9,etc and Column B goes 1,2,5,6,9,etc. Perhaps if it is possible to write a Macro that would take Columns B-E and copy it to a separate spreadsheet in any instances where Column B matches Column A. Yes, I believe that might accomplish the same thing

I really hope a macro can be generated. So far I have been manually deleting Column B cells and shifting the cells up so that the lists match up properly. There are thousands of lines and I'm only a quarter of the way through.

Hi -

Post some dummy data.

Regards,
event

Thank you! That wasnt quite it but I think I know what I need to do now and this certianly helped a lot.