The discussions
Files that were in docs have changed to e
Hello, Please help me I am so confused now,my file that was in docs had changed to E for internet and I don’t know how to get it back. Please h...
Compare values in two columns and return the value from third
Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column...
Transfer data from the master sheet to other sheets.
Hello, i am maintaining a master excel sheet of out tele callers in which they all enter their calling data. i want to get the data in different d...
Removing extra columns after the end of the month,
Hello, Be Happy, i want to ask you that my company's month starts from 23rd and ends on 22nd, so how the extra columns can be removed automatically...
Auto e-mail when cell displays "yes"
Good Day Could someone please assist me with my query? I do not have many experience with VBA Macro, and would appreciate a simple answer. I ha...
How to use conditional format based on text?
SolvedHello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "Fi...
Cut from one workbook to another workbook
Hello, from data specific cell value match then entire row cut and paste another workbook sheet in excel vba formual System Configuration: ...
Copy and convert data
SolvedHi, in advance I would like to thank everyone for reading my post and providing any assistance. I have an exported worksheet with 50 rows of data (30...
Input part numbers and description into selected spreadsheet
Hello, I am compiling a excel work sheet, so far I have created 'buttons' that take me to the correct spreadsheet sections I have created. What I need...
Creating a time frame
Dear excel gurus/geniuses, I'm new to excel (as in, new in discovering what a powerful software it is!!) I want to calculate approximate time (day?...
Autocorrect - is backup possible?
Can you back up AutoCorrect in Word 2010 or 2013? If so, how? I must reimage PC, so reinstall Word 2010 or 2013 inevitable. Do you lose autocorrec...
How to correct corrupted jpg and mp4 files?
ClosedHi all, Does anyone know of a good bit of kit that can mend corrupt .jpg and .mp4 files? I have a few that seem empty, but I know they did work onc...
Create a spreadsheet that captures data in sheet 1
Hi All, Hoping someone can help with a query. I want to create a spreadsheet that captures data in sheet 1 (name, company, notes etc) and populates...
Vba excel [all versions] - calendar control
RE: https://ccm.net/faq/36865-vba-excel-all-versions-calendar-control The article "VBA Excel [All versions] - Calendar Control" looks very promisi...
Vlookup, if? question assigning value to text options
SolvedHello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...
Data showing who pays a doesnt after manually input receipts
SolvedHello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...
Finding a cell and adding 1 to a cell in an adjacent column
I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to...
How to download openoffice?
how do I download openoffice
English version of frontpage express
SolvedHello, Hi how do I download MS FrontPage the English version. Im only getting the French version
Difficulty to open excel files
Good day! The problem is the following! When opening any Excel files (no matter what size and no matter of the mesh open or locally with a computer) t...
Making an mp4 from powerpoint
I have created a PowerPoint with Audio and Video that I am trying to convert to MP4. I have gone to "Export" and am working to create new timin...
Compare sheets and put missing rows into third sheet.
Hi to all the CCM members. I have a problem that I need assistance with and I would greatly appreciate it if a VB guru could help me with a script ...
Update one sheet excel sheet from the other
Hello, I was wondering if anyone could help , I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving s...
Product key for msoffice 2010
Hello, plz send me .installation key for msoffice2010
Outlook for mac not working
Hello, I use a MAC book Pro with outlook 16. An hour ago, it stopped working. Currently its working, but it doesn't open few of of my outlook mails....
Create new worksheets using date data
Hello, I've been asked to find a way to sort data comprised of visit dates in to worksheets (within the same workbook) by age. The dates range fro...
Automated filter, copy, paste... recommendations appreciated!
Hello, I am a self-taught rookie attempting to create a document that will distill necessary information on a contract and spec sheet without havi...
Compare 2 cells then use data in 3rd cell
hi there hope you can help me with this please i need to do the following for a stock vs sales management sheet if a1 = b1 then d1*c1 Lo...
Logging web data excel
I’m trying to log some data imported from the web. I’ve already managed to import the data as a table and set an auto refresh to every minute. What I...
If statement returning false
Hello, The following IF statement is returning false. Please let me know how to get it to return a value. Thank you =IF(D6
Macro to copy data to new workbooks based on condition
Hello, I have a workbook with data that looks something like this (except thousands of entries): Name Type Group Master John ...
Same sent message mail going continuosly every 5-10 min,
Hello, Dear We are facing problem in our Outlook 2007 , when we sent email through our outlook, same mail going continnues to same receiv...
Filter the data in excel through formula
SolvedHello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...
Highlight cell question
Hello, I am trying to find a way to use conditional formatting on an inventory spreadsheet that I am working on. I would like to highlight cell C3 ...
Help with formula calculating time on 24h shifts
Hello CCM community!, Here I am again with a question that's being bugging me for a while A while ago I created my own version of a work scheduler...
Insert rows on change of value in excel table
Solved/ClosedHello, I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular colum...
Importing a word document into powerpoint
Windows 10 & OFFICE/PowerPoint 2010 Hi, I am new to this forum. I teach children "Personality Development", and that includes General Knowledge....
Pdf attachment unreadable and opens with word
Solved/ClosedHello, ever since I tried to open a Memo.4ma attachment emailed to me, my pdf files open with Word and are unreadable...they apear in encoding format,...
Unable to share files in outlook
Hello, good day for everyone i have this issue for few weeks now. if im working on a new file, and i would like to share it via email(outlook), i...
Excel date formula doesn't work past the new year
Hello, I have a problem with a date formula in a spreadsheet that I would very much appreciate help with. It seems that the formula doesn't work p...
If formula with dates and rates - complex!
Hello, i'm trying to get a very complex IF formula with many dates and outcomes. if an employee's starting date is 18 Oct 2017 (cell A5), then ...
Api will it put an icon on my desktop
I think I downloaded API (that was what I intended to do.) Question is will it put an icon on my desktop. Or will I have to find it in the list of...
If function for multiple cells and options
Hi, I'm trying to use the IF function but even when I copy a formula, I can't seem to get the correct answer. I thought it might be because the cell w...
Consolidate different workbooks into a new one
Hi guys, I have 3 excel workbooks (A, B, C) with multiple worksheets. Each one of the workbook have 2 worksheets (1, 2) with the same columns and sam...
How to send an email automatically when values are met.
Hello, Let me start with that I'm a rookie when it comes to VBA programming. I'm attempting to set up a code that will send an email automatically...
How to retreive datas form one sheet to another sheet in excel
Hello, If having the datain one sheet per example A column and Values column data are entered ., in next sheet if i enter the A it has to show th...
Vba to populate multiple sheets from master
Hello, I have a spreadsheet that I use to track my customers bookings. I have multiple customers and multiple bookings. I would like to have my mas...
If function using a date range
I'm looking for a function that will assign a specific date or day of the month when another cell containing a date falls within a date range: If C...
Help with formula: if, variable, add time into a different cell
Hello, I found this website after bumping my head with the keyboard trying to find a solution to a question I have. I am trying to create a spreadshe...
How to convert numbers into words in excel?
Hi, How to link or create formula in converting figures to amount in words? Thanks
