Hello
I have two sheets names(SALES & PURCHASE) contain data from column B:I
each sheet stratt from row 18 , invoice number is existed in shape (Rectangle 55)
the invoice number will be for both sheets(SAL189-01-023-INV01,PUR189-01-023-INV01)
before row18 contains some pictures and shapes to enter DATE and NAMES .so what I want :
first: create two folders names are (SALES & PURCHASE) in this directory "C:\Users\PC TUBB\Desktop\INVOICES"
second: create folders names are years based on current year inside folders (SALES & PURCHASE)
third: create folders names are months (JANUARY, FEBRUARY....) inside folders (YEARS) for each sheet.
fourth: save every sheet based on invoice number is existed in shape (Rectangle 55) inside folder month based on current month as PDF
fifth: every time run the macro should replace the files insides the months folders .
I hope to don't forget another thing
thanks in advance.
I have two sheets names(SALES & PURCHASE) contain data from column B:I
each sheet stratt from row 18 , invoice number is existed in shape (Rectangle 55)
the invoice number will be for both sheets(SAL189-01-023-INV01,PUR189-01-023-INV01)
before row18 contains some pictures and shapes to enter DATE and NAMES .so what I want :
first: create two folders names are (SALES & PURCHASE) in this directory "C:\Users\PC TUBB\Desktop\INVOICES"
second: create folders names are years based on current year inside folders (SALES & PURCHASE)
third: create folders names are months (JANUARY, FEBRUARY....) inside folders (YEARS) for each sheet.
fourth: save every sheet based on invoice number is existed in shape (Rectangle 55) inside folder month based on current month as PDF
fifth: every time run the macro should replace the files insides the months folders .
I hope to don't forget another thing
thanks in advance.
