Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Macro for the sheet where the master details are available. Closed
Hello, Configuration: Windows 7 / Firefox 44.0 I would like to know how to create a Macro for the sheet where the master details are availa...
-
Checking Spreadssheet against Raw Data Closed
Hello, I'm fairly new here. Let me thank you for your input in advance. I've created a master workbook with spreadsheets of the different system...
-
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