EXCEL HELP
This query is : Resolved
13 November 2009
HI ALL!
I HAVE CREATED AN INVOICE TEMPLATE IN EXCEL. THIS HAS AN AUTONUMBERING CODE FOR THE SERIAL NUMBER. EACH TIME A INVOICE IS MADE AND THEN SAVED THE REOPENING SHOWS THE NEXT SERIAL NUMBER. I ALSO NEED TO LOCK THE CELL CONTAINING THE FORMULA BEING EDITED. I HAVE MANAGED THIS AS WELL. SO FAR SO GOOD. HOWEVER, WHEN I OPEN THE INVOICE THE AUTO NUMBERING FORMULA DOES NOT WORK. ANY SUGGESTIONS PLEASE. I CAN USE THIS TEMPLATE AS AN EXCISE INVOICE ONCE THIS PROBLEM IS SOLVED. THANKS
I HAVE CREATED AN INVOICE TEMPLATE IN EXCEL. THIS HAS AN AUTONUMBERING CODE FOR THE SERIAL NUMBER. EACH TIME A INVOICE IS MADE AND THEN SAVED THE REOPENING SHOWS THE NEXT SERIAL NUMBER. I ALSO NEED TO LOCK THE CELL CONTAINING THE FORMULA BEING EDITED. I HAVE MANAGED THIS AS WELL. SO FAR SO GOOD. HOWEVER, WHEN I OPEN THE INVOICE THE AUTO NUMBERING FORMULA DOES NOT WORK. ANY SUGGESTIONS PLEASE. I CAN USE THIS TEMPLATE AS AN EXCISE INVOICE ONCE THIS PROBLEM IS SOLVED. THANKS
27 February 2010
mail me that file to my id ankurpandey84@gmail.com
i will solve it
i will solve it
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- About TDS & Income Tax
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Pass word to open justification report for Q1 for FY 2026-27
- Section 194JA & JB Income which ITR Form to use
- Under construction property in ITR
- Scrutiny and reopening of past returns
- PPF interest-As Exempt Income disclosure
- Upload Level ValidationITR3Category of Defect B/D
- Not able to file ITR
- Building tax payment deduction in rental Income
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
