The discussions
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
Data comparison in excel
Hello, I have two data like in one sheet Names are started with First name and in other Sheet data is started with the Last name.So how can i compar...
Vba template
Hello, Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done da...
Macro which will determine a new scanned file
Hello, I am trying to organize my records and here is what it comes down to, I have 4 separate folders, in which I am planning to copy scanned fil...
Formula/ conditional formatting help please
Hello, I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need...
Use a macro to copy data from rows into destination range
Hello, I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file. then select next...
Copy two sheets data in new work book with two sheets.
Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...
How can i stop/remain from changing the value in the lapse days
Hello, I have a problem in excel, how can I stop/remain from changing the value in the Lapse days Column as the days changing, if i will type value...
How to download adobe acrobat reader?
where is my download ( adobe acrobat reader) in this site?
Excel macro - create multiple workbooks
Hello! I have a 4 tab workbook I need to create multiple copies of (one for each employee to use throughout the entire coming year). I have my Dat...
Formatting cell based on text in another sheet
Hello, For e.g, I have "numeric" in cell B11 on sheet 1 with formula. However, I want the font color to change based on the text value in cell B2 ...
Macro for copying group of cells and paste as row
Hi, I need some help i need a Macro Code to arrange certain cells and prepare it as a row. I export the file from SharePoint in Excel Format. ...
If function in excel error
SolvedHello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...
Auto populating sheets from data in main two sheets
Hello i have found VBA code from auto populating data from excel main sheet to new sheets for each record in main sheet column, i need code to crea...
Can i have any training to using excel?
I wish to learn how to use excel
Autopopulation of mutiple files from 1 master sheet
Hi All, Firstly many thanks to anyone who takes the time to read and try to help. It is greatly appreciated. I have 1 master sheet that I input dat...
He cell checks 3 different columns each in different tables
how would the formula look if possible, the cell checks 3 different columns each in different tables on different sheets, if the value is=< todays da...
Transfer data from main sheet to multiple sheets.
I have more then 5000 rows that contains each row have one person details with 15 different column(ex,name.contact no,address.etc), and i have to copy...
Product key of office 2010
SolvedI don't K now product key of office 2010 please send me this key Regards Pardeep Gur
Code works fine on 2010 but not 2016
Hello, My company is having an issue we just updated our excel from 2010 to 2016, we have user forms that open a form to enter data but after we sub...