Copying multiple rows of data from one Exel sheet to another (1st time user)

[Dalach]

Hi,
I'm an exel novice looking for some help with one specific function that would save me hours of copying and pasting.

I have a workbook that has worksheets for each month, and within each worksheet there are a variable number of entries under titled columns A to O.
However, I am only interested in certain entries, namely those in which the word "Attune" appears in column G.

Is there an easy way of isolating the rows I am interested in, and copying them to another exel file?

I hope this makes sense, if not im happy to clarify!
Any help much appreciated!

 

[AlexandraT]

Try applying a filter and then searching in the search field of the filter for the word you need. That way only those rows will be displayed that have the word "Attune" in column G and they can be copied in one go. Shortcut to apply a filter is CTRL+SHIFT+L

 

[Dalach]

Thanks!
This works, but stil requires going from sheet to sheet (ie month to month) and applying the filter, which will take some time as I have several workbooks to get through.
Is there any way of applying a filter to the entire workbook?

 

[AlexandraT]

That is probably possible with a macro but it's over my head really. Alternatively, you could copy all the data from all the sheets into 1 sheet (maybe add an extra column and type what sheet/month it's from if you need to know that) and then filter it. Still going to take some time though