Macro to generate a list from a table

**Uzzgee** · 01-19-2015, 04:36 PM

Hi Everyone,

Hopefully this is an easy one which someone can help me with - cant seem to get my head round how to get this to work.

Example excel attached with original table and output list.

The output i am required to generate is a list ( containing two columns TIMEBIN,SITE) which provide the same number of records as that stated in the COUNT column for each timebin record..

I have shown in the excel sheet what i need - hopefully this all makes sense.

If i haven't explained myself properly then please feel free to ask further questions.

Thanks Uzz.

**mrice** · 01-19-2015, 04:59 PM

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

**Uzzgee** · 01-19-2015, 05:13 PM

Martin,

Works perfectly - many thanks for your assistance.

Regards

Uzz

**sktneer** · 01-19-2015, 05:15 PM

You may also try this.....

Please Login or Register  to view this content.

Macro to generate a list from a table

LinkBack

Thread Tools

Rate This Thread

Display

Macro to generate a list from a table

Re: Macro to generate a list from a table

Re: Macro to generate a list from a table

Re: Macro to generate a list from a table

Thread Information

Users Browsing this Thread

Similar Threads

Need to auto-generate a list from existing table using unique combos from set columns

Generate Unique List from Pivot Table

Generate Table from Drop-Down list

macro to generate sorted table from unsorted list?

Using Macro to link sql table to generate Pivot Table

Bookmarks

Bookmarks

Posting Permissions