Hi
I have a 4 page excel spreadsheet.
3 worksheets of purchase details from our suppliers (I do a new spreadsheet as they update each month)
I then have other columns that recommend the best buys.
Most rows are blank after column J, some have the better product info. This info starts on Column J for 5 or so columns.
There is up to a 1,000 rows of data in some of the worksheets
Can I ask does anyone know a formula that would list the rows wit the extra info, that looks at each line (however many rows,) ignores the blanks, and pulls though the data from Column A onwards for each row with the extra info on it.
So that it becomes a working document as a checklist for each product they are ordering wrongly.
It would be about 15 rows from each worksheet.
I hope that is enough info.
Thanks
Mark
I have a 4 page excel spreadsheet.
3 worksheets of purchase details from our suppliers (I do a new spreadsheet as they update each month)
I then have other columns that recommend the best buys.
Most rows are blank after column J, some have the better product info. This info starts on Column J for 5 or so columns.
There is up to a 1,000 rows of data in some of the worksheets
Can I ask does anyone know a formula that would list the rows wit the extra info, that looks at each line (however many rows,) ignores the blanks, and pulls though the data from Column A onwards for each row with the extra info on it.
So that it becomes a working document as a checklist for each product they are ordering wrongly.
It would be about 15 rows from each worksheet.
I hope that is enough info.
Thanks
Mark