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
- DELIVERY GOLD & SILVER AND OTHER ETF TRADING PROFIT AS BUSINESS INCOME
- GSTR-1A How to update Invoice
- Clubbing of Income - Minor
- Regarding Individuals Retuned to India and Resident currently
- Excess salary payment.
- 3cd- cash system of accounting is allowed?
- ERROR IN DEPRECIATION CALCULATION IN PREVIOUS YEAR COMPANY'S BOOKS
- Provision for loans that are under Revenue Recovery
- APPLICABILITYOF GST ON STUDENT HOSTEL FEES
- Form 121-contradictory opinions
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
- Updated return in budget 2026
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
