<div>
What is (Openoffice)Odt excel? <br />
<br />
can you use VBA there ? if yes then the answer to your request is YES.<br />
gowflow
</div>


<div>
You may want to have the mods change your topics as there really is no thing called Open Office Excel. &nbsp;They have a program called Calc that is very similar and I am guessing that is what you are using. &nbsp;There is the ability to write custom codes/macros in Calc but they do not us VBA like Microsoft products. &nbsp;I can help you work through getting a macro running, but I don't know that I fully understand what you want. &nbsp;<br />
<br />
Are you just wanting to take two sheets and combine them into one sheet? &nbsp;Is this an ongoing task? &nbsp;Is the data in both sheets sorted and is the task list the same on both sheets? &nbsp;If so, why not just copy and paste? &nbsp;If a value is only in one list, what do you want to happen? &nbsp;<br />
<br />
You basic question was if this was possible. &nbsp;The answer is very likely yes, but how we do it may vary substantially based on the details.
</div>


<div>
Hi ltlbearand3,<br />
<br />
Apologies for the confusion, Yes i use calc.<br />
<br />
For ur questions, the order wont be sorted, i can just copy paste it, but there are more than 2 sheets . Hence i am looking for a way to automate this work.<br />
<br />
Thanks
</div>


<div>
Ok. &nbsp;I will see if I can post some starter code tonight or tomorrow. A few more questions. &nbsp;Do all sheets contain all the tasks and are the tasks in the sheets in the same order? &nbsp;Is this a one time process or will it be run multiple times on this sheet (i.e. will this be a reoccurring item?)
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a openoffice odt file.<br />
It has 2 sheets .Sheetname is Eg.Dec1,Dec2 <br />
Each sheet has the same formatted data.<br />
Eg.<br />
Sheet1<br />
ColumnB ColumnC<br />
Task1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4<br />
Task2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
Sheet2<br />
ColumnB ColumnC<br />
Task1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Task2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
<br />
The output i am looking is as below.<br />
Newfile-Sheet1<br />
ColumnA ColumnB ColumnC<br />
Task1 &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Task2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
<br />
Is this possible in (Openoffice)Odt excel?<br />
<br />
Thanks
</div>
</div>


Hi Experts,

I have a openoffice odt file.
It has 2 sheets .Sheetname is Eg.Dec1,Dec2 
Each sheet has the same formatted data.
Eg.
Sheet1
ColumnB ColumnC
Task1           4
Task2            1
Sheet2
ColumnB ColumnC
Task1           2
Task2            3

The output i am looking is as below.
Newfile-Sheet1
ColumnA ColumnB ColumnC
Task1         4                 2
Task2          1                 3

Is this possible in (Openoffice)Odt excel?

Thanks

Openoffice macro

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.