Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Printing Cheque of Different sizes from the same Worksheet

Posted on 2008-11-15
Medium Priority
Last Modified: 2012-05-05
Hi All,

>>>>>>>>>>>>>>       Present Scenario        >>>>>>>>>>>>>>>>>>>>

I have bank account in 4 banks and at present I am printing my cheques through Excel on a laser printer.

Cheque belonging to each bank are of different size (length and width). On each cheque there are some basic fields (like "Name of Payee, Amount in Figures, Amount in Words, Date, Mode of Payment" etc,  which are to be filled by Cheque issuer. Presently the issuer fills these fields in Data Source sheets (HDFC3772 and SBOP5620) and data is automatically VLOOKUPed in "Cheque" sheet).

At present I am maintaining a "Cheque" sheet "separately" for each bank, where fields have been placed in such a manner (at specified distance and of specified width) that when printed, the value of each fields comes out properly on a blank cheque. Field Values changes according to 'Cheque No' selected from Cell E1.

Required Data is taken from Data Base sheets maintained for each bank (i.e., HDFC3772 and SBOP5620)

>>>>>>>>>>>>>    Now here is What I wish        >>>>>>>>>>>>>>>

--Sheet named "CPC" (Cheque Printing Configuration) contains, for each bank's cheque, the physical measurements i.e., Size of the Cheque, the distance of each field from top edge and left edge of the cheque, and width of each field. The measurements are to be taken physically by the user at first use. The defined name for the relevant range is "CPCrng".

--Instead of separate "Cheque" sheet for each Bank, there is only one "Cheque" sheet with the above fields on it (or may be Single user form with Text boxes containing the required fields on it)

--G1 on "Cheque" sheet contains Name of the Bank for which Cheques are to be printed.

--Whenever we select the Bank Name from cell G1, the sheet / user form and fields / text boxes thereon are automatically resized / redistanced as per the dimensions provided for that Bank in sheet CPC. Off course the Field values will then be based on Cheque No in Cell E1, as at present.

>>>>>>>>>>>>>>   Notes  >>>>>>>>>>>>>>>>>>>
--The sample sheet contains the Data Source Sheet for 2 banks only.
--Source Data for each bank surely will continue to reside in separate sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly the same.
--Cheque List in cell E1 has been configured to adjust for data source as per Bank Name selected in G1.
--If the proposed solution needs "user form and text boxes", then kindly tell how the formulae will be used in those text boxes, as presently I don't know how to do that.
--A sample file alogwith the desired format has been provided.

CA Kanwaljit Singh Dhunna
Question by:Kanwaljit Dhunna
LVL 20

Expert Comment

ID: 22971428
i suggest you use cheque printing software which in available online

Accepted Solution

Kanwaljit Dhunna earned 0 total points
ID: 22978500
Thanks a lot. But that does solve my problem, as I am distribute the files to other users too and they can't afford to spend on some paid software. So I am trying to centralize and solve the problem myself.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question