merge sheets

I need to combine data from two sheets into one based on employee number. Sheet 1 has all of the data in a single row for each employee. Sheet 2 has all of the employees dependent related information on multiple rows. Both sheets have a unique number for each employee. The number of related...

I have done some basics with Power Query, but I have a need that is beyond my limited skills. So I am turning to my favorite experts here for some help. I have created multiple workbooks with analytics where users input descriptions and amounts for the different accounts. There are 6 identical...

I need a macro two combine two separate sheets into an existing sheet in the same workbook. Sheet 1 i need all contents copied and pasted into a combined sheet. Sheet two I need all data excluding the top row. For each sheet I need columns A:K. I have a macro that works, but it creates a new...

Hello, I'm having a problem with a Workbook containing 12 or so sheets with some 56 columns per sheet. I would like to combine all sheets in to one master file and have the data for identical columns combined. To make it easier i think it is a good idea to start with a sheet that contains all...

Hello Everyone, From what I thought would be a straight forward function, this has had me scratching my head far too often this week. Until now, I've been manually sorting and copy/pasting in data, but this enhances the possibilities for errors. I've been trying to use a vlookup and index/match...

So I got assigned the project of the year for the company. I need to combine about 15 years of inventory into a searchable database so that I can import it into our new software. I managed to normalize the data from its multiple "index cards" to lists on worksheets. Now I need to combine those...

Good Afternoon people. I have been using this site for various macros over the last 3-4 years and have never needed to register as I found most of the answers. But I have now cause I never seem to find just what i'm looking for this time. I do have very basic VB knowledge, so please excuse me...

I am working on an email marketing program using Excel 2010 for my master database. I've exported opt-out email addresses as csv and want to merge with my master database. I converted the csv to xlsx and moved it to the same workbook as the master. I have been trying to merge the two...

I'm a new Excel Macro user and need all I can get. From multiple workbooks (source) (with same format), i need to copy multiple non contiguous cells ( say A2:A5, B1, C3, D8:D10) and paste them horizontally on another workbook (destination) starting at cell A6. Then need to do the same for the...

I have a workbook with about 20 tabs and a third of those tabs have a similar word in tab name, i.e. SALES_Detail. Detail is the same across tabs. Each sheet has identical column headings starting in row 2. What I would like to do is using the Detail in the tab name, merge all sheets into one...

Hi In One excel file i have 10 sheet.I need to merge all the 10 sheet into one sheet.1 below one i need to merge.The sheet count may change all the month. Simple word: 1 page need to contain all the sheet detail.

Hi, I have a workbook with multiple sheets (21 sheets) in it. The header on each sheet begins at row B5. The actual data starts from row B6. The number of rows in each sheet varies and the last row contains the total for all columns that has numbers. I wish to have one sheet that combines data...