combining sheets

Hi guys, I've made a couple of example tables to explain my problem (see tables below). I'm struggling with the following: I have two sheets. Sheet T1 and sheet T2. I want Excel to take the data from column C from sheet T2 and put it into column D of sheet T1 to form sheet T3. So Excel...

First of all I'm not using Excel as a norm spreadsheet. I'm using it to create customer billing forms with detailed word processing as well as needed calculations. I don't have a problem with that part of it, my problem is combining 2 sheets of the workbook only when a second page is used. My...

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

I am downloading a report into excel on a weekly basis. It downloads into about 50 sheets in one workbook and I cannot change that so I am looking for a macro that will combine them into one long sheet. I would like it to create a new sheet and copy/paste each row (all columns or A-Q if it...

Hi have data which i download from a system monthly. By default, it creates a new book/sheet and it is store this way.. I need a way to combine the months data, 30 sheets into one quickly. How can i do this with out copy/paste all sheet individually? (fingers crossed)

Hello there, I am needing some help on merging information from multiple sheets into one sheet. I am currently keeping track of averages for a racing club (horses) and at the end of each year, we pull all of the averages, and the top ten go to our finals. Is there any way to get the...

Hi, I have a question which, so far, the other threads haven't been able to assist me with....I am an Excel novice. I have two work sheets (I'll call them 1 and 2) both contain different information about the same records; 14625 of them on 1 and 14687 on the other; each record is...

I know what I am trying to do should not be so complicated but I am having trouble finding out how to do it online. This is what I think I need to do: 1) to take columns A, B, and C from sheet 1 and insert them into columns A, D, and G in sheet 3. 2) take columns A, B, and C in sheet 2 and...