how to make a macro to remove the empty columns or rows.
example is in this excel file is when i hit the go button it will gather data from a webpage.
I also want it to automatically delete a certain row/column that is empty and also column d to be named Season and column c to Week so all the data can be together next to each other all at once while i hit the go button.
since column e,k,l,r, and s are empty cells i want it to automatically removed(delete) the column/row. except column d i want it to rename the cell to Season and column c where it labels G I want it to rename cell to Week.
can someone help me on this??
thanks so much!!
Bookmarks