Need Help to Extract data from required tab as per condition

[Naveed Raza]

Hi Everyone,

I have one workbook and that workbook contains total 15 Tabs and i want extract data only from
3 tabs ("Subscription","SIP","Back or Future date")

again from each tab we have different different calculation, below is the steps.

in all tabs row is starts from 7th row

1) workbook will open
2) add new tab and named as "99 Trxns"
3) next from "Subscription" tab Filter (contains 99) from C-Column and copy only some required column
like (A to H, K to Z) and paste in "99 Trxn" tab at range A1
4)next from "SIP" tab Filter (contains 99) from C-Column and copy only some required column
like (A to H, K to Z) and paste in "99 Trxn" tab at 2nd next empty row
5)next from "Back or Future date" tab Filter (contains 99) from D-Column and copy only some required column
like (A to H, K to Z) and paste in "99 Trxn" tab at 2nd next empty row.

Note: If possible please make VBA Code by using (Lbound,Ubound,select case,array) properties or else in your possible way.

Note: Required Columns Headers I mention in attached File in 1st tab.

I hope my explanation is understandable.

Thanks - Naveed.

[Naveed Raza]

Bump no response

[cytop]

Also: http://www.ozgrid.com/forum/showthread.php?t=181041

[Naveed Raza]

Finally I put my effort and i prepare/make a code to run well for this my query and its got resolved.

Below is the code which is make by Me.

Please Login or Register  to view this content.