I need help with a macro that will select data to the end of the row. Each sheet has the same basic formatting. A1 contains a name. B1, C1, D1 are column headers. B2:B is data. C2:C is data and always stops at the same row B2:B range does. The only differences between the sheets is that they might not stop at the same row. I want a macro that merges A1 vertically as shown in my spread sheet to the end of column B and C. I want a border around the merged data, as well as around the B data and the C data individually.
I need a macro that selects B2 through the end of the items on B and selects it, then formats it accordingly. Then I need a macro or the same macro that selects C2 through the last row of the C column.
Here's the same spreadsheet with a macro that merges A1. Now I just need it to go from b2 through the end of B and then from c2 through the end of c. I've played with it so much over the past few weeks as well as with help and suggestions from people that got me this far and I'm giving up on it now. Please help.. Thanks in advance
Bookmarks