Query about ms excel
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
22 February 2012
My query is:
I need to print the 2 vouchers on the same page from MS Excel. I will link it with the main register thru vlookup.
Now i want that i should the give the base as range and the 2 vouchers on same page are printed like voucher 1 above and voucher 2 below.
Like if give range from 1 to 40 then it is printed in 20 papers i.e 2 vouchers on each page. So pl guide is it possible, & How?
I need to print the 2 vouchers on the same page from MS Excel. I will link it with the main register thru vlookup.
Now i want that i should the give the base as range and the 2 vouchers on same page are printed like voucher 1 above and voucher 2 below.
Like if give range from 1 to 40 then it is printed in 20 papers i.e 2 vouchers on each page. So pl guide is it possible, & How?
06 March 2012
not possible in excel as series of actions required. if u have the knowledge of the VB script then it can be programmed for the same using the interface between the two excel sheets.
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
- Gst credit note by supplier
- Missed uploading GST Invoice
- Movement of goods by packers and movers - type of sale - Reg.
- Query on effect of registration of property
- Due date for filing return for the partner in partnership subjected to Tax Audit
- GST on reimbursement of expenses
- Gratuity paid to legal heir above 20 lakh is taxable or not
- Wrong CMPo8 file
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
- ITC not to be taken in accounts & GSTR-3B
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
