Need some expert help

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
 
O

Otto Moehrbach

Ryan
Maybe I can help you. Send me your file. Also send me a detail
step-by-step procedure of how you would do what you want done if you were
doing it manually (cut/copy and paste). Remember that you are the only one
that understands what you want, so provide all the little details. Also
tell me the version of Excel you are using.
My email address is (e-mail address removed). Remove the "nop" from this
address. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top