data consoldiation

  1. A

    Offset in VBA Code not working?

    Hi Guys, I have created a VBA code with help of a friend. The code copies contents of 2 columns on a sheet to a new sheet. But when I try to extend the code to copy more columns it just does not work. To be more clear it does not copy all of the cells below. Especially when I try to set it to 2...
  2. J

    PLEASE HELP with Macro for Data Consolidation

    To whom it may concern, Hello, my name is Jake, and today I'm working with a contact spreadsheet that is beyond my current skill set. I'm looking for help in writing a macro (I think that's what's needed). The command set is as follows: Look at columns A, B, C, D, & E (Sheet1) and determine...
  3. L

    XML files into Excel

    Hi all, I have to download 43 files from an outside vendor and then consolidate those files into one workbook. Currently they download into c:\Users\Downloads and I open each one individually and it converts into an excel table. Does anyone have any clues as to how can I easily get all of...
  4. G

    Consolidating Data

    Hi guys, I have some limited excel experience, but need help setting something up for my Mum. It is a record of shares she owns and the dividends they have paid her. I have a workbook with several sheets. each sheet has a table that is a record of an individual stock. Each table has 10...
  5. C

    Linking From and Re-Arranging Data

    I have a worksheet ("Roster") that lists all names in column F, and their assigned shift (1, 2, or 3) in column Q. I need to display the data in another sheet, with all names from shift 1 in one column, shift 2 in the next column, etc. I've tried VLookup, and Index & Match, but I only see...
  6. S

    Help please is suggesting project approach for multiple user data entry

    Workiing on an approval/database project. Approx. 50 users will fill out an Excel form and email (Outlook) it to one of three approvers at different times, maybe 5-10 a day in total. Approvers will make a decision and respond by email and also move data on request and approval to a single...

Watch MrExcel Video

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