View Full Version : need a vba code HELLLLLPPPPPP
jessmendez01
05-09-2016, 08:58 AM
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 :(
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.
that doesn't look like it is in the correct numerical order.
In re # 8: No attachment.
jessmendez01
05-10-2016, 06:19 AM
number 8 is not needed.
just need it to do what is listed :(
any ideas?
Paul_Hossler
05-10-2016, 06:28 AM
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
05-10-2016, 06:48 AM
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
05-10-2016, 07:14 AM
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
Too far beyond your level of expertise. So you won't understand the help that could be offered.
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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.