A B C D E
1 Server1 Windows 2003 2 x XEON Adobe Acrobat Version 8.0
2 CommVault Version 9.0
3 Java Version 6.0
4 Server 2 Windows 2008 1 x XEON Adobe Acrobat Version 6.0
5 MS Silverlight Version 4.0
6 McAfee Version 4.6
I would like to start with a Workbook with just the above Worksheet.
The VBA would create tab(s) (aka worksheet(s)) from Column A (example., A1 then A4)..
Next it would copy all row data from column B, C, D & E until it hit the next value in column A (in this case A4, or Server 2). It would then populate the tab named Server 2 with the row data from column B, C, D & E