I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or something like that.
What I'm trying to do is build an "add server" function. I need the search to query the rack and enclosure (which I can do) then I need to split the cell and insert a new row right after the next lowest slot number.
For example, the location column may look like this:
I need to be able to add a new row for say, G-05E2S05.
If this makes sense, I would greatly appreciate some input. I am a VBA beginner, but have pretty solid knowledge of programming techniques.