macro to populate a table

[WHWALDREP]

if some could help me get started on this, I'm trying to take list off a sheet called List ( attached pic ) and populate the table on a sheet called I-O List,
there is already a formula to get the Module type and calulate the data, on the list it shows how many Inputs and Outputs it has so I need it to look like the final pic I attached, it will basically say if inputs = 16 it will start at 0 and go up. I just don't know how to populate a table, and count up from 0. and the last objective is theres a column called X if the cell is empty I don't want to calculate the line on the list, if it = X then I do.


Thank You,
for you time to even reading this and if you could assist please respond.

\1
\1
\1

[rylo]

Hi

Rather than a series of pictures, can you zip up a small excel example file showing the before and after situations.


rylo

[WHWALDREP]

Hi

Rather than a series of pictures, can you zip up a small excel example file showing the before and after situations.


rylo

Yes, I can it just has to be in excel 2007, so I posted pics, also I just relized one pic, is wrong. I will post it when I get back to work, Thank You for your response.

[WHWALDREP]

Here is the example file in 2007 format with corrections made, thank you in advance for any help that can be provided.

[rylo]

Hi

Tried to open it but the converter failed.

Can you do a save as a 2003 version and reload....


rylo

[WHWALDREP]

Here's the 2003 format, it shold look close to what it is, table reference will be off, but I can fix those if you could just get me started please.

[rylo]

Hi

This doesn't do any of the formatting, but I think it will transfer the data across for you.

Put it into a general module, and see how it goes. It will clear any existing data in the output sheet columns F:M before it starts moving the data across.

Please Login or Register  to view this content.

rylo

[WHWALDREP]

Thank you I will give it a try and post back the results.

[WHWALDREP]

How can I check for the X in coulmn B befor it process that row of data?

[rylo]

Hi

I'm assuming that you don't want to process the items with an X in column B. I'd bring in column B to the output area, then delete those rows, then do the rest of the processing.


rylo