suryasabniveesu
Member
Hi all,
This is Surya, from Hyderabad, India. This is my first day in the forum. I have been working in Finance of a construction company. Normally I receive data from all site accountants who are spread all over India in different formats and my job is to consolidate the data in a standardized format and file the statutory returns.
I have been facing this problem for so long. The excel file which I receive from colleagues contain invoice information. If the invoice is prepared for different items, then the person prepares excel data as per the invoice. Mean to say, for same invoice number multiple rows will be created with multiple values. Example: Invoice no: 896, total value is 24,31,625. But it is split into 2 rows. There will be some invoices which are split into 10 or more rows.
Now my problem is I have to prepare a statement in which I want total invoice value in a single row. To do that I have been using subtotal formula, apply filter on invoice number and copy + paste special the value in standard format. For N number of invoices I have to this operation N number of times.
The solution I want is all such invoices in a particular sheet (Master Sheet) which are entered in multiple rows have to clubbed and shown in a single in separate sheet (Output Sheet)
This is Surya, from Hyderabad, India. This is my first day in the forum. I have been working in Finance of a construction company. Normally I receive data from all site accountants who are spread all over India in different formats and my job is to consolidate the data in a standardized format and file the statutory returns.
I have been facing this problem for so long. The excel file which I receive from colleagues contain invoice information. If the invoice is prepared for different items, then the person prepares excel data as per the invoice. Mean to say, for same invoice number multiple rows will be created with multiple values. Example: Invoice no: 896, total value is 24,31,625. But it is split into 2 rows. There will be some invoices which are split into 10 or more rows.
Now my problem is I have to prepare a statement in which I want total invoice value in a single row. To do that I have been using subtotal formula, apply filter on invoice number and copy + paste special the value in standard format. For N number of invoices I have to this operation N number of times.
The solution I want is all such invoices in a particular sheet (Master Sheet) which are entered in multiple rows have to clubbed and shown in a single in separate sheet (Output Sheet)