Search results

Hello, I was wondering if there was a way to create an automated report that would detect and identify incorrect formulas in a column. For example, I have a column about 300 rows long that should have the exact same formula except for the first variable. I have about 20 of these rows, and...

Hello, I have zero knowledge about macros or even where to start with them, so I am hoping that this problem can be solved within the set of available Excel functions. I have 300 sales reps. Each one has been in there position for a different length of time. I want to sum there monthly...

Hello All: I have a command button that prints a report to a pdf file. rather than having to rename the file each time, I want to pickup a field from the report and have it used as the file name. Is this possible? Yes...I am a novice.

I have used both these functions extensivley, but I cannnot see a benefit of using one over the other. Does anyone know the relative strengths and weaknesses of these two lookup options?

I have found that, if I am compiling data using the SUMIF or SUMPRODUCT functions, and I sort my records, the function continues to reference the original cell reference. For example, if I use a referenced cell to fill the CRITERIA requirement, it will continue to use this same cell even after...

When I do a find and replace, the excel window flashes or cycles as the replacement are made. Does anyone have an idea why? It can be a real time sink as it can take 5 or 10 second to complete.

Hello, I have 36 Access databases containing 2 tables each. One table contains invoice information the other the customer information. There is one Access database file (.mdb) for each month starting in 2006. The two table are identical in structure across the months. The customer table...