Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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 ...
-
auto populating sheets from data in main two sheets Closed
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...
-
Loop for the Recorded Macro Closed
Hello, I have recorded the below Macro. All i want is to Loop till the end. Sub MainTranspose() ' ' MainTranspose Macro ' ' Keyboard Short...
-
Can I have any training to using excel? Closed
I wish to learn how to use excel
-
copy two sheets data in new work book with two sheets. Closed
Hello, I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, father name, Dob, Date of Joining). count of "N" Student...
-
How to use IF statement to add 1 to total? Closed
My question is slightly different: RANDOM calculation is created in cell J20 by pressing F9 (prompting different random values in J20). I want cell ...
-
Copy selected data from one sheet to another in Excel Closed
Respected Sir, I have a data sheet like below : Note No. Date Name Bill No. 10522 12/04/2017 Jones 123/17-18 10523 18/04/2017 Ram 123/17-18 1...
-
Conditioning a cell Closed
Hello, I'm trying to program a cell to return a 0 (zero) if a condition is met. I have two text "Referral Fee" and "Incentive Fee" that when thos...
-
Autopopulation of mutiple files from 1 master sheet Closed
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 Closed
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. Closed
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...
-
i dont want add paise in while converting numbers in words Closed
Hello, i dont want paise while converting numbers in to words System Configuration: Windows / Chrome 63.0.3239.84
-
Product key of Office 2010 Solved/Closed
I don't K now product key of office 2010 please send me this key Regards Pardeep Gur