Copy values based on non-blank cells in another column

Hello everyone,

I am trying to figure out how to fill a table automatically from other worksheets.

So basically I have data like in Table 1 that I have entered on lets say worksheet 8, and what I need is for the data that is carried to automatically get put on Table 2 without me having to reference each cell individually so if there is any numbers in the column of carried to be put in Table 2 with the name and type sorted.
I hope this makes sense and hopefully its easy not complicated as I am not that good with excel.

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!


ALSO:




A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

use this:
=FILTER('Div2'!B4:B15,('Div2'!A4:A15="")*('Div2'!G4:G15<>""))

similar for column E.