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
- TDS 194-T applicability
- GST ITC REVERSE
- Fixe term employment
- Is any professional CA is here please reply
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Putting a heading on received mail
- Reprocessing of rectification order AY 2025-26
- Consolidated financials
- Section 50-fixed asset-->building ceases to exist
- TDS on TRUST
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
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
