Macro to Delete rows and columns

[bilalo94]

Hello

I have an excel sheet with 7 tabs that already have all formulas intact connected to each other.

Now this excel sheet has columns and rows for 15 funds. The reason its for 15 is because the maximum limit we use is 15, whereas the minimum is 9, so whenever we use less than 15, we manually have to delete the columns and rows in the excel tabs to remove all the N/A numbers and useless stuff. So my question is, how can I make 1 macro with a drop down menu probably to state if I want 9,10,11,12...15 funds, and after I run it, it will delete the rows and columns from each tab. I won't mind a macro that can count the amount of names I input to determine whether its 9,10,11 etc rather than a drop down menu.

Note: in the first tab, I have to delete 5 rows per fund (one after the other) and 0 columns, second tab 2 rows per fund that are 10 rows apart (ie. row E and row M), third tab, deleting boxes rather than rows/columns (not so imp, I can manually do this if its too complicated), fourth row: need to delete 2 columns and 2 rows for each fund I take out and the columns and rows are also ie. 8 rows apart and 15 columns apart respectively.

THANK YOU in advance!

[Richard Buttrey]

Hi,

For this sort of stuff I generally prefer to use a helper column which identifies whether a row should be deleted. This avoids the need to specify how many rows and which they are. Then I use a macro that filters on the helper column for the rows that need to be deleted and use code like:

Please Login or Register  to view this content.

The helper column cell could be a simple formula that recognises an error cell on the same row.
e.g.

=IFERROR(A1,"Delete")