Removing rows
Hi All,
I'm a complete newbie so any help is appreciated. I'm using the GUI as my coding skills are pretty poor.
I have several xls invoices I'm trying to append for analysis. Each of them has a name at row 25 and the invoice information from row 26 onwards. Each invoice will vary in the amount of total rows. Unfortunately there's a whole bunch of useless information in the bottom few rows of each invoice that I need to get rid of (footer).
I've got several invoice files in xls format (10+ files) that I am reading through "Loop files" with a nested "Read xls"
My cell range is A25:BO1000. All rows above A25 have data I don't want (invoice headings ect ect).
I'm reading the data successfully but am not able to append the files due to the data contained in the footer.
Any ideas how to get rid of these rows?
Thanks in advance!
I'm a complete newbie so any help is appreciated. I'm using the GUI as my coding skills are pretty poor.
I have several xls invoices I'm trying to append for analysis. Each of them has a name at row 25 and the invoice information from row 26 onwards. Each invoice will vary in the amount of total rows. Unfortunately there's a whole bunch of useless information in the bottom few rows of each invoice that I need to get rid of (footer).
I've got several invoice files in xls format (10+ files) that I am reading through "Loop files" with a nested "Read xls"
My cell range is A25:BO1000. All rows above A25 have data I don't want (invoice headings ect ect).
I'm reading the data successfully but am not able to append the files due to the data contained in the footer.
Any ideas how to get rid of these rows?
Thanks in advance!