pmyk
10-20-2013, 11:11 PM
Summaryof Friends Free Circulation Library to be generated from Excel FIles based on common ID in vba.
D:\Member.xls
Col A= MemberID ColB= Member'sName
1234 Mr. D.
1235 Mr. A.
1236 Mr. C.
D:\Books.xls
Col A= BookID ColB= Titles of books
101 Adventures
102 Health Tips
103 Short Stories
D:\Transactions.xls
Col A= MemberID ColB= date ColC= BookID ColD= TR (Book taken or Returned)
1235 10 Jan 2013 103 T
1234 12 Jan 2013 101 T
1236 14 Jan 2013 102 T
1234 16 Jan 2013 102 T
1235 18 Jan 2013 103 R
1236 20 Jan 2013 102 R
1236 20 Jan 2013 103 T
Summary Expected Member-wise on a Sheet with the name “Report” in the Transactions.xls:
A=MemberID B=MemberName C=date D=BookTitle E=TR (Book taken or Returned)
1234 Mr. D. 12 Jan 2013 Adventures Taken
1234 Mr. D. 16 Jan 2013 Health Tips Taken
1235 Mr. A. 10 Jan 2013 Short Stories Taken
1235 Mr. A. 18 Jan 2013 Short Stories Returned
1236 Mr. C. 14 Jan 2013 Health Tips Taken
1236 Mr. C. 20 Jan 2013 Health Tips Returned
1236 Mr. C. 20 Jan 2013 Short Stories Taken
I can populate Listview Control by pulling data from this Report Sheet using Selection.Offset. (Any other good suggestion is appreciated).
I don’t know much about VBA. Please help. Thanks in advance.
D:\Member.xls
Col A= MemberID ColB= Member'sName
1234 Mr. D.
1235 Mr. A.
1236 Mr. C.
D:\Books.xls
Col A= BookID ColB= Titles of books
101 Adventures
102 Health Tips
103 Short Stories
D:\Transactions.xls
Col A= MemberID ColB= date ColC= BookID ColD= TR (Book taken or Returned)
1235 10 Jan 2013 103 T
1234 12 Jan 2013 101 T
1236 14 Jan 2013 102 T
1234 16 Jan 2013 102 T
1235 18 Jan 2013 103 R
1236 20 Jan 2013 102 R
1236 20 Jan 2013 103 T
Summary Expected Member-wise on a Sheet with the name “Report” in the Transactions.xls:
A=MemberID B=MemberName C=date D=BookTitle E=TR (Book taken or Returned)
1234 Mr. D. 12 Jan 2013 Adventures Taken
1234 Mr. D. 16 Jan 2013 Health Tips Taken
1235 Mr. A. 10 Jan 2013 Short Stories Taken
1235 Mr. A. 18 Jan 2013 Short Stories Returned
1236 Mr. C. 14 Jan 2013 Health Tips Taken
1236 Mr. C. 20 Jan 2013 Health Tips Returned
1236 Mr. C. 20 Jan 2013 Short Stories Taken
I can populate Listview Control by pulling data from this Report Sheet using Selection.Offset. (Any other good suggestion is appreciated).
I don’t know much about VBA. Please help. Thanks in advance.