Office Software Forum
- Excel (9,735)
- Open Office (113)
- Outlook (637)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
Logging web data excel [Closed]
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 [Closed]
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 [Closed]
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, [Closed]
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 [Solved/Closed]
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 ...
-
transfer certain information from one sheet to another [Closed]
I have multiple employees. I have my payroll broke down into months. I need to have a sheet for each employee. Can i use a formula so I only have t...
-
my password was hack [Closed]
Hello, my password wad hack System Configuration: Android / Chrome 50.0.2661.89
-
Unable to format any date prior to 1900 as dd/mm/yyyy [Closed]
This is my second request for help. I am unable to format any date prior to 1900 as ddmmmyyyy. No matter how many times I try to custom format it, t...
-
Highlight Cell Question [Closed]
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 [Closed]
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/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...
-
Importing a Word document into PowerPoint [Closed]
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/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,...
-
Unable to share files in Outlook [Closed]
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...
-
date and time format change [Closed]
Hello, hi I want to change 15:07:2017 19:51:54 date format in 15/July/2017 19:51:54 System Configuration: Windows / Chrome 62.0.3202.94
-
Google Spreadsheet Help [Closed]
I'm looking to create a very intricate spreadsheet on google which requires a custom formula, problem is, can't find what I need. I have a cell tha...
-
Copy all csv file data in one master sheet through VBA [Closed]
Hello, I am in new in VBA ; Almost around 3000 csv file in folder, I want all CSV file data copy in one master sheet using VBA along with file ...
-
Excel date formula doesn't work past the new year [Closed]
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! [Closed]
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 [Closed]
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 [Closed]
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...
-
Formula for calculating work hours on overnight shifts [Closed]
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 ...
-
Consolidate different workbooks into a new one [Closed]
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. [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Formula IF contains certain text, then will add time to another [Closed]
Hello, A1 is original time, B1 will be a type of equipment, C1 will be 40, 45 or 55 minutes, depending on types on B1, D1 will add C1 and A1 and thr...
-
How to convert numbers into words in Excel? [Closed]
Hi, How to link or create formula in converting figures to amount in words? Thanks
-
Data Comparison in excel [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Excel VBA Template [Closed]
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 daily lik...
-
Copy and paste data from different sheet. [Closed]
Hello, I have a small problem. I have made dependent lists in excel to capture the data. However, to sum up the data, I need to pick up the entire...
-
Use a macro to copy data from rows into destination range [Closed]
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...
-
Excel formula to subtract a value based on a date condition [Closed]
I need a formula for my budget in excel. I have the date automatically updating and I would like to use the due date for an automatic payment to ch...
-
Copy two sheets data in new work book with two sheets. [Closed]
Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...
-
Macro coding [Closed]
Dear concern Macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with speci...
-
How can I stop/remain from changing the value in the Lapse days [Closed]
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? [Closed]
where is my download ( adobe acrobat reader) in this site?
-
How to use a macro to copy data from one sheet to another? [Closed]
macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with specific cell value
-
Excel Macro - Create Multiple Workbooks [Closed]
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...
-
Macro [Closed]
Compare the duration field for each same environment and display the difference Note : Duration will be reported once the status is complet...
-
Formatting cell based on text in another sheet [Closed]
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 [Closed]
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. ...
-
Copy and convert worksheet data [Closed]
I have an exported worksheet of data from an InfoPath Form. The results are Yes, No, NA, Blanks and dates; I want to copy all the data to a new works...
-
IF function in Excel error [Solved/Closed]
Hello, 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))) * * ...
-
Formula in excel [Closed]
how to fetch values by formula in cell from given rage only once thereafter formula should be in active or can formula be made inactive by changing ...
