need a vba code HELLLLLPPPPPP

[jessmendez01]

First time processing a macro and need help I need the vba code/macro to do the following:

Prompt the user to enter or select the Invoice number and select the directory where to process the following:

· Create a folder in the directory with the Invoice number as the folder name
· Evaluate the full list of invoices in the excel report file.
· By Ship_Name (column B) extract all invoices for each person into a separate excel file and total up their individual invoice totals.
· Each excel file will be named with the following convention àInvoiceNumber-ShipName (Example: 123456789-sample.xls)
· Save a copy of the original file in the new directory with the name of InvoiceNumber-Original.xls
· Save each Ship_Name file in the new directory
· Format each of the Ship_Name output files in the same way as the attached sample file.

Please tell me someone can help me

[SamT]

1. Prompt the user to enter or select the Invoice number and select the directory where to process the following
2. · Create a folder in the directory with the Invoice number as the folder name
3. · Evaluate the full list of invoices in the excel report file.
4. · By Ship_Name (column B) extract all invoices for each person into a separate excel file and total up their individual invoice totals.
5. · Each excel file will be named with the following convention àInvoiceNumber-ShipName (Example: 123456789-sample.xls)
6. · Save a copy of the original file in the new directory with the name of InvoiceNumber-Original.xls
7. · Save each Ship_Name file in the new directory
8. · Format each of the Ship_Name output files in the same way as the attached sample file.

that doesn't look like it is in the correct numerical order.

In re # 8: No attachment.

[jessmendez01]

number 8 is not needed.
just need it to do what is listed
any ideas?

[Paul_Hossler]

1. No attachment

2. Tall order

3. Suggestion: a more meaningful topic title is more likely to have people look at it and offer ideas

[jessmendez01]

ok im sorry i was unclear:

need the macro to 1st prompt the user to enter or select the Invoice number and select the directory where to process the following:

· Create a folder in the directory with the Invoice number as the folder name
· Evaluate the full list of invoices in the excel report file.
· By Ship_Name (column B) extract all invoices for each person into a separate excel file and total up their individual invoice totals.
· Each excel file will be named with the following convention a InvoiceNumber-ShipName (Example: 123456789-sample.xls)
· Save a copy of the original file in the new directory with the name of InvoiceNumber-Original.xls
· Save each Ship_Name file in the new directory
· Format each of the Ship_Name output files in the same way as the attached sample file.

Does this make sense?

[jessmendez01]

when it says the attached sample file was corrupt so it won't allow me to upload however it should save as Ship_Name user example would be like this: 123456789_sample.xls

[snb]

Too far beyond your level of expertise. So you won't understand the help that could be offered.

[SamT]

need the macro to 1st prompt the user to enter or select the Invoice number and select the directory where to process the following:

· Create a folder in the directory with the Invoice number as the folder name
· Evaluate the full list of invoices in the excel report file.

Select one invoice, create folder. Process many invoices. Do you see a problem with that request?