Excel formula help....

GIBURROWS · 25 Aug 2022 at 06:19

I have a spreadsheet which I have organised but I need to remove full rows of data that have certain words in certain columns (area managers and coordinators) and is it possible to attach it to a macro?

Thanks in advance for any help

GIBURROWS · 25 Aug 2022 at 13:45

Yes but I'm trying to sync into one motion.

GIBURROWS · 25 Aug 2022 at 15:57

Cadder said:
VBA Macro to Delete Rows Based on Cell Values or Conditions in Excel

Learn how to use VBA macros to delete rows based on cell values or conditions in Excel. Includes sample code and video tutorial.

www.excelcampus.com

Any good?

Oooh you legend!

GIBURROWS · 28 Aug 2022 at 10:30

I'll look into power query.

So my question is that it can all be done with one hit basically, get rid of the 10 top rows and shift the data up, delete the left column and shift the data left, then delete entire rows if a certain column contains a specific word or words?!?

GIBURROWS · 28 Aug 2022 at 10:47

gpuerrilla said:
Yes. Drop me a message @GIBURROWS if you need any help.

You can set it so all you have to do is drop in the fresh file and it will update the output in seconds.

Thank you, I'll give it a go myself first.