Creating a sheet from data in another sheet

[DavyC100]

Hi

I have created a form on sheet 1, basically it lists a number of assests and the boss selects how many of each assest is required. Is it possible to run a macro that will list each assest on the second sheet.

Example

Sheet 1

Question How many blue boxes are required - Answer 3

Question How many yellow boxes are required - Answer 7

And so on.

I would like to run a macro that will insert the word blue into cells a1, a2 and a3 on sheet 2, then insert the word yellow into cells a4, a5, a6, a7, a8, a9 and a10 in sheet 2, and so on.

Any help would be appreciated.

DC

[Ikaabod]

If the numbers are in a list in one column and the name you want to display is in a list one column to the left, select the list of numbers and run this code:

Please Login or Register  to view this content.

Here's an example:

Please Login or Register  to view this content.

[DavyC100]

Ikaabod thankyou it works an absolute treat.

DC