How to Add Data of Different sheets in a single sheet

**mfhaq77** · 05-10-2015, 01:40 PM

Hi everyone,

I have an Excel Workbook with 28 sheets.
All the sheets have same Column Headings and same type of Data.

Now how can I add all the sheets in a single sheet (without repeating the column headings of every sheet)
Could you please provide me with an easy solution to this problem.
I don't want to do it manually. It will take long time.

The file is uploaded here for your convenienceHow to Add Data of Different sheets in a single sheet.xlsx

**luv2glyd** · 05-10-2015, 06:41 PM

no way I know of doing this with regular formulas, but you can record a macro if this is something you have to do over and over again. Also, for quicker selection of the contents of each sheet, select cell A2, press control and shift keys together, then left arrow key - this will select all columns with data (just in one row). Now to select all the way down, keep holding the control and shift keys and press the down arrow.

**Richard Buttrey** · 05-10-2015, 06:52 PM

Hi,

It shouldn't take a long time and unless you need to repeat the task on many occasions I'd advise you just get on and do it. By the time you've recorded a macro, edited it to make it usable, tested then debugged it you will have spent more time than just doing it manually.

Easiest way is select A1 in a sheet, hold the shift key down and do an [End] [Home] to select all cells, hit Ctrl-C to copy, select the summary sheet, go to the next row and hit Ctrl-V. Job done.