hello I have 100 worksheets names 1 to 100 having same format having “YES” or “NO” in B2 of each worksheet I would like to count no of YES in B2 of each sheet in summary sheet. I m using ...
Computing.net: Question & Answers Forum Latest Questions
Hi folks, I need to print Mac Excel sheet to PDF quite often, here are the VBA code used to be working fine with my Office 2011, but it does’t work in Office 2016/2019, the macro is to print sheet ...
I have a quite extensive xlsx worksheet containing medical providers and details about them, fx. Column A: Last Names Column B: First Names Column C: Provider Type Column D-H : Availablity **Column I: Speciality** I am only interested in searching the ...
I need to search 10 words in 10 excel files at once. Can anyone give me a macro for doing this? For example i want to search london,doha,delhi in 10-15 files in a folder at once. Is this possible with ...
When I print a specific word doc (using courier font), certain words are greyed out on the print job but not on the word doc itself. Any ideas or solutions? Thanks Also, if i copy and paste to note pad and then ...
Is there a way to dynamically ‘force’ a cell colour (eg. A1) to be the same as another cell’s colour (eg. B1) [where the source cell’s colour (B1) could be anything and might change from time to time]? Understand I ...
Hi I am working in Excel 2007 but am saving the file as Excel 97-2003 as I am doing it for a friend who only has 2003. I have a large multisheet workbook which records staff names and dates when ...
Some of my cells will not respond when I apply centering, either with the centering icon or the Format Cells; Alignment; Horizontal Center. Other cells in the same sheet act normally.
Hey Everyone, Well, I just downloaded Microsoft Office Professional a few days ago. So, I just opened up Word for the first time because I needed to create a chart for a school thing. My question is, how do I create ...
Hello, I have an excel document we use to track the “end” dates of an internet service we offer. What I am trying to do is automate the expiration date of the sheets in excel. When the expiration date for ...