Peter;453475 Wrote:
Hello all, I hope some kind soul can help! I am the treasurer of a local
club and
attempting to create an Excel file to control and report upon the
Club's finances.

I have two worksheets (amongst others) named 'Cash' & 'Bank'
deliberately containing
identical column headers 'Date', 'Spend', 'Receive', 'For', 'To',
'From', 'Detail' &
'Balance'. On a third sheet I wish to automatically collect data from
various rows that
the column 'Detail' starts with the word "Voucher number x", inserts
them and then sorts
by "Voucher number x" in the 'Detail' column.

I have created two queries in MS Query for each worksheet and a macro
to perform the
magic. It works, to a degree, but it only produces approximately 18
records from both
worksheets and the last one, currently extracted from the 'Cash'
worksheet, does not
include a value from the 'From' column. Even after inserting dummy
data, the resultant
sheet still omits any value in the column 'From'.

So, any ideas as to how I can get what I want in the third worksheet,
please? Am I correct
in using MS Query or should I look elsewhere? If so, what route do I
follow? All advice
gratefully received!

TIA Peter

p45cal;453777 Wrote:
Well, I was really after a bit of macro code and perhaps a query or two
- say, in a workbook? If it's allowed to attach here (codecage.com).

Good morning,

Having now subscribed to Code Cage I hope that the email I am
attempting to attach the file in question :-)


+-------------------------------------------------------------------+
|Filename: Accounting Test.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=218|
+-------------------------------------------------------------------+

--
Peter
------------------------------------------------------------------------
Peter's Profile: http://www.thecodecage.com/forumz/member.php?userid=687
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125534