Excel help
 

i need someones help

GOAL: press a button and have the worksheet hide all the blank rows.

so worksheet 1 is auto populated from worksheets 2, 3, and 4.

in worksheet 1, i want to filter out all the blank rows. but only the blank rows when column B is blank.

what i tried: recorded macro. > auto filter my headings, filter for blanks in column B, select blank rows and delete.

problem with this is i don't want to delete the rows because the info in the other sheets will change. and when i play this macro, it selects the same rows and removes them. i want the row selection to vary.

thanks! :bonk:

Start here, see if it leads you in the right direction
http://answers.microsoft.com/en-us/o...2-515b3c4f8a3d