multiple ranges

I am using Excel 2010. I have a spreadsheet where column A is for Quarter, column B is for Employee, and columns C-R are for Codes (Code1; Code2; Code3; etc. through Code15). One line might have no values in the codes columns, another might have values in only Code1, another might have values...

I was wondering if perhaps you may be able to help after I have tried to search through multiple threads for an answer to no avail. I have a pretty simple Match Index formula that I am using It reads as follows “=INDEX('Tier 1-2'!B:B,MATCH(A1,'Tier 1-2'!E:E,0)” However, my workbook has multiple...

Hi, I'm trying to create a pivot chart using two data sources that are the exact same (copied data to another tab). I have data on available appointments and appointments being used for our scheduling. I would like to have the flexibility to filter by the other data in the spreadsheet...

With the following code I open workbooks located in a specified directory, copy and paste add ranges from the open workbook to a single destination workbook. For example, each workbook contains several sheet beginning with "New Init" and each sheets data should be added/summarized/merged into...

Hello all, As a starting user of VBA in Excel I have frequently used this forum for solutions to my vba problems (many thanks for that!). This time I couldn't find an answer to my problem, so I decided to register and ask for myself. I wrote a sub that is fired by the Worksheet_SelectionChange...

I think it's a simple question. Can someone help me with the VBA code? I have a tab for each month of the year: Jan, Feb, Mar..... For each tab, I want to retrieve from a named range. Each of these ranges will be identical. For example A1:C20. I'd like to be able to assign this...

Hi I've created a pivot table from mutliple sheets (all in the same excel spreadsheet). I used the get external data option and created a sql union query. All works fine when the the pivot table is in a different spreadsheet to the mutliple ranges. However when I copied the the pivot table into...

I need the total number of cells that meet a specific criteria. I can break down what I need into 3 parts and using COUNTIF, get the results for each part. HOwever, I need the 3 parts to become one formula. =COUNTIF(January!B:B, "OS") =COUNTIF(January!A:A,">=1") =COUNTIF(January!A:A, "<=7")...

Hi, I am trying to set up some Conditional Formats through Code on the Worksheet_Change as I need to setup 4 different Conditions in Excel 2003. Also, the Conditional Formats are different for each Column within the Worksheet. I have managed to setup One Range to change, but I cannot workout...

Hi, I have an Excel 2007 spreadsheet which I'm attempting to make more dynamic, but struggling with the vlookup formula. Firstly I have several named ranges: actual, budget, lastyear, forecast1, forecast2 showing data for weeks 1-52. I have set the vlookup formula so that regardless of what...

Excel 2007 Good day to everyone! I learn an immense amount about Excel here, but this one issue has me stumped. Here are the variables involved Sheet 1 has the following columns starting @ Column D, & ending @ Column K Console - Break - Central Bureau - ID - Console - Break - South Bureau...

Hi great minds, I have a problem that is far over my head. I want excel to count the number of items in a range that I have named "Name" and I have another range that I have name "date" which contains (obviously) dates. The dates are in order. I want to count the number of items in "name" that...