Search : in
By :

Combine 7 excel's into 1 excel

Last answer on Dec 12, 2008 10:17:38 am GMT deepti, on Dec 12, 2008 5:43:43 am GMT 
 Report this message to moderators

Hello,

I have 7 excel's .I need to combine all these into 1 excel under different work sheets.The column's are not same in any of the excel (entirelu diffreent).i have to automate these process...Please can anybody help me on this....

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « combine 7 excel's into 1 excel » in :
How to convert Excel into PDF? Show How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Cutting and pasting 90+ columns into 1 column Show
Convert excel report into DB table format Show
Expand your Desktop over multiple monitors ShowExpand your Desktop over multiple monitors Hardware Requirements Software Requirements How to proceed If you are using Windows and want to enlarge your current desktop without having to buy another huge screen, this is possible by...
Assembling multiple PDF files ShowAssembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
Excel - Using IF statement to add 1 to total ShowExcel - Using IF statement to add 1 to total Issue Solution Note Issue I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then add + 1 to cell B35. If...
Download Excel-MySQL converter ShowHenceforth with Excel-MySQL Converter, it is not necessary to be a developer to be able to convert Microsoft Excel data into MySQL database or vice versa. This program allows you to convert quickly your data without using other material. Depending...
Download Magic ISO ShowMagicISO is a creation/edition/extraction software of ISO images supporting a large number of ISO image format. It allows to create ISO images. It is also capable of converting ISO images into BIN format and vice versa. In addition, it allows to...
Download MessengerDiscovery Live ShowMessenger Discovery Live is an add-on for MSN Messenger Live that integrates with dozens of new functions and many characteristics to modify the behavior of this famous IM client. Advantage There are a multitude of options for managing contacts,...
Error checking ShowError checking Binary encoding is very practical for use in electronic devices such as computers, in which information can be encoded based on whether an electrical signal is present or not. However, this electrical signal may suffer disturbances...
Multichannel audio (5.1, 6.1, 7.1) ShowMultichannel audio The term "multichannel audio" refers to the use of multiple audio tracks to reconstruct sound on a multi-speaker sound system. Two digits separated by a decimal point (2.1, 5.1, 6.1, 7.1, etc.) are used to classify the various...
Ask your question Reply

1

karan, on Dec 12, 2008 9:47:25 am GMT

I have 7 excel's .I need to combine all these into 1 excel under different work sheets.The column's are not same in any of the excel (entirelu diffreent).i have to automate these process...Please can anybody help me on this....

   
Reply to karan

2

 Aadhi, on Dec 12, 2008 10:17:38 am GMT

Hi,
To the level of my understanding of your problemam answering this: if you it is not suitable, then please describe the issue specifically:

Say one Excel file has data in sheet 1 workbook (If u have changed the name, then that name, in this case Sheet 1):
Right click on that sheet 1, ih displays a list in that select 'Move or Copy" then a small dialog appears, click 'New Book' for 'To Book' option and check'Create a copy' checkbox. It'll open a new book with that data (don'e close this new excel)

Continue this in all the other 6 excel files and that time be sure you select the name of the newly cerated excel sheet in 'To Book' option.

Regards!
Aadhi

   
Reply to Aadhi
Ask your question Reply
They need your help