Macro to build new sheet in workbook based upon contents of a different sheet in same book

Hello! I am need of some help writing a macro. Any help I can receive on this will be GREATLY
appreciated!

I have a workbook with 2 sheets: "sizing_feed_data" and "sizing_upload".
I need a macro that will "read" the data in the "sizing_feed_data" sheet record by record,
starting with cell 'B1' of the first record. If 'B1' contains a value (numeric), the macro needs
to copy the value of A1 on this sheet to A1 of the "sizing_upload" sheet, populate B1 and C1 with
the text 'Size' and D1 with the numeric value of '1' and copy the value that is in cell B1 of the
"sizing_feed_data" sheet to cell E1 of the "sizing_upload" sheet. The macro then needs to read
the value of C1 of the first record of the "sizing_feed_data" sheet and if it contains a value it
needs to create a second row on the "sizing_upload" sheet whose fields are all empty except E2
which should receive the value of C1 from the "sizing_feed_data" sheet. This process continues
until the macro finds the first field that is empty (no data) on record 1 of the
"sizing_feed_data" sheet at which point it "jumps" to record 2 of the "sizing_feed_data" sheet and
begins the process over, writing to the "sizing_upload" sheet. If it finds no value in B1 it
jumps immediately to the next row on the "sizing_feed_data" sheet (writing nothing to the
"sizing_upload" sheet) and begins processing data. This process continues until it comes to the
end of the data on the "sizing_feed_data" sheet at which time the macro finishes.

Am I clear on my question? If I too wordy or something, please let me know?

Much 'thanks' in advance!

The example below illustrates what I need to do:

Formatting on the "sizing_feed_data" sheet:

sizing_feed_data

A B C D E F G H I J K L M N O P
115031-100W 4 4.5 5 * * * * * * * * * * * *
115083-100W 4 4.5 5 5.5 6 6.5 * * * * * * * * *
115179-W 4 4.5 5 5.5 6 6.5 7 7.5 8 * * * * * *
117485-W * * * * * * * * * * * * * * *
411169-10 10 * * * * * * * * * * * * * *
490684 4 4.5 5 5.5 6 6.5 7 7.5 8 * * * * * *

Formatting on the "sizing_upload" sheet (how it should look after processing is complete):

sizing_upload
A B C D E
115031-100W Size Size 1 4
* * * * 4.5
* * * * 5
115083-100W Size Size 1 4
* * * * 4.5
* * * * 5
* * * * 5.5
* * * * 6
* * * * 6.5
115179-W Size Size 1 4
* * * * 4.5
* * * * 5
* * * * 5.5
* * * * 6
* * * * 6.5
* * * * 7
* * * * 7.5
* * * * 8
411169-10 Size Size 1 10
490684 Size Size 1 4
* * * * 4.5
* * * * 5
* * * * 5.5
* * * * 6
* * * * 6.5
* * * * 7
* * * * 7.5
* * * * 8

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Irish,

Try this:

Please Login or Register  to view this content.

Hi Gary,

Try this:

Please Login or Register  to view this content.