R
ryan.fitzpatrick3
I have a workbook that I would like to add some vba in. I originally
was going to use if statements in the excel sheet but I figured that
more than 7 would be needed, so this is why I need help with vba
coding. I have a macro code that pulls a table from access into excel.
Now that table on my (sheet3) has a bunch of information that I would
like to automatically populate into my 'data sheet' (sheet2). This is
why I was thinking either if statements and or index. I don't not know
how to ask what I want in statements/vba.
I have these names as my excel table headers.
Plant Vendor Item# Jan Feb Mar Apr May Jun Jul Aug Sep
Oct Nov Dec
1111 Alpha 101 58 7 14 6 19 21 22
23 78 89 94 44
2222 Beta 202 56 10 18 16 18 22 24
38 90 60 54 32
The information above is the information that would go in the rows
underneath the table headings of Plant, Vendor, Item #, etc, etc.
The access table that is pulled has these headings
Company, Branch, Vender ID, Vender Name, Item #, Item Description,
Month, Year, Quantity
US, 8103, 831381, ConAgra, 300365, FLOUR
HARD, 01, 07, 1,550,390
There are similarities that match (which I did on purpose). Now on the
macro in which I download the access information I would also like to
take the above information and put it into the correct row and cell
above. The issue I have is that there are several plants all have
several item #'s. This is why I was thinking of an if statement with
an index function but I do not know how to do this. If this is doesn't
make sense, I can email you a workbook with what I'm talking about and
would like to do.
Ryan
was going to use if statements in the excel sheet but I figured that
more than 7 would be needed, so this is why I need help with vba
coding. I have a macro code that pulls a table from access into excel.
Now that table on my (sheet3) has a bunch of information that I would
like to automatically populate into my 'data sheet' (sheet2). This is
why I was thinking either if statements and or index. I don't not know
how to ask what I want in statements/vba.
I have these names as my excel table headers.
Plant Vendor Item# Jan Feb Mar Apr May Jun Jul Aug Sep
Oct Nov Dec
1111 Alpha 101 58 7 14 6 19 21 22
23 78 89 94 44
2222 Beta 202 56 10 18 16 18 22 24
38 90 60 54 32
The information above is the information that would go in the rows
underneath the table headings of Plant, Vendor, Item #, etc, etc.
The access table that is pulled has these headings
Company, Branch, Vender ID, Vender Name, Item #, Item Description,
Month, Year, Quantity
US, 8103, 831381, ConAgra, 300365, FLOUR
HARD, 01, 07, 1,550,390
There are similarities that match (which I did on purpose). Now on the
macro in which I download the access information I would also like to
take the above information and put it into the correct row and cell
above. The issue I have is that there are several plants all have
several item #'s. This is why I was thinking of an if statement with
an index function but I do not know how to do this. If this is doesn't
make sense, I can email you a workbook with what I'm talking about and
would like to do.
Ryan