Does anyone know if their is a way of doing what I call financial overlining and underlining in a set of accounts. What I ideally would like is a single...

I have data in columns with month headers. I want to input a specific month and return data for each row. For example, in A1, I have selected "Feb" and want...

when i remove data from my source tab, the entries still show in the drop down list for the field in my pivot table. i am trying to figure out how to remove...

How do I turn off the GETPIVOTDATA function?

We have an excel document where all of the columns, except for three, have been locked down. We password protected the spreadsheet and then shared it. Most...

I would like to create a macro that fills a column for me from the first cell. My dilemma is that the amount of rows of data are ever changing, and I would...

Hi, I am using COUNTIF formula and it is miscounting by 1 Example: =COUNTIF(O1:O275,"E6400-2.4-A") CountIf result: 4 There are actually 5 "E6400-2.4-A"...

I have an array of times all in the same column. I would like to average this array without having to sort to exclude zero time fields. I've tried...

I would like to create a report for the following: 1 - Read a worksheet with data like the following: C1 C2 ...

Puzzling problem: In Excel both under "Edit" and in the shortcut menu "Cut", "Copy", "Paste" and "PasteSpecial" are grayed out. Just started today.Files are...

I have a worksheet that when i enter data in their respective cells, it automatically fills it with a highlight and border line. I don't see any conditional...

I want to perform the following search: 1 - Search a worksheet with a list like the following: C1 C2 ...

I have a list of 350 customers that references a grid location. I need to print this list in 8 columns to minimize the pages that print with the map. To get...

Hi, Need ur help to design macro which can save the file in desired location & save with desired name. I do run a Macro on daily basis, which pulls data...

Hi, I have a table similar as below, how can I calculate the amount of A during December 1 to 7? I know I can use DSUM for sigle result, but my purpose is...

Somehow I have lost the ability to edit cells after hitting F2 in a cell. I am no longer getting the cursor that allows me to edit inputs within the cell,...

Hello, I would like to ask for help. Am I able to vlookup from a field? Here is what I'm doing: - on sheet two I have a lookup field (Column 1 is the...

Hello I work on a time series in Excel that should be used in the EPA SWMM. (Storm water modelling) Eks of the series: Date (D/M/Y) Time(H:M) Value...

I have a workbook named QUOTES that uses a referenced add-in workbook named Add-In which contains all code to manipulate QUOTES. I have 2 option buttons on...

I have a large workbook (50+ worksheets) that originated in Excel 2003. I would like to save it as a 2007 workbook so I can get larger worksheets. When I try...