Search for text in multiple tabs and copy result

Closed
DavidJones_1946
Posts
4
Registration date
Sunday April 28, 2013
Status
Member
Last seen
April 28, 2013
- Apr 28, 2013 at 06:54 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Apr 29, 2013 at 01:42 AM
Hi. Help needed please.

I have a 2010 workbook which tracks income and expenditure, by month, for a small voluntary organisation. I want to be able to select rows that contain the word "Capital" in a defined column and then copy the results into another preformatted tab. In practice this will identify all purchases of capital equipment and add them to the Asset Register.

Does anyone know of a way to do this, please ?

Thanks in advance.

David J

4 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Apr 28, 2013 at 07:37 AM
autofilter in that partcular colum critria being "capital"
you can copy FILTERED data anywhere you want.
0
DavidJones_1946
Posts
4
Registration date
Sunday April 28, 2013
Status
Member
Last seen
April 28, 2013

Apr 28, 2013 at 08:43 AM
Venkat1926, thanks for the tip. How do I arrange for the results of the autofilter search to not show on the same sheet but to be pasted into the next free rows of a different tab ?
0
DavidJones_1946
Posts
4
Registration date
Sunday April 28, 2013
Status
Member
Last seen
April 28, 2013

Apr 28, 2013 at 08:45 AM
Ah OK, I think I see it now, in 'Advanced :)
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Apr 29, 2013 at 01:42 AM
advanced filter helps to give unique items

autofilter filtre for that critrial. It NEED NOT be in different sheet. you do it the same sheet highlight dilgered data and copy todifferent sheet. go back t0 kloriginal sheet remove filter you get your original data.
0