Question about Microsoft Excel for PC

1 Answer

Hi friends i have more branches file and i want to do make one file of my all branches report in execl i working in tally all expenses inculed how to do

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 272 Answers

Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.

Posted on Dec 27, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to export tally 9 to excel sheet


Hi,
Great question and there are two way export date. Please follow step by step instruction.
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

More information please visit this link.
http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Jun 10, 2014 | HP Office Equipment & Supplies

1 Answer

EXPORT TALLY7.2 DATA INTO EXCEL SPREADSHEET


Hi,

Please follow the below step for your problem.

Go to Gateway of Tally> Balance Sheet (Here you can choose any report which you want export in tally)

Step 1: In the Balance sheet screen click E: Export or press Alt+E.

Step 2: Select the required language from the list of languages displayed.

Step 3: Select a format from the list of formats displayed.

Step 4: By default, the exported file will be stored in C:\Program files\Tally.ERP 9 for windows 7 and C:\Tally.ERP 9 for windows XP operating systems.

Step 5: Press Enter to accept the default output sheet name.

Step 6: To update the existing file select yes in update existing file.

Step 7: To format the contents of the file selects yes in Excel (Spreadsheet) formatting.

Step 8: Select yes for the filed with color, to retain the background color in the exported file.

Step 9: Accept to export the Balance Sheet to an excel file.

Thanking you

davevipul197

Jun 04, 2011 | Tally T2245 Matrix Printer

2 Answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.


Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.

Apr 15, 2010 | Microsoft Office Excel 2007

1 Answer

Tally odbc


Whatever reports you want ot convert in Excel there is a command in Tally to Export File. you can select excel in export configuaratin. Even .CSV formats can also be opened in excel.
To Export File in Excel .. In tally Goto that report and press ALT+E or look for "Export Command on Tally Toolbar or left panel.

Mar 23, 2010 | Tally T6218 Matrix Printer

1 Answer

While using Execl , we are getting compatibility


.xls files opened in Excel 2007 is "always" in "Compatibility Mode" since default 2007 excel files have .xlsx extensions

Sep 16, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Tally9's features


Tally uses the latest technology to provide features in a simplified manner. It is a robust system that is easy to use.

Multilingual Business Accounting and Inventory Management Features
  • Multilingual Support: Tally can now be used concurrently in the language of your choice. Tally's interface is now available in Bahasa Melayu besides English and the Indic languages Hindi, Kannada, Bengali, Gujarati, Marathi, Tamil, Punjabi, Telugu, Malayalam and Hinglish (colloquial)

  • Payroll: Payroll in Tally enables users to set up and implement simple to complex salary structures. You can align and automate payroll processes and directly integrate them with main stream accounting applications. Tally Payroll also supports configurable formats for payslip printing; flexible salary/wage, attendance, leave and overtime registers; gratuity and expat reports

  • FBT (Fringe benefit tax): FBT in Tally is a one time, easy to enable configuration. It supports Challan management and printing for prompt and accurate filing of tax. On entering the transactions, Tally automatically calculates the FBT and generates the reports

  • VAT Composition Returns: VAT Composition Returns in Tally provides fast and error-free voucher entry with complete tracking of each transaction. It supports the printing of VAT Composition Returns of any state in which VAT has been implemented. The Composition Rate of VAT is automatically recognised based upon turnover and the tax payable is calculated automatically and shown in the Return Form

  • Excise for Dealers: Excise for Dealers in Tally generates Excise Invoices for Traders, Tracks Purchase Invoices during sales and duty credit availed and passed on. It also maintains the Excise Stock Register and generates Quarterly Returns

  • TDS (Tax Deducted at Source): Tally allows you to configure TDS ledgers by specifying the Nature of Payment and Assessee Types, along with the Rate of TDS. It determines user-defined expense/payment types with user-defined rates. TDS can be deducted automatically based on pre-defined rates, once the transactions exceed the threshold limit. You can generate Challans, the Form-16A Certificate as well as the quarterly and annual returns. Tally also generates e-TDS files in NSDL compatible formats

  • Synchronization: Synchronization in Tally helps you transfer data between two or more locations (Example: When a Branch Office and the Head Office of a company reside in two different locations). Synchronization can be done, both ways (For Example: You can transfer the data from Branch Office to Head Office or vice-versa).

  • E-mail reports and documents directly from Tally

  • Publish reports in HTML on Web or Intranet and share them with suppliers, customers or your own staff

  • Direct web browsing capability from within Tally that avoids switching between programs

  • Exchange data with other systems using XML. Tally gives you the means to collaborate with others and share information like never before

  • ODBC connectivity opens up Tally. This makes Tally fields in ODBC to be compliant with programs like MS Word and MS Excel. This enables you to integrate Tally data dynamically into other ODBC systems. It even designs a form like remittance advice and imbed fields like Customer name and address, account balances and so on, in Excel/word

Jul 11, 2009 | Tally Intelliprint ML450 Laser Printer

6 Answers

Tally 5.4 error


try to configure your configuration setting. change the data source where you data saved.

Exp (from program files, configuration setting) :

;; Tally eis 5.4 workstation specific parameters file

[Tally]

; Specify location of Data files

Data = D:\data tally\Tally 2\DATA

;; Specify list of companies to preload
; ** TO STOP DEFAULT LOADING set the following line to NO

Default Companies = Yes

Load = 0001
;Load = 0002

; Specify list of TDL files for user defined reports and changes
; ** TO STOP LOADING TDL FILES, set the following line to NO

User TDL = Yes

;TDL = <TDL file 1>


; Specify location of TALLY.SAV (saved configuration of Tally)

Config = c:\TALLY

; Specify Color details of local monitor

Color = Yes



a bold letter is the source of data that you must change.

Jun 22, 2009 | Computers & Internet

1 Answer

File damaged


if you reinstall tally it will not delete your saved tally files(data files)

Jun 25, 2008 | Computers & Internet

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet


you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...