multiple columns

Perhaps someone can point me in the right direction: I have a sheet that contains multiple transactions from the bank, which I import from fixed length txt. I added names to each range to make it easier for entering formulas, etc. I need to get the sum of each AMOUNT column that contains...

HI. I'm hoping someone can assist me. I have two excel docs. One is a list of Account Cancellations from the Finance system. The other is a full Account list with Contact information . I need to get the the finance data onto the full Account list with Contacts so that someone can followup with...

I've seen posts about copying and pasting data filtered for uniques before. I found one that does almost exactly what I need it to do. Current code searches all my sheets through column A for all unique values and presents them to me on the sheet with my command button. What I need it tweaked...

Hello everyone, I'm sure there is an easy solution to this but I just can't find what I need, can anyone help me please?! I have a table which contains headers of the same title RED and GREEN, as shown below (except the APPLES and GRAPES cells are merged with the cell on their right to give...

Hi All. I trying to make a chart in Excel grow dynamically based on a couple of user inputs. I have data from 24 months, but I want to be able to choose how many of these month to show, and which month should be the first month in the chart. I have followed this guide Chart the Last 12...

I have 2 Worksheets in an Excel 2010 Workbook - Sheet1 Column1: contains the word "dog" Column2: contains the word "bark" Sheet2 Column1: contains the sentence "I like dogs a lot." Column2: is blank What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present...

Good afternoon - could I get some help on being able to move all the data in Column "I" (eye) across all tabs (with the exception of the tab named "Summary") into one column of the "summary" tab? Currently I have a script running which collects all the data in each tab and it copies it to the...

I have split columns before using the (LEFT,RIGHT,MID) statements after finding a character, but this is my challenge. I have a column that has multiple "\" characters in variable positions and all the text between them and the last characters after the last "\" needs to be in separate fields...

Hi, I'll post example pictures to explain better, but I'm getting very frustrated... It seems like such a simple thing to do but I cannot figure it out. I want to be able to filter for specific values in all the columns underneath a merged cell group. I used a simplified example of just...

Hey All, I would have a basic question. I have a 2 sheets that have more columns, I want to do a VLOOKUP, but based on two cells. The target table where I search has also two columns, which give the clear identification. Can I use VLOOKUP without putting an extra Concenate column or using & " "...

I have a batch of data in several columns of different information. One of the columns is a label for the team name "Red" or "Blue" I want to sort the information for each team in a separate columns for that team. I have the code that will copy/paste the information I want into the columns I...

Hi! Here's the scenario: I want to have multiple check-boxes on my user form (around 16 options) but I can only have 4 selected that will go into either column F,G,H or I. It doesnt matter which they go into, but it thats where they need to go. I am fairly new to vba and have no idea the code...

I have a master worksheet containing two main columns. Column A lists our most popular products. Column B lists the current inventory of each of the products in column A. The values in Column B are culled using VLOOKUP from across multiple worksheets, in numerous spreadsheets, located in...

Hi All I have just joined this forum as i have been a following many posts for my queries, have found your expertise and advice very useful for many issues. I have been scratching my head on the following data spreadsheet 'Master Recall' for more than a week without any positive outcome...

Hello, I need help with a code that will search each cell across 4 columns and hide the row only if all cells are blank. The macro should search columns "b", "c", "e", and "f" to display all rows where at least one of the cells has a value. Ex. Col.B Col.C Col.D...

Hi everyone. I've been searching for a thread about this query but all I found refer to Multiple Rows to Single Columns and the like. I need help in transposing Several Rows into Multiple Columns and I would appreciate if it's in a formula format and not VBA. The table looks like this...

We're trying to find a pipe size in a row, that corresponds to a value of flow within a table (which is found by matching an input flow with a table), see example below. For example, a value for kvs and DN are input by user, the user then inputs desired flow rate which needs to match...

Hi, I'm trying to split a workbook by the values in two different columns. I have a workbook that has letters in column J (A-R) and numbers in column K (1-10). I can succesfully use the code here: http://www.mrexcel.com/forum/showthread.php?352057-Split-Worksheet-to-Multiple-Worksheets to...

I have attempted to research this issue on Google but I can't seem to word the issue properly and therefore unable to find an answer - even in this forum. THE SETUP: I have a list of places in Column A. Each place may appear multiple times depending on Column B. Column B contains text titles...

Hi All! I'm creating a pivot table that feeds data into a pivot chart and it's all working just fine, but I'm having a problem formatting the pivot chart. In my pivot table, I want to have multiple value columns displayed in the table. However I only want one of the value columns to be...