columns

  1. L

    Pivot Table / Open in New Workbook, Save As, Delete Data.

    Hi All, I am in need of some help here. All the VBA Codes I have tried to use don't work. I am trying to open the information in a pivot table in a new worksheet (I have that part figured out but I cannot get it so it will allow me to add new sheets to my existing workbook every time it opens...
  2. N

    Adding a +1 to a Row when dragging across Columns

    Hi again, I have a formula that uses a row reference ROWS($B$1:$B1). I want to drag this across the columns, but need the second part of the ROWS formula to +1. So in Column B the formula would read ROWS($B$1:$B1) in Column C it would read ROWS($B$1:$B2) and so in. Is this possible? Thank you.
  3. D

    Excel VBA to compare 2 dates, evaluate cell contents, and enter value

    Good afternoon all, I have a workbook that has several tabs. Each tab has 1 table of information, and each tab is for use by an individual unit. The table has several columns and rows of information including one column that contains dates (DEROS column), there are also columns that contain a...
  4. L

    VBA Change Entire Columns with specific header to Value instead of Formulas

    Hello, I need help with a bit of VBA code. I have columns AIFinal01-AIFinal20 throughout my sheet. Each column contains a formula going to the bottom. I need to change that formula to a value for all 20 columns. The columns are not in direct order and their are columns between them. Any help is...
  5. H

    Text to Columns with multiple delimiters

    I wonder if you can help. I have been tasked with extracting text from a CSV download from an app of a list of standard responses. As a download these contain multiple strings of characters such as: <p>Hello {{ entity.person.display_name }}</p><p><br></p><p>Thank you for your...
  6. C

    Copy Multiple Columns and Paste to Different Sheets based on Header

    Hi All! I'm creating a dataset type of spreadsheet where I monitor data of three different types for example distance , velocity and acceleration. Each has its own sheet and results are logged for different years 2015,16,17,18 etc. Id like to program an input data tab where i can paste the...
  7. kelly mort

    Code adjustment for numbering items needed-vba

    Dim e& e=0 With Sheet1.[A2:A10] Do e=e+1 Loop Until IsError(Application. Match(e, .Cells,0)) End with I am using this code , which I got from this same forum here some time ago. It's working great, now I need some adjustment. I want to look at two columns for the...
  8. J

    Help! Consolidating rows across columns with duplicate names!

    Hey, I've tried to look through the forum and see if this has been asked, I haven't found anything quite like what I'm looking for - Basically, I have information from a school. Column A is school ID, column B is a students name. Columns C through I have information regarding a particular...
  9. B

    Not sure how to do this easily?

    Hi I have created a work book which is basically which is a stock control book which covers a fiscal year. my problem is that the prices are set in one column for each month by linking each month to the next separately this allow or price changes at the beginning of each month. For each month...
  10. S

    Match & sum

    Hello All, I have a requirement, where in i have a master sheet, with Sheet Name reference, column Name, what i have to do is =Sum(sheetname reference with indirect formula),column Name reference in master sheet, where the columns in data sheet is in A5:D5).
  11. T

    If Lookup?

    I have one file with two sheets. One sheet one in row one I have one column as name, column two as a number and column three as a month of the year. On my sheet two I have the same three columns. How can I pull just a single month (like Jan) from the sheet one to sheet two? Doing this using a...
  12. T

    match / algn to columns and add rows where no match

    Hi I have the following that I need help on: column A ID (it has many of the same ID's as column B) Column B ID (it has many of the same ID's as column A) Column C to P is the rest of my data that aligns with column B. I want column A and B to align so that column A to P all align. In excel...
  13. B

    SUMIFS across multiple columns.

    I am looking to count the values of a certain column, based on various criteria across other columns. What I am currently using is: =(sumifs('Workbook A'!$J:$J,'Workbook A'!$D:$D,$A3,'Workbook A'!$B:$B,">="&CP$1,'Workbook A'!$B:$B,"<="&CP$2)+sumifs('Workbook A'!$J:$J,'Workbook...
  14. V

    Append table with another table and user input

    Hello guys, I have an issue which I assume is very simple yet I can't seem to figure it out. (Just started learning Access a few weeks ago) I have a table called Table1 with the following columns: <tbody> ID (autogenerated) SUB Month Total Comments 1 GOP 1901 500 Payment 2 GAP 1901 600...
  15. M

    Display 2 rows with multiple columns as 1 row with multiple columns

    Hi. I have a spreadsheet that has two rows of data both with multiple columns. One row has 16 columns of data and the one below has 10 columns of data. ABCDEFGHIJKLMNOPQRS 12345678910111213141516 12345678910 Does anyone know the formula to display the data as one row adding the data from...
  16. W

    How to find N similar items with 2 or more columns?

    Hi, I want to find N similar items based on 2 or more columns. In the example below I am trying to find similar items based on 3 columns. <tbody> City Population Number of pets Number of traffic lights City1 10561 466 121 City2 10444 498 101 City3 928 280 61...
  17. P

    VBA looping through specific columns

    Hello All I am looking for a way to loop through specific columns i.e. columns # 27,30,38,39,47,48,50,52,53,54,61,72,74,75,76,77,78,79 and in each of those columns, copy a formula from the first cell at the top of that specific column, down to all the rows in that column (lets say from line 3 to...
  18. D

    VBA for setting cell value equal to the found value in a range offset by two columns

    Hi, I was trying to come up with a code for setting cell value equal to the found value in a range offset by two columns, but I can't get it to work. Noting the code I tried out, please let me know how it could be done. Thank you, David P. Private Sub Worksheet_Change(ByVal Target As Range)...
  19. J

    Conditional Formatting - Highlighting differing values

    Hi all, If I have multiple columns that I'm identifing differences in, and what to highlight those differences. What conditional formatting formula could I use? Example: Columns A2 and B2 should be the same, but they are different values. I want to highlight both cells. This rule would be...
  20. J

    Looking for information on Automating a Reconciliation Report

    Hi all, New to this board, and hoping to get some good advice. My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top