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
- REGARDING GST ON COMMERICIAL PROPERTY
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- TDS U/S. 194NF
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Applicable TDS rate for sale of property in Nov 2024
- Donation Receipt u/s 80G
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
Trending Online Classes
CAclubindia
