Recent content by angeb

Ok so this is the name of the file Births4.xlsx, the column I want it to filter is Surname (4th column) and this is the cell range A2:P74579. I want the resulting filtered data to end up in FamilyTree.xlsx. Sorry to be a pain but I really am totally new to VBA And thanks for your help so far...

Each worksheet holds a max of 1,048,576 lines, but my workbooks have multiple worksheets, hence the over 2mill lines. I have almost 6mill lines in another workbook. It's extremely cumbersome and slow when I try to work with a file that size, which is why I wish to have my source workbook, then a...

I have a huge list from which i need to extract data. Ie from a column listing surnames of adams, anderson, doyle, alexander, aarons, berry, cummins, crimmins, I need to extract all the cummins, adams, berry and doyle, with their associated information from corresponding columns to a seperate...

The original information from the 3 text files, covers births, deaths and marriages in victoria, and is contained on 8 desperate discs. I found myself constantly changing out discs after searching for just 1 person. After finding a copy of these discs in text files, I decided to try to put it...

I have a large text file that I wish to import to an access database. The information has been extracted from the Victorian, Australian births CD's. It has 2,007,951 entries. Column headers are year (four digit yyyy only), RegNo (5 digit), Gender (m/f with many fields blank), Surname, First...

Hi all, I'm from Australia. I originally taught myself some basic Access by disecting existing databases then using what I learnt to help me to modify and expand a large patient waiting list database. This was back in 99/2000, so yeh, it's been a while! Hoping to learn a thing or two from you...