Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Can't open office website for sign in Closed
good day I just bought a new laptop HP pavilion with intel i3. I also purchased Microsoft office 365 for one year from best buy. I want to register ...
-
Transfer data to individual sheets from Master sheet. Closed
Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...
-
Sum a columns depending on pattern Closed
Hi, I need help in adding the mileage of cars. the rule is simple.. start adding the miles from cells that contains "Movement Start" until "Movemen...
-
Transfer data from one sheet to another sheet in designate area Closed
Hello, I'm working on create a hold record document for our company to label things we need to put on hold. In sheet 1, I have columns for Hold nu...
-
Copy Paste to another sheet with conditions Closed
Dear all, I wanted to copy all the data inside this "form" through the button "send". As you can see I also have two list boxes and I only wa...
-
Group Duplicates and move to new worksheet Closed
Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...
-
date formatting Closed
Hello, how to convert dates between 1-Jan-17 to 7-Jan-17 single date as 7-Jan-17 using formula System Configuration: Windows / Chrome 62.0.3202...
-
If then statement for switching numbers Closed
How do I use the excel to basically score a survey! I want my code to say if qs: # 1 has score 1 then its 4 , if 2 then its 3 , if 3 then it's 2 , if ...
-
Trying to update date range every month Closed
We have a spreadsheet I'm creating for a recon that we can just input the new date every month (last day of each month) and end up with a description ...
-
Move Rows of Data into New Worksheets Closed
I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this daily. Move...
-
Consolidating Data Closed
Hello, I have an excel worksheet that I am attempting to publish easily by automating the recovery of certain data. My goal is to add the text of ...
-
auto populate from master to individual sheets Closed
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...
-
Make a macro run when data entered in a cell Solved/Closed
Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...
-
Need help with #value! Closed
Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...
-
Conditional sum function in Excel Closed
hi, i have 2 sheets in matrix format ,One having travel time between different zones and other having values of number of trips between different zo...
-
Need help with #value! Closed
Hello, I need a formula that will change answer based on selection from drop down box B33 can be any number from 0-10, it has a drop down box w...
-
How to format text with a Macro? Closed
I have a simple event based "macro" that populates my header with information. The question I had was: How can I have the header populate thi...
-
Excel Formula/VBA Assistance Closed
Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...
-
Word 2010 showing dots instead of spaces Solved/Closed
Hello, when I press space tab in the keyboard, a dot is printed in the Microsoft word 2010. How can I fix this problem? faithfully you Con...
-
Worksheet_SelectionChange event not working Solved/Closed
Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...
-
auto populate from master to individual sheets Closed
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that...
-
give a response by comparing 2 times (in different columns) Closed
I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM...
-
import jpeg into cel Closed
Making database for artist archive. Best way to import image files? Sizing is part of issue - how to import a small jpeg and have it conform to cel?
-
Working out the difference in times between two columns Solved/Closed
I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...
-
How to load data from various sheets into one master sheet? Closed
Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate number...
-
SKU011.CAB Solved/Closed
when I go to open ms word or ms excel computer ask for sku011.cab file. I have no cd of office 2003. please help
-
Excel macro to insert two rows. Closed
Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in different ...
-
Convert in to rs in word Closed
3456755332578097 convert in to rs in word
-
How to use the Spellnumber function in Excel? Closed
Hi. Please giud me how to use formula in excel for spell number for Indian currency .
-
Inserting day of week along with date Closed
Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome of: Su...
-
Multiple cell copy to a single cell Closed
Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but,...
-
Emails not coming in Closed
Hello, I am unable to go into my emails for the last week or so. System Configuration: iPad / Safari 8.0
-
How to copy columns to a specific column header and repeat? Solved/Closed
Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...
-
Auto populate data from invoice. Closed
Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn sell,...
-
Changing format of date in Excel Solved/Closed
Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...
-
Auto populate text and add total from one sheet to another Closed
Hello, I am trying to work on a yearly spreadsheet that has tabs for each month. What we are trying to do is each month we update monthly tabs w...
-
Create new sheets, scrape in data, then create summary sheet Closed
Hello Everyone, hope you are all well. I am trying to create a database to manage reviews of research papers for a project I am working on. Any he...
-
Can the index function in Excel set a range in different sheet? Closed
Hello there, I need a small help. I need to know whether we can use the index function for setting a range in different sheets. I've u...
-
email sent out but not received Closed
Hello, I just realized that i can receive and send out emails from my outlook but the emails sent out is not received but the emails sent through ...
-
How to create New sheets by column with repeated values Closed
Hi Have lines with various tables in rooms. Rooms numbers are in column, but sometimes room have 2 or more tables so room numbers repeats. Code s...
-
Getting rows from one sheet to populate to another Closed
Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...
-
max(if..? Closed
hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...
-
Outlook 2010 configure for Gmail Solved/Closed
I have created an account and tried configuring through Outlook 2010. Though the test message is successful for sending and receiving, outlook is able...
-
Word 2013 repair Closed
Hello, Word came up with an error message saying I had to 'repair' it so I followed the instructions and used Online Repair. I know it takes a lon...
-
Can you draw a picture in the Microsoft Word window? Closed
Can you draw a picture in the Microsoft Word window? I need to draw a kitchen cabinet chart. but I don't know how to use graphic design software. I...
-
calculation using alphabet instead if number Closed
Hello, Dear Sir, If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0 For example Numeric column > 9949 = JJDK 9949 ...
-
Copying formula by changing only one rule. Solved/Closed
Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...
-
How to use index function to match from different worksheets? Closed
hi there, please let me know how can i use index match from different worksheets. as i need to use index function for more than one worksheets...
-
Month and year format in forms in excel Closed
Hello, Hello sir I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Nam...
-
Use a macro to copy a value from one sheet to another Closed
Greetings, I'm looking for help modifying or creating a macro to copy the value of a specific cell on one sheet to a specific cell on another sheet. ...
