Problems getting good macros to work in new ways

[antonymiller]

I've been trying my hardest to apply the macro help I've received to other worksheets I use. With little luck.

Specifically, I have an inventory sheet that isn't vary complicated. I do a custom sort on it and everything condenses rather nicely but it is undreadable. So I've been asked to add empty rows between each line. The macro I am trying to use doesn't effect the entire row, only the first cell and it moves the headers as well. My limited knowledge is a problem in fixing that.

My second macro is meant to place a single box border around all the rows that contain the same ID number - all unique ID's are boxed in together for easier reading. Again, it just isn't working out that way. Mainly because I can't figure out how to alter to box things in correctly.

this is a macro that I'd really like to learn from as this is the kind of thing I get asked to do all the time, and I hate having to do it manually - takes forever.

I know both of these macros work - I got them here from very helpful people and have used them already in other forms successfully. I just don't understand VBA well enough yet to get them to work in a new worksheet with different layouts.


I have attached my workbook - any assistance would be appreciated.

Thanks

[royUK]

Once you start adding empty rows to a table you lose the sort & filter functions