Recent content by bthomp

all the entries in all the tables are uniquely identified by company number, a 6 digit number. the query in access is just a basic select, picking out multiple company data from a table if in another table of company daya they have a "y" in the Direct Debit col. then that shortend...

Hi there Currently to consolidate some data I import an excel file into access, query against another table and export back to excel. Is it possible for me to remove one step, and instead of importing the data into access at the first step, just query the excel data against the access table...

Id like to filter out and total some numbers based on the month a user selects. I have a dropdown containing the 12 mths from which the user will pick. In the adjacent cell I have the formula below. B5:100 contains dates in dd/mm/yy format and C5:C100 contains numbers. The "" part of...

Your right Skip, but the compiled data i end up with is sent by email. they are only interested in the subset of non-invoiced data. the main sheet i use has lots of extra calcs for cost tracking that only i need to see. as the compiled data could be made up of non-invoiced lines over many...

cheers MacroMan ill give that a go and report back. -ben

I have a filter in place, but I was hoping to do it automatically, from several workbooks at the same time.

I have several worksheets (monthly) that have rows of accounting data on. there is one column that i use to say if a particular invoice has been paid or not. What I am aiming to achieve is the ability to compile all non-paid (ie rows with nothing in that column) onto a new worksheet, to make up...