Office Software Forum
- Excel (9,703)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (172)
- Word (2,176)
-
If cell equals text, then value/Formula [Closed]
Hello, BACKGROUND: I am working on a budget and I'm paying down debt using a waterfall. I have a list of debts on a "Data Entry" tab, and I have ...
-
Formula in Excel [Closed]
If I have a master document with alpha numeric values in column A lets say for example Sku001 through sku099, in column B is the corresponding value ...
-
use date to return value of 1 [Closed]
Hi, can anyone tell me how to use the entry of a date field to return a value of 1 in Excel? I need to tabulate items where a date is the entered reco...
-
formula [Solved/Closed]
Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...
-
i need a difference between 2 colums in diffrent sheets [Closed]
Hi example sheet 1 sheet 2 ndc quantity ndc quantity ...
-
Code that allows User to Input Begin, End Date, and Team Number [Closed]
Hello, I am looking for VBA code that will allow a user to input the begin and end date they are looking for, as well as team number. For exam...
-
Table Updates between worksheets [Closed]
Hello, I have 3 worksheets, each with a range formatted as tables. All the tables have 2 columns in common 'ID' and 'Vendor'. When I add a new ID...
-
how to convert date of birth in word [Closed]
Dear Sir, With reference to the above mentioned subject, I want the solution in excel for change the date of birth in words. For Example :- if I wi...
-
2 rows into one in excel [Closed]
Hello, I would like to sort 2 rows of excel into one A B 2 4 5 6 To C 2 4 5 6
-
Need cell value copy to defferent -2 work sheets within a Excel [Solved/Closed]
Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...
-
Excel / comparing data [Closed]
Hello, my name is Malwina. I would very much appreciate your help, please. I was trying to compare the spreadsheets but really have no idea ho...
-
Transfer data from an old report to a new one [Closed]
Good evening everyone. I'm trying to develop a macro that will compare data between two versions of the same report. The old file, contains a list o...
-
Identify Value "O/B", If True search column for "/" [Closed]
Hello, Im trying to make a break list to be active on a daily basis in a workplace, currently it works immacutely but i have hit a speedbump in co...
-
PDF attached to email won't open [Closed]
Hello, When I receive email with a PDF attachment, they do not have Adobe icon but do have the .pdf extension. If I try to open it, the Windows Medi...
-
excel function to Check neighbour cells match for all [Solved/Closed]
Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...
-
How to Map 2 different columns in from 2 different excel files? [Closed]
Dear All, I am trying to Map values from 2 different columns from 2 different excel files. I am unsure as how to invoke the sheets and print the re...
-
Multiple IF functions [Closed]
Hello, I am trying to built a multiple If condition. I want excel to search for 2 words in an array "Lose" and "Tie". If it finds "Lose" then i want r...
-
A1 draws amount from other cells by live date. [Closed]
I'm stumped. I need the value in cell A1 to change automatically the first of each month. Column A2:A13 has dates for the first day of Jan through D...
-
Sum of the total times a Column has a certain text [Closed]
Hello, I am trying to find the total amount of times that a certain text appears in a column. From A2:A689 I am trying to find the amount of times...
-
To change cell value automatically [Solved/Closed]
Hello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...
-
Help with IF STATEMENT / VLOOKUP (I think) [Solved/Closed]
I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...
-
Help w/If Statement [Solved/Closed]
Hello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...
-
multiple options for if in a drop down menu [Closed]
hello, i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop do...
-
Searching for a specific values on multiple sheets using Macro [Closed]
Hello, I have multiple different sheets, for example I have 4 sheets now. first sheet,second sheet, third sheet, forth sheet. each sheet has 5 ...
-
MS Office 2010 Publisher Download [Closed]
Your link http://ccm.net/download/download-1620-microsoft-office-publisher indicates the download is in English, however when I download it, it's Fren...
-
Frequent missing emails inbox (blank) [Solved/Closed]
Hello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...
-
Macro Help [Solved/Closed]
Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...
-
The perpetual question: Auto-populating sheets based on criteria [Closed]
Hello, I realize this question has been asked in a million iterations, but my understanding of programming is so nonexistent that I can't confiden...
-
VBA single click to get current date [Solved/Closed]
Hello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...
-
Macro to Create, Name and Fill New Sheets Based Data Set [Closed]
Sorry, I realize this question gets asked all the time. What I'm looking for seems different enough that I will need some specific help. The post righ...
-
Moving view, not moving selection [Closed]
Hi there :-) Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrol...
-
How do I get a value in a cell based on another cell [Closed]
Hi, How can I get excel to fill in some information for me? I want the value in column A to be filled in based on the value in either column B ...
-
How to compare two Excel sheets with varying data [Solved/Closed]
Hello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...
-
I need to copy the Hyper link as well as the text in the followi [Closed]
I am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done. Range(wsO.Cells(1, 1...
-
how to return to only one line for each mail [Closed]
Every mail in outlook comes with 2 lines. to open mail I click oj the second (the one with closed envelope). To delete this mail I need to click twice...
-
Need VBA to send the invoice through outlook [Closed]
Hi All, I need help with VBA code to send the PDF copies from the folder through outlook using the Excel Distribution list that when I run, would l...
-
Conditional Formating [Closed]
Hello, I am using Excel 2010. I have a call that contains Week number which has filter from w1,w2,w3,....., Also I have the list of week values in...
-
How to use Range function with variables? [Closed]
HI, I need help in running a macro with VB Script. I am trying to select a range with the help of a variable. I have comup with the below code. ...
-
Ranking sorting problem [Closed]
Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...
-
Copy & pasting the data into excel from an SQL Database file [Closed]
Hello, We have setup a database which inserts the data from an batch file and the data is extracted into an output file. The output file needs t...
-
Differences in two excel sheets [Closed]
Hello, I am trying to see if I can compare the first column in two different excel sheets to see if there are differences. Column A Book 1 ...
-
pdf into excel [Closed]
I saved my excel file as x but it was automatically saved as a pdf. I am using windows 10. The pdf is microsoft edge. I need it back as excel. Please ...
-
Find Serial Number and input Average Value into Adjacent cell [Solved/Closed]
Hello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...
-
VBA code for duplicating Excel Workbook [Closed]
Hi all! My company use delay logs where we record delays everyday for different customers. At the moment every morning we're having to manually ...
-
Formula that can automatically classify monthly expenses [Closed]
Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as ...
-
One million and two hundred thousand only [Closed]
I have try edit vba code in Excel for spell cu1,200,000 = One million and two hundred thousand only change in to One million and Two San only. please...
-
Using the picture editing toolbox in Word for Mac. [Closed]
Hello, In Word for Mac, there are, episodically or maybe by a rule I don't know, two options for editing a picture or screen shot. How do I get th...
-
downloading [Closed]
Hi, can yoy help me how to download excel or spreadsheet using open office. I need it for my job. Thank you very much
-
Copy the data of a Row based on identifying the data in a cell [Closed]
Hello, I have data in about 20 columns and 100 rows There are some blank cells in column "I" (about 20 blank cells totally in "I" column, at di...
-
Excels docs are opening as PDF [Closed]
Hello, I am using windows 10. My excel documents are being saved as microsoft edge files. This is a nightmare. I need the excel docs. Please help ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received