Hi,
I have some 50000 rows of data in column A.
What i do manually is, First press Ctrl+F & find for "Supplier123", il make a note of the row number( say Row 1509) then i will find for "Total" (this exists in row 15890) now I copy all the rows from 1509 to 15890 and paste in sheet2.
I need to do like this for 100 times for 100 different searches. so is there way to do like below?
I have data in Column A, I will enter the first find criteria in B1(that is supplier123 or what ever the value i need) and enter 2nd Criteria C1( what ever the value i need like "Total") and run a macro, the macro should search both the criterias and copy the rows of data between those 2 values to the next sheet.
once that is copied il change my criteria in B1 & C1 and run a macro again, then again the desired data should be pasted in the next sheet after the first set of data.
I would appreciate your helps in advance.
I have posted the same question here: http://www.mrexcel.com/forum/showthread.php?t=391335
Thanks
Arvind
Bookmarks