hi,
I am trying to figure out a formula that would copy rows from a table on a tab and post on another tab while skipping blank rows and neatly packing all the pasted data all together.
I have attached a sheet titled " Student Education Tracking". On the 'Combined Data' tab is aggregating all the data I want to copy. What I would like to happen is if a row in the 'Combined Data' sheet has information I want it to be copied and pasted on the 'Exam Summary' tab. When the rows are copied and pasted, I want the blank rows to be skipped and the pasted information to have no blank rows.
Ex. on the 'Combined Data' tab, Row 2,3,4,5,6 have data, and then there are blank rows until row 16. When copied and pasted onto the 'Exam Summary' tab, I want the formula to paste rows 2,3,4,5,6,16 in descending order without any blank rows.
I am also open to altering the spreadsheet to achieve these results. It just needs to be simple as the the people using the spreadsheet will have very limited understanding of excel.
Bookmarks