Printing Cheque of Different sizes from the same Worksheet

K

kanwalno1

Hi All,

Kindly mention yours email ID for the sample file.
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)

--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.
--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna
 
B

Bernard Liengme

S

Shane Devenshire

Hi,

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
A

Anoop Kumar

Dear Boss,
Pls. send Excell for Cheque print

thanks




kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

Hi All

Kindly mention yours email ID for the sample file

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

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

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

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

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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user for
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 Cel
E1, as at present

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

Regard
CA Kanwaljit Singh Dhunna

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Wor
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you

Answer Box: Numbers don't merge right in Wor
http://office.microsoft.com/en-ca/assistance/HA011164951033.asp

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.ht

about half way down the page
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi,One way is to write VBA which picks up the info and resized the check
Hi

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

:

Printing Cheque of Different sizes from the same Worksheet
Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Visual Studio.NET 2005 Install Tips and Tricks
http://www.eggheadcafe.com/tutorial...1f-b9cb60477329/visual-studionet-2005-in.aspx
 
A

Anoop Kumar

Dear Sir,
Pls. Send Excel macro for cheque print]

thanks



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

Hi All

Kindly mention yours email ID for the sample file

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

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

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

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

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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user for
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 Cel
E1, as at present

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

Regard
CA Kanwaljit Singh Dhunna

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Wor
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you

Answer Box: Numbers don't merge right in Wor
http://office.microsoft.com/en-ca/assistance/HA011164951033.asp

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.ht

about half way down the page
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi,One way is to write VBA which picks up the info and resized the check
Hi

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

:

Printing Cheque of Different sizes from the same Worksheet
Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

for Cheque Print in Excel
Dear Boss,
Pls. send Excell for Cheque print

thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown List - XML
http://www.eggheadcafe.com/tutorial...923-2457fe12d1cb/aspnet-dropdown-list--x.aspx
 
H

Hemant Shyamsukha

Sir ji,
Please send me the cheque format
Regards & Thanks
Hemant



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

Hi All

Kindly mention yours email ID for the sample file

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

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

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

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

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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user for
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 Cel
E1, as at present

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

Regard
CA Kanwaljit Singh Dhunna

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Wor
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you

Answer Box: Numbers don't merge right in Wor
http://office.microsoft.com/en-ca/assistance/HA011164951033.asp

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.ht

about half way down the page
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi,One way is to write VBA which picks up the info and resized the check
Hi

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

:

Printing Cheque of Different sizes from the same Worksheet
Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

for Cheque Print in Excel
Dear Boss,
Pls. send Excell for Cheque print

thanks

Excell Cheque print micro
Dear Sir,
Pls. Send Excel macro for cheque print]

thanks

Re : Chq Printing
Dear Anoop,

You want help or you want to help ?

Kanwaljit


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Custom Validation Using the Enterprise Library
http://www.eggheadcafe.com/tutorial...c-33ef1ec7d1a3/wpf-custom-validation-usi.aspx
 
B

Bernard Liengme

There is no built-in format that will give, for example, $*******45,123.78

But you can generate the effect in a helper column
With money value in A1, this formula
="$"&REPT("*",20-LEN(TEXT(A1,"#,##0.00")))&TEXT(A1,"#,##0.00")
gives results like $**512,345,670,123.67
and works for amounts up to 9,999,999,999,999.99
Just vary the 20 for smaller or larger amounts

This formula
=REPT("*",21-LEN(TEXT(A1,"$#,##0.00")))&TEXT(A1,"$#,##0.00")
gives results like *****$512,345,678.45

best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

Sir ji,
Please send me the cheque format
Regards & Thanks
Hemant



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Word
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


Hi,One way is to write VBA which picks up the info and resized the check
Hi,

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which
contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1
range.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

:

Printing Cheque of Different sizes from the same Worksheet
Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or
becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or
becoming a member, you will be redirected back to this page.

for Cheque Print in Excel
Dear Boss,
Pls. send Excell for Cheque print

thanks

Excell Cheque print micro
Dear Sir,
Pls. Send Excel macro for cheque print]

thanks

Re : Chq Printing
Dear Anoop,

You want help or you want to help ?

Kanwaljit


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Custom Validation Using the Enterprise Library
http://www.eggheadcafe.com/tutorial...c-33ef1ec7d1a3/wpf-custom-validation-usi.aspx
Click to expand...
 
M

Modeste

Bonsour® Bernard Liengme avec ferveur ;o))) vous nous disiez :
There is no built-in format that will give, for example,
$*******45,123.78
Click to expand...

;o)))

personnalised format :
$**#,##0.00

HTH
 
J

Jacob Yohannan

Hi,

Can u please provide me the cheque application which you created for different banks as I require it for my office work. I am in urgent need for the same I urge you to send me the same.



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

Hi All

Kindly mention yours email ID for the sample file

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

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

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

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

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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user for
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 Cel
E1, as at present

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

Regard
CA Kanwaljit Singh Dhunna

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Wor
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you

Answer Box: Numbers don't merge right in Wor
http://office.microsoft.com/en-ca/assistance/HA011164951033.asp

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.ht

about half way down the page
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi,One way is to write VBA which picks up the info and resized the check
Hi

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

:

Printing Cheque of Different sizes from the same Worksheet
Hi All,

Kindly mention yours email ID for the sample file.

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)


--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.

--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 will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

for Cheque Print in Excel
Dear Boss,
Pls. send Excell for Cheque print

thanks

Excell Cheque print micro
Dear Sir,
Pls. Send Excel macro for cheque print]

thanks

Re : Chq Printing
Dear Anoop,

You want help or you want to help ?

Kanwaljit

Chq format
Sir ji,
Please send me the cheque format
Regards & Thanks
Hemant

There is no built-in format that will give, for example, $*******45,123.
There is no built-in format that will give, for example, $*******45,123.78

But you can generate the effect in a helper column
With money value in A1, this formula
="$"&REPT("*",20-LEN(TEXT(A1,"#,##0.00")))&TEXT(A1,"#,##0.00")
gives results like $**512,345,670,123.67
and works for amounts up to 9,999,999,999,999.99
Just vary the 20 for smaller or larger amounts

This formula
=REPT("*",21-LEN(TEXT(A1,"$#,##0.00")))&TEXT(A1,"$#,##0.00")
gives results like *****$512,345,678.45

best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

Bonsour=AE Bernard Liengme avec ferveur ;o))) vous nous disiez
Bonsour=AE Bernard Liengme avec ferveur ;o))) vous nous disiez :=20


;o)))

personnalised format :
$**#,##0.00

HTH


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Binding Beyond the Limitation of Name Scopes
http://www.eggheadcafe.com/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cheque Print 0
Pulling information from three sheets into a fourth automatically? 3
How to show the next number depending on other data 13
report printing chaos 1
Want to Printing Sheet(x) from Sheet1 4
worksheet name to appear in cell 1
Linking Large Text Database to Excel 6
Working with the same main value (ClientID) thru different forms 1

Top