Search for text in multiple tabs and copy result

Closed
DavidJones_1946 Posts 3 Registration date Sunday April 28, 2013 Status Member Last seen April 28, 2013 - Apr 28, 2013 at 06:54 AM
venkat1926 Posts 1863 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
Related:

4 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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 3 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 3 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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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