The discussions
Vlookup with condidion
HI Team Pls help to make a vlookup with condition as explained below. Data reference as below Column A Column B Colum C X1 ...
Problem search data by selected combobox & datepicker tools
Solvedhello i no know why this doesn't work this code and there is no error it should when i select from combo box it should show d...
Problems with videos in powerpoint
Hello, When I use a powerpoint when teaching a class VIA Zoom the videos embedded in it are choppy and studder even when I reduce the size of the...
Using vba code to extract data from a website
Hello, I have little to no programming knowledge or how to work with VBA. I was wondering if there was a way to write a VBA code to extract data...
How can i unmerge cells, delete empty col and rows, relocate cells and combine?
SolvedHi dears, first of all, I have to thank every one who read this message and he try to help me. its a complicated matter to me. Actually, I re...
Is it pointless?
SolvedWhen I am writing an important document, I always upload a copy to Google Drive every half an hour because I am afraid of loosing it, although everyth...
How to unlock a password protected word document
Solved/ClosedHow to Unlock A Password Protected Word Document
My pdf documents open in words and there is no option to open the document with
Hello, My pdf documents open in words and there is no option to open the document with other format.
Why does pdf document automatically converts to words documents
why does pdf document automatically converts to words documents?
Error 800ccc0e
Periodically (like, after an update or just not logging on for a while), Outlook loses the ability to connect to yahoo.com for email. This is after i...
Count cells containing text per row
SolvedHello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time t...
How to hide/undie picture based on a cell a1=1/0?
SolvedHello, can anyone help me how to hide/unhide picture 1? if A1=0 then hide picture 1 if A10 then show picture1 thanks
Transpose data from vertical to horizontal
SolvedHello, this the code doesn't work i would transpose as what in existed in picture the result from e: h i hope somebody ...
Copying formula for multiple worksheets
SolvedI use ASAP utilities to insert multiple worksheets using a template. I'd like to create a formula that automatically inserts sequencial numbers. Ex:...
Adjusting code divide data of table into tables in each sheet
Solvedhi, my code really works but the problem when i add a new data it doesn't copy to the multiple sheets because the first time ...
How can i blink data in textbox on userform based on condition
Solvedhello i got this code from the internet about blinking in textbox by command button but i would do this without command button it's directly ...
Re-edit the powerpoint video over 3 times
Hi there Please refer to the video URL below. https://streamable.com/s0wzyh I think that the video above has been re-edited about three times ...
Excel - how to count numbers in brackets
SolvedHello, I would like to know how to count the number of elements(digits) in the brackets after a word. exemple Bimbia(1,2,3,6,7,8). in the Brackets...
Microsoft word file convertor
Hello, after downloading compatibility pack what should i do?
Fixing sum an subtract among sheets
Solvedhi, i search so much in the internet to fix my code to work but no answering so far i have 6 sheets it suppose copying data from a2...
Google slides animation by paragraph
Hi there Please see the video URL below. https://d.kuku.lu/f6795b206d If the paragraph is unchecked, the 3 words will appear all at once. If ...
Gestion des creances clients
Salut ! C'est ma toute première fois de poster sur ce forum et vu la performance des membres de celui-ci je sais que j'aurai une réponse à ma question...
Corrupt files
SolvedHello, I have been using a document for 2 years now, and a couple of days ago, I had gotten my entire laptop updated to Windows 8.1. Since then, all...
Best mbox conversion software
SolvedLast few days I have suffered to the conversion of MBOX files. Can anyone suggest the best way of MBOX conversion? Which is easier and Saves my all MB...
Generating report sheets
I was developing Excel program for students' results calculation . How do I generate report sheet for all the students individually????? Thanks in...
Conditioning one calc cell on another
SolvedHello, does anyone know a way to make it so that a cell in Open Office Calc cannot be left empty, or at least that there will be an error message if ...
Vba function code to highlight odd and even numbers
SolvedHello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I would ...
Help: need formula to find missing text comparing 2 cells
SolvedHello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text difference...
Reversing background colour and text colouring?
A friend sent me a couple of slides to use in my notes. Unfortunately, the slides have white lettering on a black background. I would like to know i...
Saved photos in paint - getting them back to original size
Hello, I have saved all of my photos on a Seagate portable hard drive. When I open these photos they’re saved as an img in Paint and they are zoom...
Call barring cancel code
Tell me code Gfive DON keypad mobile for call barring cancel
About automatic appearance of my password in outlook
When I want to enter to my outlook emais, my password appears automatically. I prefer, as it was before, me to put each time that I want to enter in...
Download office 2019
Need help downloading Microsoft Office 2019* Bonjour à toutes et à tous, je viens de passer 30min à essayer de trouver un lien sur le site de Micro...
Vba: color cells in table based on multiple condition
Solvedhello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok let'...
How to specify macro for current active sheet
SolvedHello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selecte...
How do i scan and then search a document
SolvedI would like to scan the table of contents from a large number of magazines. What format should I use to save this document? What software will allo...
Excel make cell flash red
SolvedHello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same spreadsheet li...
Inserted row should paste in 7times in next sheet based on the date
SolvedHello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file an...
Vba to reference newest sheet
SolvedHello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre-det...
Macro to select multiple columns by columns specific headings to delete dupes
SolvedHello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific colu...
Date counter and then stop when new date is entered
I am attempting to calculate the time between B9 and Z9. and the same with D9 and Z9. the person who created the file is only calculating from "Today'...
Macro to compare 2 sheets and copy differences
SolvedHello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone show...
Combine cell text
SolvedHi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2- 10 (Would be...
Vba error -2147417848 (80010108) automation error
So I am trying to make a spreadsheet that tracks our usage by diameter and individual serial number. I perform some basic checks using conditional for...
Copying data from one excel sheet to another.
Solved/ClosedHello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the da...
Copy rows from excel to another sheet once a date in a specific field is filled
SolvedI have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy automati...
Cells copying and pasting in a empty cell of another sheet
SolvedHello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...
I cant send or recieve emails from my new outlook account. urgent help needed
I just set up a new outlook email account but Im unable to send or recieve emails. Im desparate as Im applying for jobs and am waiting for replies.......
Punching time
SolvedHi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...
Yahoomail ads
SolvedIf I follow these instructions, will I still see the yahoo ads and "news"? I was planning to open an Outlook account and just forward Yahoomail to it...