Hi Roy,
Good Morning,
Thank you so much for your help. I checked the file and yes I am looking exactly that but with $ symbol as well. I saw cell format - 0000 00 0\,00
But then when i change value by entering 2500000 then some zeros are coming - 0025 00 0,00
As this cell value will change as per application amount. Also i have to add $ as well.
Will you please help me and i really thank you for all your supports.
Thank you,
Many Regards,
Niky
Hi Roy,
Thank you for your suggestion. I did remove comma but how i can get rid of decimal point and i need comma because French Canadian use comma instead of decimal point.
And it is still not working that way like - 1 500 000,00
Thank you again for your help. Please let me know how i can replace "." with ","
Many Regards,
Niky
Hi Roy,
Thank you for your help but that is not working i did try that before.
it is still giving me comms and decimal point - 1,500,000.00 $ but i am looking instead of comms it should be space and where decimal point it should be comma like 1 500 000,00 $ and that is only for one cell value.
Thank you and if you can help me further then i really appreicate.
Thank you again,
many regards,
Niky
Hi there,
I am having Excel document where only one cell value from Number/Currency to change as Canadian French currency format where commas will be showing space and decimal point will come as comma.
Example : $1,500,000.00 to 1 500 000,00 $
when i use below formula that is working but I need to use this in VBA macro and I honestly don't know how i can add in Macro.
=SUBSTITUTE(TEXT(A1, "# ### ##0.00 $"),".",",")
Thank you
Regards,
Niky
Hi there,
I am looking macro to save word document to PDF file and use file name based on content of word document.
For example: I have to create word file from approved application email and add that Application Number : 12345 (every time this number changes but text before this number i.e. Application Number: remains same)
and this is not mailmerge as i have to copy Application Number from the email and add into word document and save that file using that Application Number in PDF.
is there anyway i can make macro to search words Application Number: and copy entire line along with unique application number (12345) and save as PDF file?
For your reference attaching sample word file.
Thank you in advance!
Many Regards,
Niky
Hi Roy,
this is not coursework. I am working in the company and we want to help our other team to make something like shared workbook. Data i used from your workbook.
I really appreciate for your help and will you please help me more with this project. Thank you.
Hi Roy,
Thank you so much for all your help. I could open files in my home computer. But I am sorry i am not good at VBA. May i please request your more help with my project. I am attaching you example file. I have one admin worksheet where data taken from other sales rep worksheets. All sales rep can only open their worksheets and they have to put password. so this way file can be shared and they can only able to work on their worksheet.
Thank you once again for all your help.
Many Regards,
Niky
Hi RoyUK,
Thank you so much for your quick response. May i request you so put VB codes here as i am trying to open excel workbook and due to my company policy it says macros are blocked.
Really thank you so much!
Regards,
Niky
Hi All,
will you please help me to write vba coding to protect each worksheets in shared workbook with different passwords.
I am having 10 users to use shared workbook. And all 10 users have 10 different worksheet of their names. I want them to only work on their names worksheet and not able to see other worksheets. to open their name's worksheet i want to create password and by entering their own passwords they able to open their name's worksheet.
Example: I have created 10 worksheets names as - 1. Niky, 2. Palak, 3.Helly, 4. Vandit, 5. John, 6. Lidia, 7. Jeremy, 8. Paul, 9. Cynthia and 10. Martin in one shared excel file.
Now if Niky wants to work she needs to click on Niky worksheet and it should i ask for password to open that worksheet and she can work on that and save. But she can not open any other worksheets. And same with all other 9 user's worksheets.
Thank you and I hope my question is clear.
Regards,
Niky
Hi Alan,
Thank you so much. really appreciate your reply.
Thanks again.
Regards,
Niky
Hi,
I am sorry. I have to report each date counting of each categories of province. for my reporting i have (ON, AB and BC) provinces and also for each day how many language received that is total number of English (E) and total number of French (F).
I am attaching another dummy file for more clarity.
Thank you so much.
Regards,
Niky
Hi there,
Good Morning,
I am attaching file which we are working on daily bases and need to report in the evening. at the moment with my simple formula it is working good but if i change any row for date change then i have revised my report. i tried to use pivot table but it is also not working the way we want reporting. Thank you so much for always helping in this forum. please find attached file.
Regards,
Niky
Hi Carim,
Thank you once again for all your support. really appreciate a lot!
Regards,
niky
Hi Carim,
Good Morning,
a big Thank you! wow it's working well. Really thank you so much! appreciate your help always! one kind request how i can see code for Macro as I need to give real person names in all teams. Thank you.
Regards,
Niky
Hi Carim,
Thank you for your quick reply. Please find attached example of vacation list file. Thank you once again.
Hi there,
I am looking for help to create vacation worksheet. I have 3 different teams and each team has different colour code. i want to create monthly vacation worksheet where in one cell whoever take vacation then display colour code based on their team. I managed to do with conditional formatting but when 3 members from all different teams taking vacation on same day and i used comma to separate them then i want each member font colour appear on cell. for example -
Team A [RED colour] members: NT, ST, SS, BS
Team B [Green colour] members: PS, JS, DP, AP
Team C [Blue colour] members: TP, BP, KK, HW
Now in cell A5 for Feb -5 date member NT from team A, member PS from team B and member TP from team C has taking vacation so my cell A5: NT, PS, TP here i want NT text show Red colour, PS show Green colour and TP should show Blue colour text.
Thank you so much
Regards,
Niky
Yes i am sorry it is related to word and PDF. my apologies.
Hi there,
I really need your help as in my company we have to send NPS survey email to our client and we need word and PDF file with radio button for saying rate our services from 0 to 10 and client can click on radio button associated with any number. for example -
1. Communicating effectively
0 – Not at all Likely 10 – Extremely Likely
| Poor | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Excellent | N/A |
| radiobutton1 | radio2 | radio3 | radio4 | radio5 | radio6 | radio7 | radio8 | radio9 | radio10 | radio11 | radio12 |
Thank you so much. really appreciate if you can help me with this project.
Regards,
Niky
Hi Roy,
Thank you for suggestion. I uploaded example file. Please review. Left part Buy-down Rate is not giving me any result. Thanks again.
Hi there,
I want have one excel file for calculating buy down amount but other part of that excel file i need to calculate buy-down rate. Will you please help me to find out buy-down rate please.Thank you. [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 393, colspan: 2"]RATE BUYDOWN - SOLVE FOR RATE[/TD]
[TD="width: 36"] [/TD]
[TD="width: 394, colspan: 2"]RATE BUYDOWN - SOLVE FOR AMOUNT[/TD]
[TD="width: 40"] [/TD]
[TD="width: 64"] [/TD]
[TD="width: 64"] [/TD]
[TD="width: 146, colspan: 2"]P&I Payments[/TD]
[TD="width: 64, align: center"]#DIV/0![/TD]
[TD="width: 54"] [/TD]
[TD="width: 128, colspan: 2"]P&I Payments[/TD]
[TD="width: 64, align: right"]1674.566[/TD]
[TD="width: 64"] [/TD]
[TD="width: 185"]M12*O3*(O6/(O6-1))[/TD]
[TD="colspan: 2"]Bought Down Factor[/TD]
[TD="align: right"]0[/TD]
[TD="colspan: 2"]Bought Down Factor[/TD]
[TD="align: right"]0.001577[/TD]
(1+M14/M15)^(M15/M16)-1
[/td]Payment Frequency
[/td]
[TD="align: left"] [/TD]
Payment Frequency
[/td]
[TD="align: left"] [/TD]
Outstanding Principal:
[/td]$ -
[/td]Outstanding Principal:
[/td]$ 400,000.00
[/td]
[TD="colspan: 2"]Term Bought Down Factor[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 2"]Term Bought Down Factor[/TD]
[TD="align: right"]1.01909[/TD]
(1+O3)^((E6/12)*M16)
[/td]Term (months):
[/td]
[TD="align: right"]0[/TD]
Term (Months):
[/td]
[TD="align: right"]12[/TD]
[TD="colspan: 2"]Amortization Factor[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 2"]Amortization Factor[/TD]
[TD="align: right"]1.604413[/TD]
(1+O3)^((E7/12)*M16)
[/td]Amortization Period (months):
[/td]
[TD="align: right"]0[/TD]
Amortization (Months):
[/td]
[TD="align: right"]300[/TD]
[TD="colspan: 2"]Maturity Balance[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="colspan: 2"]Maturity Balance[/TD]
[TD="align: right"]387366.1[/TD]
M12*O5-(O2/O3*(O5-1))
[/td]Current Mortgage Rate:
[/td]
[TD="align: right"]0.000%[/TD]
Current Mortgage Rate:
[/td]
[TD="align: right"]3.260%[/TD]
Yield Factor
[/td]
[TD="align: right"]0[/TD]
[TD="colspan: 2"]Yield Factor[/TD]
[TD="align: right"]0.002698[/TD]
(1+M13/M15)^(M15/M16)-1
[/td]Buydown Amount:
[/td]$ -
[/td]Buydown Rate:
[/td]
[TD="align: right"]1.900%[/TD]
[TD="colspan: 2"]Term Yield Factor[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 2"]Term Yield Factor[/TD]
[TD="align: right"]1.032866[/TD]
(1+O8)^((E6/12)*M16)
[/td]Mortgage Payment:
[/td]
[TD="align: right"]0.00[/TD]
[TD="colspan: 2"]Present Value[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="colspan: 2"]Present Value[/TD]
[TD="align: right"]394786.9[/TD]
O7/O9+O2*(O9-1)/(O8*O9)
[/td]Buy-down Rate:
[/td]
[TD="align: right"]0.000%[/TD]
Buydown Amount:
[/td]$ 5,213.14
[/td]
[TD="align: right"]0.00[/TD]
[TD="align: right"]400000[/TD]
[TD="align: right"]0.000%[/TD]
[TD="align: right"]3.260%[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0.000%[/TD]
[TD="align: right"]1.900%[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
Monthly
[/td]Monthly
[/td]Monthly
[/td]Monthly
[/td]
[TD="colspan: 2"]Semi Monthly[/TD]
[TD="colspan: 2"]Semi Monthly[/TD]
Bi- Weekly
[/td]
[TD="colspan: 2"]Bi- Weekly[/TD]
Weekly
[/td]Weekly
[/td]
[/TABLE]
