The discussions
Authentication problem when installing outlook on phone.
Good day. I please need assistance with the installation of Microsoft Outlook on my Android phone. (Samsung A72). It keeps on giving a authentication ...
Not allow paste, but allow vba code to paste
Hello all, I've run into a situation where the users of my workbook paste a row into the workbook, and that unfortunately circumvents my data valida...
Fomula for look up value
Dear colleagues Please could you help me to resolve this issue as per the image bellow:
How can i get product key for ms office 2019
Hello, Where can I find the product key for MS OFFICE 2019? Thankyou. Edith
Simple date subtraction excel
Solved-It seems soo simple, yet I haven't been able to find the solution. I need to display a date that is five years in the past from today. -I tried a co...
Splitting multiple choice
Dear Colleagues ; As you can see in the image below, I've already inserted the formulas that allow me to separate multiple responses from one cell int...
Ms project professional 2021,activation key
Solved/ClosedI need the activation key for Microsoft Project Professional 2021 i hav successfully downloaded the aps
How to get password
where do i get password
Help with array formula
OK, so I have posted here a few times and everyone is very helpful and knowledgeable so I'll start off with a thank you in advance. What I'm doing is...
Concanating text using vlookup forumula
Hi, Anybody help me to suggest a formula . Attached Sample file link Below: https://we.tl/t-gQD0tFH6Rh I am looking for formula at B11 .. it give...
Power query editor data source settings multiple users
-In power query editor, how can I make the file path dynamic? Multiple users need to be able to run the power query. But each file path will be differ...
Add date function to this code
SolvedHello all, I am looking to add a date function to cell J (or whatever column/cell I need it to be) after this code performs its actions. Currently ...
Where can i get the license for doctranslate software
Where can I get the license for doc translate software? Thank you.
New version v-tools available?
Solvedv2016_183 was great, however is there a version for Access2021-64bits available?
Download odbc drivers 64-bit for access
SolvedHi, I need to download 64-bit ODBC drivers for Access Thanks
Double condition formula based on drop down selection
Hi All, I have an excel file with sheet names : Primary Data sheet, Ground floor, First Floor and readings. I need this file to capture printer usage...
How can i start a spreadsheet at windows login.
SolvedHello, How can i start a spreadsheet at Windows login. The normal simple way does not work. Thank you, Mondriaan
Adding buttons to an excel spreadsheet.
SolvedDear CCM Team, How do you add a button on a particular cell in an excel spreadsheet to turn it on and off. Example: If I want to add a column of nu...
Pop up message in excel (like outlook agenda)
SolvedHello, I have a big file in Excel with heaps of information about my customers. One of the coloms is telling me when I need to send them a letter....
Automatically send emails from excel based on cell date
Hi All, Please help me anybody. I am suffering with sending email from excel automatically ..Please see attached screen shot for your reference : ...
Monthly production report -automatic transfer of data
SolvedDear All, I am looking for a solution to generate monthly production analysis report of an operator for his daily production. Attached sample sheet...
Copy data from one excel sheet to another: automatically
Dear All, Anybody help me to transfer the data from main database sheet to other sheets based on sheet name condition. i.e., The data from B6 to Q6 f...
If cell z2 contains a date, show 'yes' otherwise show no
Hello, I am trying to get my sheet to show a Yes Field when a date is entered. But a no field at any other input, weather thats 'n/a' or blank or any...
Powerpoint problem
Hello, I can not save anything onto my powerpoints , I get the same window telling me either that it is a read only ( which I have changed each tim...
Print 1 document in a5 size - change doc size to a5
SolvedHi, How do I get an A5 document for 1 project only - greetings card
Fill adjacent cell with number from text answer
SolvedHello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down ...
Create folder in desktop with vba, if exist, ignore
SolvedHello, How to create folder in desktop with vba whenever the excel book is opened, if exist, ignore. Message if create new folder, silent if th...
Dependent (cascading) drop down list in excel
SolvedDear All, Please help me on the below . I have a data validation drop down list with unique values in cell G2. These values are job numbers from C...
Combine sheet in master spreadsheet with auto update
SolvedHello, I have 24 sheets in the same Excel document with identical headers I`d like to combine in the master spreadsheet the way if any data is insert...
Best pdf to png options?
Hello, We are looking for a pdf to png converter and have found the following tools online and we are wondering if anyone has used these and if so wh...
Copy data from one excel sheet to another: automatically
SolvedDear all, Anybody can help me please. I have MAIN DATABASE ( sheet 1) of column names : Serial No, Service type, Job No, Date, Customer name, desc...
How do i make all rows the default height in excel?
SolvedHello, How do I make all rows the default height in Excel?
I have an external hdd that's a 500gb
My external has information that I dont want to lose It keeps on saying "windows can't access the disk" or "A device which doesn't exist was specifi...
How do i change the backgroud of a cell or a whole section?
Hello, I have a question. How do I change the backgroud of a cell or a whole section? I want to differentiate one set of data from anoter set based...
How do i set the height of rows in excel all at once ?
Hello, How do I set the height of rows in Excel all at once instead of doing them one click at a time by clicking and dragging and dropping the indic...
Excel macro to duplicate info based on value in another cell
I am creating a work book that has a range of cells (C6:E34) that are considered one "Location", and another cell (D5) to input the number of location...
Copy and paste to internet creating whitespace problem
SolvedHello, I created a body of text in Open Office Writer and tried to post it as a question on the website Less Wrong. A moderator rejected it for, as w...
Multiple sheets to one master sheet update
SolvedHello, We are a team of 8 who updates a single excel work sheet, and because of this, there is always information missing or overwritten by others et...
How can i fix hotmail if it keeps freezing or crashing?
SolvedI am using Hotmail and now my Hotmail keeps freezing or crashing. Please suggest reasons and solutions for it.
How not to show false in the following example.
Hello, I wish the formula to return a blank cell if there a blank cells in the formula. =IF(C27="BUY",((D30-D27)*10000),IF(C27="SELL",((D27-D30)*1000...
How can i format multiple presentations automatically?
SolvedHello, I have a lot of presentation and I want to format every ppt to the same font and rate automatically. How can I to do it?
Drop down
Hello, I have a workbook with one main sheet and lots of rows to be filled. There is one column with a drop down with 3 selection. How can I copy ...
Export video - no audio file
Hello, I want to generate a video from a pps with music/media file and it only takes it without that (media) file. It is a wave file and its size is ...
Create multiple workbooks with template at once
Hello, I'm being tasked with copying a single workbook with a special layout in it and copying it about 90 times with the file name corresponding to a...
Adding last week position to a weekly record survey
Hello, I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in E...
How to pull data from column based on multiple criteria?
Hi Expert, I'd like to combine a column value in Mainsheet, where the column values are pulled from Sheets 1 and 2 of the same Excel file using VBA c...
