Hi,
Im quite new to visual basic and am really struggling with this problem. I have spreadsheets data which represents sales data. for single item sales the sale takes up one row, however a sale of multiple items is then split to multiple rows although each row for the sale has the same invoice number.
Can anyone help me with the code to append the subsequent rows to the first?
this would allow me to run various other processes and my own invoicing etc. well i hope it will.
many thanks in advance
Im quite new to visual basic and am really struggling with this problem. I have spreadsheets data which represents sales data. for single item sales the sale takes up one row, however a sale of multiple items is then split to multiple rows although each row for the sale has the same invoice number.
Can anyone help me with the code to append the subsequent rows to the first?
this would allow me to run various other processes and my own invoicing etc. well i hope it will.
many thanks in advance