Trying to create an Excel Macro

**RookieProgrammer** · 07-12-2011, 07:17 PM

Here is my issue:

I use an application that generates Excel exports. In this export each tab corresponds to one table. I ultimately want to create one Tab with all the tables in it (one under the other in sequential order) with the following formatting:The first line of every table is bolded. A column is inserted at the begining and the first line is cut into that new column.

Can anyone tell me how would I go about creating this macro please?

**Mordred** · 07-12-2011, 08:15 PM

Hi RookieProgrammer, you first need to create one table with your exact criteria and then a couple of sheets worth of data that the tables will be drawing from. There are no doubt a couple/few ways to go about this but the community here would need specifics to work with. The data should be mock data only.

Regards:

**RookieProgrammer** · 07-12-2011, 08:21 PM

How do I post sample data? Sorry, this is my first time using a forum for help.

**Mordred** · 07-12-2011, 08:28 PM

No worries! Just below the box that you type in/respond in, you'll see the button Go Advanced. Click that and then click the link (the button with the paper-clip). Follow the prompts from there and you'll be fine.

**RookieProgrammer** · 07-12-2011, 08:43 PM

The first tab is what the output should look like at the end. And the 4 tabs after that are an example of what the data looks like normally. The number of Columns populated can/will varry and so will the number of rows and the number of tabs. The only thing that will remain constant is that the first line of every table is the header of that table.