add columns

  1. A

    Adding two columns with equations in every other column using VBA

    Hey I hope someone can spare some time to help me with this. It's starting to hurt my brain. I'm a novice user. I'm part way through a macro to handle a data set and this has me stumped. I can't find a macro that works to add 2 columns in every other, and then to add (or copy) equations for...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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,
  7. 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...
  8. 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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top