Shamima Sultana
Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I'm working as a Project Manager at ExcelDemy. I am doing research on Microsoft Excel and here we will be posting articles related to this. My last educational degree was BSc and my program was in Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.
Hi Arda
Hope you are doing well.
I checked the code you mentioned above and it works. To make it more clear I’m attaching some images with the code.
Here, I tried the exact code in the same dataset.
MsgBox Range("E5").End(xlToRight).Offset(0, 1).Address
You can see the result $G$5.
Again I changed the dataset slightly.
Here, the result is also based on the location.
NB. If it doesn’t help you then please send your dataset to [email protected] or [email protected]
Thanks
Shamima Sultana
ExcelDemy
Hello Ava,
Thanks
Hello Tamiko,
You are most welcome.
Regards
ExcelDemy
Hello Huongpt,
You are welcome.
Regards
ExcelDemy
Hello Brenda Gale Austin-Sanders,
You are most welcome.
Regards
ExcelDemy
Dear Mario,
You are most welcome.
Regards
ExcelDemy
Hello Amanz,
We shared our ideas with you in your ExcelDemy Forum post.
Hello Adam Ingleton,
You are most welcome.
Regards
ExcelDemy
Hello Ani,
You are most welcome.
Regards
ExcelDemy
Hello Vijiaselvam Nayagam,
You are most welcome.
Regards
ExcelDemy
Hello Mohammad,
You are welcome.
Regards
ExcelDemy
Hello Suzie,
Glad to hear that our solution helped you.
Regards
ExcelDemy
Hello Romeo Nyi,
You are most welcome.
Regards
ExcelDemy
Dear Minzitia Lawrence,
You are welcome.
Regards
ExcelDemy
Hello Juan,
You are most welcome.
Regards
ExcelDemy
Dear Kagiso,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Azreim,
You are most welcome.
Regards
ExcelDemy
Thanks for your appreciation.
Regards
ExcelDemy
Hello Lee G,
You are most welcome.
Regards
ExcelDemy
Hello Tanveer,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Mian Muhammad Saleem,
You are most welcome.
Regards
ExcelDemy
Hello JD,
You are most welcome.
Regards
ExcelDemy
Hello Eduardo,
You are welcome.
Regards
ExcelDemy
Dear Sam,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Mongwongprue Marma,
You are welcome.
Regards
ExcelDemy
Hello Calin,
You are most welcome.
Regards
ExcelDemy
Hello Adam,
Thanks for your appreciation. You are most welcome.
Regards
ExcelDemy
Hello Ali,
Thanks for your appreciation. You are most welcome.
Regards
ExcelDemy
Hello Dawood,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Eduardo,
Kindly share your Excel File and images in ExcelDemy Forum.
Regards
ExcelDemy
Hello Daniel Woods,
To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.
Regards
ExcelDemy
Hello Daniel Woods,
To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.
Regards
ExcelDemy
Hello Abishek,
You are most welcome.
Regards
ExcelDemy
Hello David,
Thanks for your valuable suggestions.
Regards
ExcelDemy
Hello Mike Longoria,
You are most welcome.
Regards
ExcelDemy
Hello Z Thomas,
You are most welcome.
Regards
ExcelDemy
Dear Andrija,
You are most welcome.
Regards
ExcelDemy
Hello Mohammed,
Kindly share the issues you are facing while using the Excel file in the comment box. In case you need to share images, Excel file, you also can post your problem in ExcelDemy Forum.
Regards
ExcelDemy
Hello Syifaa’ Mustafa,
To get the Developer tab follow the steps mentioned in the article “Display the Developer tab in Excel“. Then you can use it to create Tooltip.
Regards
ExcelDemy
Hello Selam,
You are most welcome.
Regards
ExcelDemy
Hello DanJ,
You are most welcome.
Regards
ExcelDemy
Hello Matt S,
You are most welcome.
Regards
ExcelDemy
Hello Odedele Olufemi,
You are welcome.
Regards
ExcelDemy
Hello Joel,
You are most welcome.
Regards
ExcelDemy
Hello Chanyalew,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Lynn,
You are most welcome.
Regards
ExcelDemy
Hello Nasir Ahmed,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Anon,
You are most welcome.
Regards
ExcelDemy
Hello Vickie Addo,
We have given the answers of 100 questions in our Excel File, which is given in the Download Practice Workbook Section. As these questions are given to test your skills it won’t be helpful to check the answer immediately. A gif is given how you can test your skills at the end. Please download the Excel File and test you skills then see the answers.
Regards
ExcelDemy
Hello Venkatesh,
You are most welcome.
Regards
ExcelDemy
Dear Alexandar P,
You are most welcome.
Regards
ExcelDemy
Hello Naziom,
You are most welcome.
Regards
ExcelDemy
Hello Viraltecho,
You are most welcome.
Regards
ExcelDemy
Hello Joel,
You are most welcome.
Regards
ExcelDemy
Hello,
You are most welcome.
Regards
ExcelDemy
Hello Suhaili,
You don’t need to worry about payment. If you want any read-to-use template kindly send your requirements using [email protected] email.
Regards
ExcelDemy
Dear Dave,
You are most welcome.
Regards
ExcelDemy
Dear Komal Thakur,
You are most welcome.
Regards
ExcelDemy
Hello Samia,
In the Download Practice Workbook section, you will get the dataset used in the article.
Regards
ExcelDemy
Hello Nafez,
You are most welcome and thanks for you invitation to visit Qatar.
Regards
ExcelDemy
Hello May,
The “Developer Tab” option is missing in default Excel versions. You can enable it from Excel Options. By following this article Display the Developer Tab you can enable it easily.
Regards
ExcelDemy
Dear Laurie,
You are most welcome.
Regards
ExcelDemy
Dear Sovereign,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Sagar,
You will get the solutions in the Excel file, which is given in the Download Practice workbook Section.
Regards
ExcelDemy
Dear Anusha Uppuganti,
You are most welcome. We are so glad that our article explanation helped you.
Regards
ExcelDemy
Dear PK,
Thanks for your appreciation. You are most welcome.
Regards
ExcelDemy
Hello Tsegay Gebreselasie,
Our aim is giving you the best Excel-related content like this.
Regards
ExcelDemy
Dear Mark,
Thanks for your appreciation.
Regards
ExcelDemy
Hello Rolan,
Thanks for your suggestion. Article is updated.
Hello Damien,
From our Download Practice Workbook section, you will get the Excel file.
If you face any difficulties after downloading the above file, follow this article to Enable Macros but Not Working
Regards
ExcelDemy
Hello Taiwo,
All the solution are available in the Excel Practice file section.
We used this formula to get discount amount: =F5*IF(D5<1,0.03,0.05)
Regards
ExcelDemy
Hi viralTecho
Thanks for your appreciation.
Regards
ExcelDemy
Hello James Ward,
To run the code from Excel you can follow these steps:
Developer tab >> Macros >> Select any Sub Procedure from the list
Regards
ExcelDemy
Hello Hugh Richards,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Noe Albarran,
You are most welcome.
Regards
ExcelDEmy
Dear Yuan,
Thanks for the suggestions. The code is updated you can check it now.
Regards
ExcelDemy
Dear Amir
You have to use either the combined formula or the vba code. Because converting number to words maintaing the place vaule is not possible by simple formula.
Regards
ExcelDemy
Dear Ian Fisher,
You are most welcome.
Regards
ExcelDemy
Hello Viraltecho,
You are most welcome.
Regards
ExcelDemy
Hello Viraltecho,
You are most welcome.
Regards
ExcelDemy
Dear Roberto,
You are most welcome.
Regards
ExcelDemy
Dear Aubrey
You are most welcome. Your appreciation means a lot to us.
Regards
ExcelDemy
Dear Dilip Paunikar
You are most welcome.
Regards
ExcelDemy
Dear Soumendra
You are most welcome.
Regards
ExcelDemy
Hello Manwesh,
You can state your problem in the comment section or in our ExcelDemy Forum.
Regards
ExcelDemy
Dear Ashab,
We do have a YouTube channel named ExcelDemy
Regards
ExcelDemy
Dear Evangeline,
Thanks for your appreciation. Our experienced writers write these questions after doing a complete research about the topic.
Regards
ExcelDemy
Dear Jason,
You are most welcome.
Regards
ExcelDemy
Dear Ryan,
Glad to hear that our article helped you.
Regards
ExcelDemy
Dear Endashaw Balcha,
To know more about excel formula you can explore our Excel Formulas category. From here you will get practical use of different formulas in different fields.
Regards
ExcelDemy
Dear Raf,
You are most welcome.
Regards
ExcelDemy
Hello Muhammad Amin,
Good to hear that. To get more helpful contents explore our site.
Regards
ExcelDemy
Dear Jess,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Jimmy,
You are most welcome.
Regards
ExcelDemy
Hello y2mate,
Thanks for your appreciation.
Regards
ExcelDemy
Dear ytMp3,
Thank you so much.
Regards
ExcelDemy
Dear Martin Carrion,
You are most welcome.
Regards
ExcelDemy
Dear Dina,
Thank you so much for your appreciation.
Regards
ExcelDemy
Dear Navini,
You are most welcome.
Regards
ExcelDemy
Dear Gopi Sahu,
Thanks for reaching out to us. You will get various types of WFM related articles here Excel Solver
If you need solution of any specific topic kindly comment down below.
Regards
ExcelDemy
Dear Justice,
You are most welcome.
Regards
ExcelDemy
Dear Merry,
You are most welcome.
Regards
ExcelDemy
Dear Karen,
You are most welcome.
Regards
ExcelDemy
Hi Putul ch. Borah,
Yes, you can do it by following the mentioned steps.
Dear Tiago,
You are most welcome.
Regards
ExcelDemy
Dera Ashok,
You are most welcome.
Regards
ExcelDemy
Dear Foysal,
You are most welcome.
Regards
ExcelDemy
Dear kinyapreen,
To get virtual lessons you can follow our youtube channel Youtube Channel
Regards
ExcelDemy
Hello BART,
It is possible to add a VB line of code to run the selection change code only when you click the tab of the worksheet called “index.” To achieve this, you can use the Worksheet_Activate event in the code module of the “index” worksheet. Here’s the code.
Regards
Alif Bin Hussain
Dear,
You are most welcome.
Regards
ExcelDemy
Dear Bart,
You are most welcome. Sure, you can inform us.
Regards
ExcelDemy
Dear Najeeburk,
You are most welcome.
Regards
ExcelDemy
Dear Danny Van Straten,
If you need any types of customized templates you may contact us through [email protected]
We have a expert team to create any types of professional templates.
Regards
ExcelDemy
Hello Yaojm,
Thanks for your suggestions. Here we focused on the comparison/difference of VLOOKUP and XLOOKUPp that’s why we didn’t improvised the use of VLOOKUP.
Regards
ExcelDemy
Hello Pankaj,
You are welcome.
Regards
ExcelDemy
Dear Charlotte,
You are most welcome.
Regards
ExcelDemy
Dear Mustafa,
You are most welcome.
Regards
ExcelDemy
Hello Abubakar,
You are most welcome. We hope so you will be able to create an interim certificate template following these steps.
Regards
ExcelDemy
Dear B,
You are welcome.
Regards
ExcelDemy
Dear Akash,
You are most welcome.
Regards
ExcelDemy
Dear Carl,
You are most welcome.
Regards
ExcelDemy
Hello Dear,
You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Macel Williams,
To customize any templates you can contact with us via this mail problem @exceldemy.com
Regards
ExcelDemy
Dear Macel Williams,
To customize any templates you can contact with us via this mail problem @exceldemy.com
Regards
ExcelDemy
Dear Qasim,
Thanks for your suggestions we have updated our Exercise 3 you can check it now.
Regards
ExcelDemy
Dear Kenny H,
This Email address is valid but if you face any problem you can post your problem in our ExcelDemy Forum.
Regards
ExcelDemy
Dear Nikhil Pandey,
You will get all the solutions in the workbook’s Solution sheet. Here I’m giving you the query answer for your understanding.
The Formula is : =WEEKDAY(B5,11)
Regards
ExcelDemy
Dear Nikhil Pandey,
You will get the solution sheet in the Download Practice Files section. Download the workbook there in Solution sheet you will get all the solutions. You you can get the workbook from this link Solution Sheet
Regards
ExcelDemy
Dear Aiden,
Yes you can do that.
Regards
ExcelDemy
Dear Macel,
You are welcome.
Regards
ExcelDemy
Dear Marc,
You are welcome.
Regards
ExcelDemy
Dear Kim,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Prakash Tulsiani,
You are most welcome.
Regards
ExcelDemy
Dear Kay,
To get a customized templates you can contact with us through this Email: [email protected]
Regards
ExcelDemy
Hello Dear,
You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Nadew w/yesus,
You are most welcome.
Regards
ExcelDemy
Dear Dr,
You are most welcome.
Regards
ExcelDemy
Dear Adil Ahmed,
You are most welcome.
Regards
ExcelDemy
Dear Macel Williams,
You are most welcome.
Regards
ExcelDemy
Hello Dear,
You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Isaac,
You are most welcome.
Regards
ExcelDemy
Dear MADI,
Thank you for following our article.
To split into sheets based on certain row conditions, we have to enter an IF condition that checks if the row is of a certain colour. Here, I have added the code to do this.
This code checks if the interior colour of the first cell in each row of the selected range is Green(RGB(0,255,0)). The entire row is copied and pasted into a new sheet if rows meet the condition. You can alter this colour condition according to your need.
Regards
Priti
Dear Sara,
You will find the solutions in the Excel file which is given in Download Practice Workbook section.
Regards
ExcelDemy
Dear Sakshi,
You are most welcome.
Regards
ExcelDemy
Dear Md. Morshed Alam,
You are most welcome.
Regards
ExcelDemy
Dear Alex,
Thanks for your feedback.
Regards
Exceldemy
Dear Paresh Kanti Paul,
We are glad to hear that.
Regards
ExcelDemy
Hello Dear,
You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Sushil,
You are most welcome.
Regards
ExcelDemy
Dear Duncan R Walk,
You are most welcome.
Regards
ExcelDemy
Dear Bolajoko Olufemi,
You will get all resources related to Data Analysis here All About Data Analysis. We are planning to launch courses as soon as possible.
Regards
ExcelDemy
Dear Ronald,
You are most welcome.
Regards
ExcelDemy
Dear Ronhat Minmin,
If you want to get the Excel File, you can download it from Download Practice Workbook
Regards
ExcelDemy
Dear Ebrahim Ahmadi,
You are welcome.
Regards
ExcelDemy
Hello Dear,
You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Lin Giralt,
You are most welcome.
Regards
ExcelDemy
Dear Khin Soe,
You are most welcome.
Regards
ExcelDemy
Dear Tha’ir,
You are most welcome.
Regards
ExcelDemy
Dear Mohamad,
Thanks for your appreciation
Regards
ExcelDemy
Dear Minhajul,
You are most welcome.
Regards
ExcelDemy
Dear Sandeep Bhattacharjee,
You are most welcome and thanks for your appreciation.
Regards
ExcelDemy
Hello Sujay Jain,
You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the Top 100 MCQ of Excel section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear S Roy,
You are most welcome.
Regards
ExcelDemy
Hi Kazem,
You are welcome.
Regards
ExcelDemy
Dear Lana,
You are most welcome.
Regards
ExcelDemy
Dear Seamus Madden,
Thanks for your appreciation.
Regards
ExcelDemy
Hi Ndonwi,
Thanks
Dera Merc,
You are most welcome.
Regards
ExcelDemy
Dear Joanna,
You are most welcome.
Regards
ExcelDemy
Dear Richard,
You are most welcome.
Regards
ExcelDemy
Dear Andrei,
These functions are available in WPS office.
Regards
ExcelDemy
Dear Kapil,
You are most welcome.
Regards
ExcelDemy
Dear Tommy Fuifui,
You are most welcome.
Regards
ExcelDemy
Dear Excel Nob,
You are most welcome.
Regards
ExcelDemy
Dear Car,
You are most welcome.
Regards
ExcelDemy
Dear Jamie,
You are most welcome.
Regards
ExcelDemy
Dear Anitelleth,
You are most welcome.
Regards
ExcelDemy
Dear Anitelleth,
You are most welcome.
Regards
ExcelDemy
Dear Kay,
You are welcome.
Regards
ExcelDemy
Dear Pirooz Rahimi,
You are most welcome and thanks for your appreciation.
Regards
ExcelDemy
Dear Abel,
Thanks for your appreciation. You are most welcome.
Regards
ExcelDemy
Dear Kh Paydar,
You are most welcome.
Regards
ExcelDemy
Dear Joris,
You are most welcome. We are glad to hear that.
Regards
ExcelDemy
Dear Raja,
You are most welcome.
Regards
ExcelDemy
Dear Kapil,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Polepeddi Sasidhar,
We are glad to hear that.
Regards
ExcelDemy
Hello Silpa,
You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.
Best Regards
ExcelDemy
Dear Jidith Savidge,
You are most welcome.
Regards
ExcelDemy
Dear Ajij Nadaf,
We will love to give you suggestions. kindly share your problem.
Regards
ExcelDemy
Good day, Daniel,
The issue you’re having might be because your workbook’s data range differs from the data range specified in our code.
Change the data range according to your worksheet.
This might be the solution to your issue. I’d appreciate it if you could send me the worksheet you’re working on so that I can better understand your issue and give you an exact solution.
Regards
Sakibul Hasan Nahid | ExcelDemy Team
Hey Philip,
Thanks for your response. You can use the SORT and FILTER functions along with the LARGE function to solve your problem.
Here’s the practice sheet we used. You can check it out for a better understanding.
SORT-FILTER.xlsx
You can also check out this article for more detailed explanations.
https://www.exceldemy.com/excel-top-10-list-with-duplicates/
Regards
Hassan Shuvo| ExcelDemy Team
Hello Chandan,
Thanks for commenting. If I’m not wrong, you want to match the dataset like the one below.
Select the entire dataset without the heading then go to conditional formatting >> New Rule
Then select “Use a formula to determine which cells to format.”
In the formula bar, enter the following formula:
=AND(A3<>B3,C3<>B3)
Press OK
Here, “A3” represents the cell containing the customer name, “B3” represents the cell containing the ID name, and “C3” represents the cell containing the real name. You can adjust the cell references based on your data.
Choose the formatting option that you want to use for the highlighted rows. For example, we took light green color here for highlighting.
The final outcome will look like the image below.
I hope this answer will help you to identify matched names. Please let us know if you have any other queries. Also, you can post your Excel-related problem in ExcelDemy Forum with images or Excel workbooks.
Regards
Mizbahul Abedin | ExcelDemy Team
Dear MD. KAMAL HOSSAIN,
To obtain your required format please follow the following simple steps:
From your Excel Workbook, press ALT + F11 to open Visual Basic Editor.
Insert a module.
Paste the following code:
Now, return to your worksheet. Type in the following formula in the cell where you require the output and press Enter key.
=NumberToWords(B5) & ” Taka Only”
Here, B5 indicates the reference of the cell where you have the input number.
I hope this solution will be sufficient for your requirements. Let us know your feedback.
Regards,
ExcelDemy
Dear Rich Saunders,
Query 1: The method 7 works just fine. If you write March in F4, you will get the values for that month as well.
Query 2: The formula is universal for any Excel version. If you write the formula in any cell the formula will get you the entire row value for the name you will write in the F4 cell. For example, if you write “Nathan” in F4 cell and paste the formula in the A1 cell then the formula will write the values of the entire row( B8:D8) in the A1:A3 range.
Yes, we should have mentioned the Ctrl+Shift+Enter in the article. We will make sure of that in the next articles. As we used Microsoft 365 so it works by pressing Enter. We are sorry for that.
Regards
ExcelDemy
Dear Tudor,
Hope you are doing well. Answer of your questions are given below with explanation.
1. How can I change the month and day from English to Romanian?
Select the cell with month and date, cell C7 in our case.
Right-click with the mouse and select Format Cells.
In the Format Cells window, select Romanian (Moldova) under the Locale menu.
Then, select any type under the Type menu and click the OK button.
The month and date are changed into Romanian from English. Do the same process for cell E7.
2. If an employee works on Saturday and/or Sunday, how can I collect those weekend hours separately, in a cell?
Let’s say the first employee works on Saturday and Sunday for 5 and 6 hours respectively. He works on 4 weekends which you can see in the picture. To sum these values we’ll use the SUMIFS function.
Apply the formula in any cell where you want the weekend hours, let’s say cell AM11-
=SUMIFS($F$11:$AJ$11,$F$11:$AJ$11,"<>P",$F$11:$AJ$11,"<>A")
After pressing Enter you’ll get the total weekend hours. You can use the Fill Handle tool to apply this formula to other employees.
Dear Aspen,
You are most welcome.
Regards
ExcelDemy
Thanks for your suggestions.
Dear Victor,
You are most welcome.
Regards
ExcelDemy
Dear Elizabeth,
You are most welcome. We are so glad that our article fulfilled your need.
Regards
ExcelDemy
Dear Anjli Gupta,
Answers are given in the Solution sheet of Excel File which is in Download Practice Workbook section.

Regards
ExcelDemy
Dear HG,
You are most welcome.
Regards
ExcelDemy
Dear Seaunders,
Thanks for your appreciation. It means a lot to us.
Regards
ExcelDemy
Dear Gunawan,
Thanks for your suggestions. We updated the article. You can check it now.
Regards
ExcelDemy
Hi Fake Hidden,
Thanks for your suggestions. We updated our article so that it fulfills the need of all types of readers. You may check our article now and let us know any kinds of suggestions.
Regards
ExcelDemy
Dear Rafi,
Thanks for your appreciation.
Regards
ExcelDemy
Dear Elly,
Thanks for your appreciation. We re-explained our formulas to make them more understandable. If you find any difficulty now, let us know in the comment section below.
Regards
ExcelDemy
Dear Rashmi,
You are most welcome.
Regards
ExcelDemy
Dear Jay Dee,
That’s good to hear. We are interested to know more from you.
Regards
ExcelDemy
Dear Silver,
You are most welcome.
Regards
ExcelDemy
Dear William B,
You are most welcome.
Regards
ExcelDemy
Dear Eugen Safta,
You are most welcome.
Regards
Shamima Sultana | ExcelDemy
Dear Radu,
Thanks for your suggestion and we appreciate it. We updated the cell range.
Dear Sanket,
Thanks for your appreciation.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Yar Zar Htun,
You are most welcome. We are glad that through ExcelDemy you are improving your skill.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Vivasvan,
You are most welcome. It’s great to know that our article helped you to complete your project.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Bo Thibaut,
We are willing to do any Excel-related projects. Kindly share your requirements through this Email: [email protected]
Regards
Shamima Sultana
Project Manager | ExcelDemy
Hi Robert Bakinam,
Here, you will get the full copy in pdf Marking Result Sheet.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear German,
You are most welcome. To get solutions with detailed explanations, follow ExcelDemy.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Kirsten Wheeler,
Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear NancyM,
Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear CJvW,
Thanks for your appreciation. To get more helpful content be with ExcelDemy.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Geogre,
Thanks for your kind attention and suggestion. We updated it.
Dear Michael Gamal Aziz,
You are most welcome.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Glenn,
We are glad to hear that. ExcelDemy is trying hard to give you quality content.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Uday Kumar,
We are working on your problem. We will appreciate you to post your problem in our ExcelDemy Forum.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Ramandeep Kaur,
Thanks for your appreciation. Sooner we will make another exercise based on Basic and Advanced Formulas.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Datla Srinivas,
We are working on your requirements. We hope we will come back to you with your expected solutions.
Regards
Shamima Sultana
Project Manager | ExcelDemy
Dear Mody,
Thanks for your appreciation.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Hello Joanie,
You are most welcome.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Map,
Thanks for your appreciation and suggestion. Sooner we will write an article regarding this topic.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Ven Upekkha,
Thanks for your appreciation.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Rajesh,
You are welcome.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear umit,
Thanks for your appreciation it means a lot to us.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Hello Zuri,
Thanks for your suggestion.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Carl,
Thanks for your appreciation. ExcelDemy is glad to help you.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Sandra Aldridge,
Thanks for your appreciation it means a lot to us. ExcelDemy is glad to help you.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Micah,
Thanks for your kind words. ExcelDemy is dedicated to provide solutions to help you.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Mukibul Hasan,
Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Shanmuga Raja V S,
Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
Shamima Sultana | Project Manager | ExcelDemy
Dear Adam,
Thanks for your appreciation.
Shamima | Project Manager | ExcelDemy
Dear Zidane,
Thanks for your appreciation.
Shamima | Project Manager | ExcelDemy
Dear Kayla,
Thanks for your appreciation and we are glad that our Dataset Template helped you.
Regards
Shamima | Project Manager | ExcelDemy
Hello Uday Kumar,
Kindly check the reply to your previous comment. We have given you a non-macro solution.
Dear Forte,
Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.
Regards
Shamima | Project Manager | ExcelDemy
Dear Gilson,
Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.
Regards
Shamima | Project Manager | ExcelDemy
Dear Gerry Conroy,
You are most welcome.
Regards
Shamima | Project Manager | ExcelDemy
Dear Syed Anwar Hussain,
Thanks for your appreciation.
Regards
Shamima | Project Manager | ExcelDemy
Hello, Xzavier!
For better understanding, we updated the article. Kindly check it now it would be helpful.
Regards
ExcelDemy
Hello, An!
You are most welcome. To get helpful content follow ExcelDemy.
Regards
ExcelDemy
Hello, James!
Your appreciation means a lot to us. To have a more wonderful experience follow ExcelDemy.
Regards
ExcelDemy
Hi Rassulsson!
Thanks for your appreciation.
Regards
ExcelDemy
Thanks, Michael, for your query. From your comment, it seems that you want to permanently assign the replacing dataset (denoted by Reprng in the code) instead of taking them in a prompted input box. You can do that by following the steps below.
1. First, set a Name to the range that contains the Find & Replace with columns (In this case E5:F6). To do that, select the range and type a suitable name on the Name Box. Suppose you give the name “Find_Replace_Array”
2. Now, open a new module and write the given code of method 1.
3. Then, on the code, replace the line :
Set Reprng = Application.InputBox(“Replace with: “, Title, Type:=8)
With the following line.
Set Reprng = Range(“Find_Replace_Array”)
Now, if you run the code, you will only need to select the range where you want to replace values and it will automatically replace the values for you. Here, you will not be required to manually input the address of Find_Replace_Array.
Hope it does the job for you. If you have any further queries, do let us know. Moreover, if your problem persists, you can post your problem in our Exceldemy Forum along with your Excel file.
Hello, Hamza!
Thanks for your appreciation. We are glad that our article helped you.
Regards
ExcelDemy
Hello, A!
If your file is protected by using Encrypt with Password feature then it won’t work. We mentioned it in the Things to Remember section.
Regards
ExcelDemy
Hello, Nabil sellami!
Thanks for your appreciation. To get more enjoyable articles stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, JeteMc!
Welcome, JeteMc. To get more helpful information stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Helen!
Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.
Regards
ExcelDemy
Hi, Irene!
Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.
Regards
ExcelDemy
Hi, Elton!
Thanks for your appreciation. We will try to launch pdf files.
Regards
ExcelDemy
Hello, Muhammad Luqman!
You can download it from Download Excel Formulas Cheat Sheet PDF section.
Regards
ExcelDemy
Hi, Bosco!
Thanks for your appreciation. To get more informative contents stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Joe Smith!
The 64-bit version of Excel is not compatible with 32-bit active x controls. To know more about it you can visit this site
Regards
ExcelDemy
Hello, Aleksandra!
Thanks for your appreciation.
Regards
ExcelDemy
Hello, Bennie!
Thanks for your appreciation.
Regards
ExcelDemy
Hello, Harry!
You can download the copy from Download Sample Workbook
Regards
ExcelDemy
Hello, Emil Lazar!
Thanks for your appreciation. Stay in touch with ExcelDemy to get more useful articles.
Regards
ExcelDemy
Hi Abishek Sharma!
If you want the Excel file then you can download it from the Download Practice Workbook section. Or you need other assistance you can comment or send us mail at [email protected]
Hello, Nastaran!
Thanks for your appreciation. We are glad that our post helped you.
Regards
ExcelDemy
Hello, Ruben!
It’s glad to know that our content is helpful to you. To know more about Excel stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Tanael Wawe!
You are welcome. Stay in touch with ExcelDemy to get more helpful content.
Regards
ExcelDemy
Hello, Tanael Wawe!
Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.
Regards
ExcelDemy
Hello, Dan!
Thanks for your appreciation. It means a lot.
Regards
ExcelDemy
Hello, Ahnaf!
You are most welcome. stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Aleem!
Thanks for your appreciation. stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Mohan!
Thanks for your appreciation. Stay in touch with ExcelDemy for more helpful content.
Regards
ExcelDemy
Hello, Many!
You are most welcome. To get more helpful content with explanations stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, ExcelAmateur!
Thanks for your appreciation. To get more helpful content with explanations stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Mubashir!
Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.
Regards
ExcelDemy
Glad to hear that.
Regards
ExcelDemy
Thanks for your appreciation.
Regards
ExcelDemy
Hello!
Thanks for your appreciation.
Regards
ExcelDemy
Hello, Andy W!
Thanks for your appreciation.
Regards
ExcelDemy
Hi, Dhaval!
Thanks for your appreciation.
Regards
ExcelDemy
Hello, Pankaj!
We are glad to know that it worked for you. To get more useful content stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Suzette!
Thanks for your appreciation. We will try to use fonts that will be easier to read for old eyes.
Regards
ExcelDemy
Hello, Eric!
Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Instast!
Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.
Regards
ExcelDemy
Greetings ASHISH PANT,
I appreciate you asking this question. We use the Microsoft Office 365 version here. In order to resolve your problem, you need to open the Excel workbook in Microsoft Office 365 version.
Regards
ExcelDemy
Hello, Andre!
Thanks for your appreciation. To get more helpful posts stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Michelet!
Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Im!
Hope you are doing well. Thanks for your appreciation.
Regards
ExcelDemy
Hello, Leslie!
Hope you are doing well. Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, Aston!
Hope you are doing well. To show your data labels in millions kindly follow this article Millions in Data Labels
Regards
ExcelDemy
Hello, Chan!
Hope you are doing well. Glad to know that our content is useful for you.
Regards
ExcelDemy
Hello, Kim!
Thanks for your appreciation. For more useful content visit our site ExcelDemy.
Regards
ExcelDemy
Hello, Suki Nasoordeen!
Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello Gerald,
Do you need to know the conversion from Excel to PDF? Right? Because the original bank statement was in PDF format. So, here you can follow the steps below to convert your Excel file back to PDF file.
Firstly, you need to open your Excel file.
Secondly, click the File button at the top-left corner of the Excel file.
Thirdly, go to Save As and click it.
Fourthly, choose PDF from the Save option at the top-right corner by clicking the drop-down button.
Finally, choose a particular location to keep it by selecting Browse button.
Thanks
Regards
ExcelDemy
Hello, Chole Faulkner!
Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
ExcelDemy
Hello, SS!
Hope you are doing well. We are very sorry that you are facing some troubles with advertising. But will try our best to give you a nicer experience.
Regards
ExcelDemy
Hi Zidane
Hope you are doing well. Thanks for your appreciation.
Regards
ExcelDemy
Hi Peter
Thanks for your appreciation.
Regards
ExcelDemy
Hi Mohammed Hassen,
Thank you so much.
Thanks
Regards
ExcelDemy
Hi N,
Thanks for your appreciation. Please visit our site for more excel-related problems.
Thanks
Regards
ExcelDemy
Hi Bernadeth,
Thanks for your appreciation. To get more useful content kindly visit our site.
Thanks
Regards
ExcelDemy
Hi GIRIDAR N,
Thanks for your appreciation and we are glad to help you. For any types of Excel-related problems kindly reach out to us.
Regards
ExcelDemy
Hello Marian,
There are some unwanted issues that may arise while dealing with the VBA code. In that case, you need to utilize the following code.
Here, the Application path and pdf path need to be defined accurately. Then, when you run the code, you will find the copied items in the clipboard.
Then, click on Paste all to extract values.
Thanks
Author, ExcelDemy
Hi Exceler,
Here, I tried the first method for 50 sets of data and it worked but you have to change the cell references based on your dataset. For your better understanding, I am attaching the images along with the formula.
=INDEX($D$5:$D$30,MATCH(1,MMULT(--($B$5:$C$30=F5),TRANSPOSE(COLUMN($B$5:$C$30)^0)),0))
The images of datasets
Here, I used the formula for the entire dataset. I changed the references based on my dataset.
Output for 50 values:
Note: If your dataset is very large kindly send us your dataset
Thanks
Shamima Sultana
Hi Tom Lynham
Hope you are doing well. Here, I updated the article which implies the title and the explanation.
By following above explained methods it is possible to print colorful gridlines but you must use a color printer.
If this update doesn’t help you or you have further queries kindly let us know.
Thanks
Shamima Sultana
Hello Mark,
We uploaded the Excel files again, you can check these files also. If you find any difficulty opening the file let us know.
Thanks
Hello Mark,
Hope you are doing well.
Whenever I try to download this workbook it works fine without a password. To be reassured a couple of my teammates also downloaded this file they also didn’t face any difficulty.
As I haven’t used any password for this worksheet. I really want to know what caused such issues while you downloaded the file.
Here, I will show you what it looks like when I download the file again.
After downloading the file Excel shows a warning message. You have to click on Enable Editing.
Later, the downloaded file will be available to use or you can make any changes you want.
N.B. If this solution doesn’t work for you. Kindly sent me the screenshots of the problem.
Thank you.
Regards
Shamima Sultana
Hi Froggy,
Hope you are doing well. Thanks for reaching out to us with your issue.
As you intend to apply the above code to a workbook with multiple sheets so you need to add some extra lines in your code to define all available worksheets or selected worksheets.
Here, I will give you two solution
1. For selected sheets
2. For all the available sheets in a workbook
1. If you want to apply the same code in some selected sheets then use the code given below where I declared sheets names by using an Array.
Option Explicit
Sub AddSpaceBetweenRows()
Dim all_sheets As Worksheet
Dim rng As Range
Dim i As Long
Dim all As Variant
Set all = sheets(Array(“VBA1”, “VBA2”))
For Each all_sheets In all
all_sheets.Select
Set rng = Range(“B5:E9”)
For i = rng.Rows.Count To 2 Step -1
rng.Rows(i).EntireRow.Insert
Next i
Next
End Sub
2. To loop through all the available sheets of your workbook you will need to use the code given below where I declared all_sheets and used an extra For Loop.
For your better understanding, I’m providing the modified code here,
Option Explicit
Sub AddSpaceBetweenRows()
Dim all_sheets As Worksheet
Dim rng As Range
Dim i As Long
For Each all_sheets In Worksheets
all_sheets.Select
Set rng = Range(“B5:E9”)
For i = rng.Rows.Count To 2 Step -1
rng.Rows(i).EntireRow.Insert
Next i
Next
End Sub
Note: Based on your Excel file you will need to change the sheet name and the cell range selection.
For further queries comment down below.
Hello Naveed,
Hope you are doing well. Kindly send me the details of your problem including the Excel file via my Gmail account [email protected]
Thank you
Hi Helen,
I’m glad that our article helped you. For any types of Excel related problems kindly check out our ExcelDemy site.
Thanks
Shamima
Hello Michelle,
Hope you are doing well. If you need to run the macro after the first use it will create new sheets with the updates you made on your dataset.
It won’t automatically update the workbooks created previously (Book1, Book2, and Book3) rather it will create Book4, Book5, and Book6 with the updated dataset.
Thanks
Shamima Sultana
Hi A,
Thanks for your appreciation.
Hi Sikander,
Hope you are doing well.
To get the DateValue for February, click on the drop-down option of Month and then select February.
Then you will get the DateValue and the rest will be updated automatically.
Note: If you want to type the month name in that cell you have to be careful with the spelling of the month name.
Thanks
Regards
Shamima Sultana
Hi Deon Bailey,
Hope you are doing well. Thanks for reaching out to me with your issue.
As you didn’t share your Excel file that’s why it is hard to understand your sheet name and where is the problem occurring.
But you need not to worry, I’m giving you a possible solution so that you can add data to your selected sheet to the last row.
The reason for overwriting the added data is your code wasn’t finding the last row it was showing 1 as the last row number.
Here, I added data according to my dataset I used in this article. I commented out your code and added some required lines.
Sub Insert_Value_from_LastRow()
‘TargetSheet = Cmb_Months.Value
‘If TargetSheet = “” Then
‘Exit Sub
‘End If
Dim targetSheet As Worksheet
Set targetSheet = ThisWorkbook.Worksheets(“Dataset”)
targetSheet.Activate
‘lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
LastRow = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
MsgBox LastRow
‘ActiveSheet.Cells(LastRow + 6, 2).Value = Cmb_Area.Value
‘ActiveSheet.Cells(LastRow + 6, 3).Value = Txt_Ln_Manager.Value
‘ActiveSheet.Cells(LastRow + 6, 4).Value = Txt_FName.Value
‘ActiveSheet.Cells(LastRow + 6, 5).Value = Txt_Surname.Value
‘ActiveSheet.Cells(LastRow + 6, 6).Value = Txt_S_Number.Value
ActiveSheet.Cells(LastRow + 3, 2).Value = “Rachel Ross”
ActiveSheet.Cells(LastRow + 3, 3).Value = “Germany”
ActiveSheet.Cells(LastRow + 3, 4).Value = “laptop”
ActiveSheet.Cells(LastRow + 3, 5).Value = 4567
End Sub
Note: Whenever you want to insert or add data after a particular row it is better to see the last row number by using MsgBox. It will help you to understand why data is overlapping.
I also added the images.
For further queries, you can send me your Excel file.
Thanks
Shamima Sultana