Hi all excel nijas,
i need some help to create on excel file where i can create invoice, from excel raw data, i have invoice data in sheet 2 and need take some data from sheet 2 and create invoices in other sheet with name of year of invoice generation and same year invoice crate one sheet. sample file enclosed, only 8 highlighted fields taken from raw data and rest filed are same for all invoices. in attached file with 2 examples
i need some help to create on excel file where i can create invoice, from excel raw data, i have invoice data in sheet 2 and need take some data from sheet 2 and create invoices in other sheet with name of year of invoice generation and same year invoice crate one sheet. sample file enclosed, only 8 highlighted fields taken from raw data and rest filed are same for all invoices. in attached file with 2 examples