The discussions

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...

2 replies Last reply on 26 Jan 2018 by
jtliapp

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...

4 replies Last reply on 26 Jan 2018 by
ac3mark

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...

3 replies Last reply on 26 Jan 2018 by
MuhammadFarooque

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...

1 reply Last reply on 25 Jan 2018 by
ac3mark

How to use conditional format based on text?

 Solved

Hello, 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...

26 replies Last reply on 24 Jan 2018 by
Mooseman

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: ...

1 reply Last reply on 24 Jan 2018 by
ac3mark

Copy and convert data

 Solved

Hi, 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...

29 replies Last reply on 23 Jan 2018 by
vcoolio

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...

3 replies Last reply on 22 Jan 2018 by
vcoolio

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?...

1 reply Last reply on 22 Jan 2018 by
ac3mark

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...

3 replies Last reply on 20 Jan 2018 by
Ambucias

How to correct corrupted jpg and mp4 files?

 Closed

Hi 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...

Last reply on 19 Jan 2018 by
BrianGreen

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...

1 reply Last reply on 18 Jan 2018 by
ac3mark

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...

1 reply Last reply on 18 Jan 2018 by
Ambucias

Vlookup, if? question assigning value to text options

 Solved

Hello, 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...

2 replies Last reply on 17 Jan 2018 by
Soupies

Data showing who pays a doesnt after manually input receipts

 Solved

Hello, 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 ...

5 replies Last reply on 17 Jan 2018 by
Mazzaropi

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...

1 reply Last reply on 15 Jan 2018 by
ac3mark

How to download openoffice?

how do I download openoffice

1 reply Last reply on 15 Jan 2018 by
xpcman

English version of frontpage express

 Solved

Hello, Hi how do I download MS FrontPage the English version. Im only getting the French version

2 replies Last reply on 15 Jan 2018 by
sailas

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...

2 replies Last reply on 15 Jan 2018 by
ac3mark

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...

1 reply Last reply on 15 Jan 2018 by
ac3mark

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 ...

1 reply Last reply on 15 Jan 2018 by
vcoolio

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...

3 replies Last reply on 12 Jan 2018 by
kftempletoe

Product key for msoffice 2010

Hello, plz send me .installation key for msoffice2010

1 reply Last reply on 12 Jan 2018 by
Ambucias

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....

1 reply Last reply on 11 Jan 2018 by
ac3mark

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...

4 replies Last reply on 11 Jan 2018 by
ac3mark

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...

3 replies Last reply on 11 Jan 2018 by
ac3mark

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...

3 replies Last reply on 10 Jan 2018 by
ac3mark

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...

3 replies Last reply on 9 Jan 2018 by
ac3mark

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

1 reply Last reply on 9 Jan 2018 by
ac3mark

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 ...

1 reply Last reply on 9 Jan 2018 by
ac3mark

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...

1 reply Last reply on 9 Jan 2018 by
Ambucias

Filter the data in excel through formula

 Solved

Hello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...

27 replies Last reply on 9 Jan 2018 by
Ash

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 ...

6 replies Last reply on 5 Jan 2018 by
Mazzaropi

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...

5 replies Last reply on 4 Jan 2018 by
ac3mark

Insert rows on change of value in excel table

 Solved/Closed

Hello, 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...

Last reply on 4 Jan 2018 by
Counselor

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....

1 reply Last reply on 4 Jan 2018 by
unitepdf

Pdf attachment unreadable and opens with word

 Solved/Closed

Hello, 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,...

Last reply on 3 Jan 2018 by
sammy

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...

1 reply Last reply on 2 Jan 2018 by
ac3mark

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...

5 replies Last reply on 30 Dec 2017 by
PaiviM

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 ...

1 reply Last reply on 28 Dec 2017 by
Mazzaropi

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...

1 reply Last reply on 27 Dec 2017 by
Ambucias

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...

3 replies Last reply on 25 Dec 2017 by
Mazzaropi

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...

1 reply Last reply on 21 Dec 2017 by
ac3mark

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...

1 reply Last reply on 21 Dec 2017 by
ac3mark

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...

1 reply Last reply on 21 Dec 2017 by
ac3mark

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...

1 reply Last reply on 21 Dec 2017 by
ac3mark

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...

1 reply Last reply on 21 Dec 2017 by
ac3mark

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...

3 replies Last reply on 21 Dec 2017 by
Mazzaropi

How to convert numbers into words in excel?

Hi, How to link or create formula in converting figures to amount in words? Thanks

1 reply Last reply on 20 Dec 2017 by
xpcman

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...

1 reply Last reply on 19 Dec 2017 by
ac3mark
Results 901 - 950 out of a total of 12,266