I have 5 formated work sheets with information in columns a,b,c,d beginning on row 6. Each work sheet does not necessarily use the same lines and has blank lines throughout. I need to combine all the sheets into one sheet and remove any blank lines. Any help will be appreciated.
Rose