Search results

I need help with a macro. When I run the macro, I need to set the current workbook as a variable. I want to then call that variable later. Here is what I have and it doesn't work. I have two workbooks open. If I name them in the macro I can see it switc focus to each one. If I try to pass...

Trying to write a script and having trouble getting it to work. Export.CSV Every month a CSV file will be made available. The number of rows are variable every month, but the columns contain data from A to AS. The name of this export will change and reflect the month the data is from...

The "Data" tab in my spreadsheet contains a list of dates in column J (format is date, example: 1/27/2012). On the "Monthly Hours" tab column A contains each month, column B contains the workable hours in that month. ........A........B 1....Jan......176 2....Feb......168 3....Mar......176...

Is there a way in a pivot table, or using powerpivot, that I can have multiple columns of data, each filtered differently? The below output filters out name and activities that I do not want to see. I would like to add a new column that displays the sum of hours for the items that I...

I have a large amount of data that has been pulled from our company's time reporting system. I have a pivot table that shows the hours for selected resources, for selected activities. I need to now show a calculated column on the report that displays "Available Hours". Available Hours will...

I have a column of Days:Hours that I am trying to average. I keep getting a DIV/0 error. I have tried Text to Columns wizard with no luck. Format of columns is ddd:hh 010:22 014:02 002:21 000:03 001:23 000:01 000:00 004:23 006:23 001:21 008:05 012:20 000:02

I would like to sum the values in table 1 column [Monthly Revenue] if the follwing conditions are met: 1. Table1[Type] = "Managed Service" 2. Table1[End Date] = current month and year recorded in cell BQ1 I am using this formula but having issues. It results in a zero, which is far from the...

I have the following columns and Rows H3: Date (on spreadsheet is 11/14/2011) E5: Contract End Date (on spreadsheet is 09/30/2012) G5: Dollar Amount I want to evaluate a cell to see if the date in H3 is less than or equal to the date in E5. I am only concerned with the month and year...

I am trying to declare a variable that is the text in a cell in a hidden column on the spreadsheet. This work if I move the cell to a column that is not hidden, but not when the column is hidden. Any ideas? The value in J3 is the result of the following formula...

I have a spreadsheet that must have values from three seperate columns copied and pasted into three other columns. The columns being copied from have their data generated from formulas. I need to paste the values only into the new columns. The original values and formulas must be left in the...

I need to change the color text of Cell B2 if any value in table column K, meets the a condition. I am using the following formula, but missing something because I get an error. Any help would be greatly appreciated. ND(Table1[Cumulative % Complete]<1,AND(MONTH(Table1[Est Month...

I am trying to create a conditional formatting formula that will highlight a cell when the month and year for the date listed in is less than or equal to the current month and year. Cell A2 = Today() Table column I4 to I16 = any entered date I want to ignore the days and only focus on the...