add columns

  1. V

    Add column using VBA & references in formula shift - simple solution?

    Hello! Once a month I receive a report that is not in the correct format. This report is the source data for another sheet I use to check the information the report contains against data from a few other sources. My aim was to save the new report in the same location each time, then use a...
  2. L

    Insert columns into worksheet (VBA?)

    I have a workbook that I am creating that does an analysis. The analysis can be done for 1 or 2 companies. Rather than making changes manually (like adding columns to a worksheet), I would like to be able to type "1" or "2" in to a cell and have a code linked to that cell that will do the...
  3. V

    How do I add a column of numbers up to a blank row

    I have to add data to a spreadsheet every day, and I leave a blank row between each day. I would to be able to add that column of numbers without changing the range manually. See example: <tbody> 1 2 3 6 4 5 6 </tbody> 15
  4. Z

    to copy data from sales receipt worksheet onto next column of sales summary worksheet

    :( Hello. I am trying to copy data from a 'sales receipt' worksheet onto the next available column of my 'sales summary' worksheet, then close both while saving the 'sales receipt' worksheet changes into a specified folder ("C:\My Documents\Sales Receipts") as a new file named by the value in I6...
  5. L

    add fields on queried output

    Hi, I an running a query on an external DB and showing required fields from Main DB. Is there a way, I can add few fields which don't exist in main-db in the query. The additional fields would be calculated (Field Called % Share * Total Profit)? any ideas please. Kind Regards,
  6. T

    Multiselect listboxes

    Hello - I would greatly appreciate some help with a problem I have come across. I have a form that has two listboxes and listbox1 is populated with the column headers in my worksheet. I want to be able to have the user select columns on the left and "add" them to listbox2. Here is the code...
  7. D

    How do I total multiple columns in one cell?

    I get #VALUE trying: =SUM(C2:C100)+(D2:D100)+(E2:E100) and =SUM(C2:C100+D2:D100+E2:E100) Can someone give me the correct syntax? It would also be cool to not have to give it an ending cell in the range from row 2 because it could be 80, 100, 150, 200 and the like. Thanks very much for your...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...