hi all!
i am having sales data in A1:C100.
Col A has name of Location, Col B has name of Items & Col C has Quantity of Items Sold..!
A1:C1 is having header as LOCATION, ITEM & QUANTITY respectively..!!
What I want is to merge the data filtered on any one of the Col Headers
into a word document..!
For example
Col A ........... Col B..........Col C
Location .......Item...........Qty
BIG STREET ....PEN.............20
MARKET.........PENCIL.........30
BIG STREET.....PENCIL.........40
MARKET..........PEN............10
What I want is the filtered records on "Location", say ' Market'
ie) record no 2 & 4 into a Word Document through Mail Merging..!
any help please..?
thanks and regds..!
-via135
i am having sales data in A1:C100.
Col A has name of Location, Col B has name of Items & Col C has Quantity of Items Sold..!
A1:C1 is having header as LOCATION, ITEM & QUANTITY respectively..!!
What I want is to merge the data filtered on any one of the Col Headers
into a word document..!
For example
Col A ........... Col B..........Col C
Location .......Item...........Qty
BIG STREET ....PEN.............20
MARKET.........PENCIL.........30
BIG STREET.....PENCIL.........40
MARKET..........PEN............10
What I want is the filtered records on "Location", say ' Market'
ie) record no 2 & 4 into a Word Document through Mail Merging..!
any help please..?
thanks and regds..!
-via135