Most valuable professional
  • Hot Topics

Excel Create Sheets And Copy data To Each Sheet

I have sheet 1 as laid out below I need a macro that will create sheets and name them the headings that is in row 1 starting in column C and copy their respective data. The amount of columns may vary on every file I use the code on. Excel 2010 1 2 3 4 Sheet1 This is how it would look with just a couple of the sheets as an example. Excel 2010 1 2 3 4 1 Excel 2010 1 2 3

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of July 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel