excel 2007

Hello I have a spreadsheet that have 2 columns; Address and City The addresses end with the city names attached to it, but I also have a separate column with the city names. <tbody> Address City 11305 Via Balboa Anchorage Anchorage P.O. Box 3652 35670 Kenai Spur Hwy. Ste. 102 Soldotna...

I have a pivot table that shows usernames and a count of how many times each username appears in my data. The pivot table also has a filter field which filters the data by course title. I have set the filter so that the pivot table only displays data for 1 specific course. This gives a list of...

Hello, So I have a bit of a problem I am trying to solve and hope someone can share some of their wisdom. I have a worksheet named "Commercial Bids" that contains a bunch of information my company uses for tracking work that looks like this: Excel 2007 <tbody> A QUOTE DATE B PROJECT NAME C...

I have a sheet that I created for work that I'm having some problems with. First, here are some details about the sheet: Using Excel 2007 It's password protected. Users are only able to select locked and unlocked cells, format rows and columns, and use autofilter. It contains several index...

Hello All, I am looking for a formula or a trick to display several values (strings: phrases) in the same cell and in an organized way (I mean return to line) with 2 condtions .. If you could help me guys, I will appreciate it even after the incarnation of my soul :) Thanks in advance,

Is there a way to place a cell reference in the chart data range? I have multiple worksheets and would like to change a charts reference to a data range based on a value in a cell. Thanks

Hi all, I'm writing a VBA macro in Excel (2007) to generate a series of plots. This macro is intended to get iterated across numerous sheets and workbooks. Because of this, I need the macro be generalized and the only stumbling block I'm encountering right now is that Excel is forcing me to...

Hi All, I am using Excel 2007 and am working on a test grading macro. What I am trying to do is compare the test answers (E2:EQ2) to the student's answers (E10:EQ10) and have the overall score placed in a designated cell (ER10). I have seen a lot of posts regarding comparing two columns and...

Hi, I've got a big file broken down into manageable sizes - about 4500 rows each. Each Unique Identity may have 1 to maybe 10/15 rows (varies). Mostly, each row contains one column of non-blank data (some have more than one cell that is non-blank). I want to merge/roll up these rows into 1...

Hi, I am attempting to set a filter on an Excel pivot table using a variable in a macro. When I execute this macro it works ok: Sheets("Amort").Select ActiveSheet.PivotTables("PivotTable7").PivotFields( _ "[Receiver].[Rcv 09 Name].[Rcv 09 Name]").ClearAllFilters...

Hi I'm trying to find some code that will pull data from one workbook to another without having to open the source data workbook. Currently, when my workbook "MTCR Tool" opens it asks if you would like to update the mapping data. If i click yes, I would like the mappings data to then be...

Hello, I don't have much (read any) real VBA experience. So I can copy and paste code and even start to make sense of it, but I can't create it myself. I have a table of employee data that ranges by month from 2014 through 2016. It also includes teams, unique identifiers, and such. I have...

Hi I have a worksheet containing code that I have used succesfully many times in the past to produce a fortnightly report (raw data is normally around 10,000 to 15,000 rows). I'm now trying to produce a report for all of last year and have over 279,000 rows of raw data. This initally caused...

Hi I have the below code to create a pivot table and have set the pivot table as the variable, PT: Dim WB As Workbook Dim WS As Worksheet Dim WSsb As Worksheet Dim FinalRow As Long Dim FinalCol As Integer Dim PRange As Range Dim PTCache As PivotCache Dim PT As PivotTable Dim PF As PivotField...

Hi everyone, I have an Excel 2007 Spreadsheet which takes a data-set and groups the results into column ranges: <tbody> ID 1-9 10-19 20-29 30-39 40-49 50-59 001 2, 8 13, 16 22, 29 N/A N/A N/A 002 N/A N/A N/A N/A 41, 44, 48 52, 56, 58 003 N/A 11, 12 23, 26 33, 38 N/A N/A 004 1 11 24 34...

Dear Experts I have multiple workbook saved in folder i want copy data from closed books and paste into mastersheet particular criteria is sum the column F:F and average the column G:G after 20th rows copy from Month_FEB.xlsx Month_JAN.Xlsx Paste Into Master.xlsx Path is...

Hi I'm trying to write a formula to count records that have a start date that falls between certain dates and either no end date (i.e. blank) OR an end date greater than X date. I've come up with the below formula but Excel is saying there's somehting wring with the formula...

Hi all, What I am trying to do is copy any worksheets from one file (source) to another workbook (target) which don't already exist in the target file. Is there a way to loop through and compare each of the worksheet names and only copy the new ones while ignoring those that are already in the...

Hi, I have two dates, the start date and the end date. I need to calculate the exact date difference between them but excluding specific days of week. For example: Start date: 2015-10-06 11:00 AM End date: 2015-10-29 18:55 PM And all of Wednesdays and Fridays need to be excluded...

Hi All, I am using Excel 2007 and have a test question database that I need some help writing a macro for. In sheet 1, I have the master question list. Each row contains a question and its associated elements. Column A lists the version (A-C) of the test that the question is applicable to...