Office Software Forum
- Excel (9,686)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (171)
- Word (2,172)
-
Formula help - if cell contains a number, +1. [Solved/Closed]
Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...
-
Covert date of Birth [Solved/Closed]
Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...
-
Need help with Macro to generate Monthly Overview [Solved/Closed]
Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...
-
Help on excel [Closed]
Hello, I have a table of date time and value for a month, would like to find the value searching the date and time ex Date tim...
-
Conditional Formatting [Solved/Closed]
I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
-
Update cells in a particular column from one sheet to another [Closed]
How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to co...
-
CountIf statement driven by spesific date and text criteria [Closed]
Hello, Employee Work Code Report I need to summarize every occurrence in column C within each of the same dates in column D (1/1-1/31) and based ...
-
Formula to completed fields [Closed]
Hello, I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I...
-
Timesheet adding rows [Closed]
Hello, I'm trying to work out a formula so that I can hand off my timesheet to a new manager and have it work correctly. Right not I sum a row of to...
-
Error code 08x0087B [Closed]
I have this code coming on my screen when I try to open document
-
Unable to display pic [Closed]
Already Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...
-
Copy data from 1 excel list to another excel list [Closed]
How to copy info from 1 excel spreadsheet to another excel spreadsheet. For example, need to copy identification numbers from master list to monthly ...
-
Conditional formatting in googlesheets [Closed]
Hello, I'm using Google Sheets, not sure how big of a difference will be. I'm trying to use conditional formatting between two columns, and I'm not...
-
sending attachments through my email [Closed]
Hello, I have been sending attachments through my email and all of a sudden one wouldn't send! I write documents in Word and send through email Outl...
-
Need some programming in excel [Closed]
Hello Sir, I am A basic user & new to excel & coding. I will explain what I am looking for , than you can let me know weather it's possible or not. ...
-
copy and paste from workbook to another workbook [Closed]
Hi, I have a master workbook that has various tables on several worksheets. The information carries forward to the master page. I copy lines from thi...
-
I forgot my Gmail account password [Closed]
Hello, Send a password on my main account. System Configuration: Android / Chrome 56.0.2924.87
-
Need urgent help with spltng the data copied in another workbook [Closed]
Sub Copy_Script() 'Finds the last non-blank cell in a single row or column Dim myFile As String, cellValue As Variant, i As Integer, j As Integer, a...
-
Transfer data from one sheet to another [Solved/Closed]
Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
-
Look up a word within a sentence and copy into a next column [Closed]
Hello, I have an excel file with over 10 000 entries, each entry contains a city within the sentence - I also have a database (another sheet) with a...
-
How to transfer data to another work book in excel [Closed]
Hello, I would like to automatically transfer the data to another work book but I do not want to transfer the rows that have blank data. could you ...
-
Date formats [Solved/Closed]
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
-
Adding number of days in filtered excel sheet [Solved/Closed]
how to add number of days to columns in a filtered excel sheet
-
complicated auto populate possible or not and if so how. [Solved/Closed]
Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
-
Compare columns in two sheets and copy info across [Closed]
Hello, I have two sheets open. Sheet 1 has two columns of data (PO number, Value) Sheet 2 has two columns of data (PO number and supplier) What ...
-
excel formual help [Closed]
Hello, I need a formula, hope someone can help! If i add a date in to cell A2, i want the number 1 to appear in cell A1
-
Making Labels [Closed]
Hello, I want to make some labels for products. i have a sheet with info in columns A-F. Column F contains quantities. I need to make a sheet that ...
-
Transfering information from one worksheet to another [Closed]
Hello, I am trying to transfer information from one worksheet to another, but only if the name shows up on the second worksheet. For example, I h...
-
Copy row by x times where value x is cell value of the range [Solved/Closed]
I need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...
-
Formula for assigning numerical value to text [Closed]
Hello, I have a very large excel sheet with names. Some of the rows of names duplicate, sometimes more than once. In each row next to the name is a...
-
code to check if a work centre on sheet 1 appears on sheet 2 [Closed]
Hi, Please help me write a code that will check if a work centre on sheet 1 appears on sheet 2. If it appears in sheet 2 the work centres in sheet 1 ...
-
Cannot send email using gmail account [Closed]
Hello, Cannot send email with my gmail address. Received several email yesterday, but none since. System Configuration: Windows / Edge 14.14393
-
My arrow key move only four cells [Closed]
Hello, My arrow key move only nearest few cells even in new worksheet My computer HP probook Please help System Configuration: Windows / Chrome...
-
iso 27005 Risk Value [Solved/Closed]
Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
-
Macro for repetation [Closed]
Hello, I have a query how can I repeat the name by using the macro. I have data in one sheet where name are written in this format A 10 B 20 C 30...
-
index & match [Closed]
Hello, I would appreciate help on the following:- I have 2 excel sheets both set out as Tables (Table 2 and Table 3). Table 2 has 4 columns A B C D...
-
excel problem [Closed]
Hello, when im entering something in one sheet it is automatically coming in other sheet, when im deleting something in that sheet same happening p...
-
copy a row from one worksheet to another, based on criteria [Solved/Closed]
Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...
-
Automatic update. [Closed]
Hello, Please help me on this. Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the ...
-
Automatic Update. [Closed]
Hello, Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the following day it wont cha...
-
I want to send 120 e-mail with 120 attachments [Solved/Closed]
Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...
-
How to populate multiple rows from one row [Closed]
Thank you for accepting me into the forum & my apologies for asking for help with something that may be too basic or impossible (I hope not). I woul...
-
PDF file saves with a MicroSoft Word icon [Closed]
Hello, My Dell OptiPlex 3020 is not opening PDF files correctly. If I try to open a PDF file and then save it to the desktop, it saves with a Mic...
-
Animated gifs when saved as HTML [Closed]
I can enter an animated gif into my Excel worksheet, no problem. But I would like to save that worksheet as an HTML file. When I do so, the animated...
-
Formatting Dates [Closed]
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cus...
-
Totaling Hours by Code [Solved/Closed]
I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...
-
change data status in one same column [Solved/Closed]
Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...
-
link the data to another worksheet.. with specific names [Closed]
Hello, good day. i want to ask how can i use macro to make one click button to transfer data to another form like payslip.. i manually copy p...
-
Conditional Formatting colour cells [Closed]
Hi All, Its my First topic, am looking forward for help me. In my Excel file columns : 1. Sending letter Date 2. duration time 3. expected date...
-
Copy A row from one tab to another based on condition [Closed]
Hello, I have a excel sheet containing several tabs all containing similar data with same column names one for reach month. There is one tab by name...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received