data consoldiation

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...

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...

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...

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...

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...

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...