Hello again. I'm finding this forum so useful when I can't solve my own issues using Google search!
So - this time I have the following.
Sheet 1 = Lots of column, different data in each column. Row's being added all the time (and populating each row with new data).
What I want in sheet 2 is.......
Copy over only a select couple of columns BASED on criteria in a certain column. So, for example - I want to copy to sheet 2 all the information in column B / D / F from sheet 1 where column A has the word APPLE in it. This will automatically populate as more info is added to sheet 1.
Basically, sheet 2 is a sub selection (or a filter if you will) of the information in sheet 1.
Any idea?
So - this time I have the following.
Sheet 1 = Lots of column, different data in each column. Row's being added all the time (and populating each row with new data).
What I want in sheet 2 is.......
Copy over only a select couple of columns BASED on criteria in a certain column. So, for example - I want to copy to sheet 2 all the information in column B / D / F from sheet 1 where column A has the word APPLE in it. This will automatically populate as more info is added to sheet 1.
Basically, sheet 2 is a sub selection (or a filter if you will) of the information in sheet 1.
Any idea?