Create new Excel sheet containing data from current sheet.

Hello everyone,

I currently have a spreadsheet containing IP addresses and network information for a number of computers. Every now and again we have to import a huge number of these into a spreadsheet that can be imported. This follows a set format where the table headers are always the same accompanied by the data below.

Not sure if the spaces between rows will be a problem but they exist in the current spreadsheet so will have to try and find a way to get around it.

I would like to be able to run some VBA to export from my current spreadsheet, create a new file and add data into the desired format. This can then be saved and used.

I have attached an example so you can see what I mean.

Thanks in advance for any help!
Andy

Hi Olly,

Yes you are right, they are constants.

I basically need to take data from only certain columns in the data sheet, create a new sheet with headings and put the data into that sheet minus the gaps as in the original data sheet.

Thanks

Olly you are a genius! That works great for the example.

I will try and modify it to work with my actual sheet and will hopefully get what we need.

Rather than saving it as a new tab in the current document it would be better if we could create a new excel spreadsheet and then bring up the save As dialogue.

Will keep you posted,

Thank you so much
Andy