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!
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!