Search results for query: *

Hi All! I'm building a database that a customer would be updating via a form. This is for a pet sitting service, so I may have 1 or many co-owners of a pet, therefore one or many individuals for each Customer Account. Also, each individual may have 1 or many customer accounts. I have the...

thread229-1476031 We had a similar issue here. Here's the setup and situation: We have Windows XP Pro SP3 with two Administrators and one user. The computer has two HDDs, 1 partitioned into two drives (125gb each, 1 holds the OS and programs, the other is network shared for user uploads) and...

Hi All, I have several workbooks that are 100 worksheets or so and I would like to be able to have a macro that searches for duplicate data across worksheets and generates a list of the offending data values, along with their cell addresses. I have the following code from thread707-1379708...

Hi All, I've been developing worksheet that initially has all data hidden. The user enters search criteria into a textbox (inserted onto the worksheet from Control Toolbox) and then has to hit the Search button (inserted from Forms Toolbar) to run the search Macro. If you want further...

Hi All, Background: I have a database (glorified list) in Excel that contains 8 Fields. The first field of each row contains part numbers separated by a comma and a space. Other characteristics specific to the part number or part numbers such as tool manufacturer and tool type appear in the...

I have hundreds of Excel Files of the same format, in the same folder that I need to extract data from. There are 5 columns 16 rows in length that I need to pull from each file into the one consolidated file. The way I am trying to format it is: S/N CH LP TJ RJ DJ 1 1 # # #...

I've been reading up on the subject and found several posts on using MSQuery or a Pivot Table, but can't seem to get it together. I have hundreds of Excel Files of the same format, in the same folder that I need to extract data from. There are 5 columns 16 rows in length that I need to pull...

I am trying to find the Max Absolute value of each row in a set of data and apply special formatting to that cell. The file constantly gets rows added to the end of the body of data and I need to integrate this operation into a macro. I have been trying to use Conditional Formatting while...

I should give you some background on what I am doing, so that you may understand where I'm coming from... I have a .csv file that test equipment dumps data into. When a new test is run, the data is pasted into the first empty row at the bottom of the body of data. .csv files are of a special...