Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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/...
-
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 ...
-
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...
-
Autopopulating multiple sheets from main sheet by date Closed
Hello, My name is Ana and I have a situation. Every day we have hunďreds of rows with diffrent info about our customers. On column H we have cells...
-
How to get a product key for Microsoft Office 2010? Closed
how to get a product key on Microsoft Office 2010?
-
Automatic add and sub Closed
Hello, Hi everyone,I need help from u regarding excel formulas and workout basics.My question is..If i add particular row or column it should be a...
-
Looking to enter a name and then want it to be pasted in x numbe Closed
Hello, Looking to enter a name and then want it to be pasted in x number of rows. Then enter a new name in the x + 1 row and want that pasted y n...
-
VBA macro loop Closed
Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...
-
Can't open documents with a W. Solved/Closed
In my documents, I have some items with PDF and some with a W. When I try to open the ones with a W, I am asked to sign up with Word. How can I open t...
-
compilation Closed
Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...
-
How to compare a range of data in Excel? Solved/Closed
Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...
-
Ms Visio setup free download Solved/Closed
i got a little challeng dowenloading free Ms visio setup could u send me please
-
Adding and subtracting using Vlookups Closed
Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...
-
Pictures insertion Closed
Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...
-
How to use VBA to loop copy and paste Closed
Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...
-
Copy Paste Special Values Macro Closed
Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...
-
How to update data of Sheet2 in Sheet1 with Excel? Closed
Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...
-
Use conditional formatting to highlighting cells based on Name Closed
Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...
-
VBA for copying from data entry sheet to corresponding sheets Solved/Closed
Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...
-
How to extract data using VBA in Excel? Closed
Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...
-
Calculate a percentage when the values are text Closed
I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...
-
Copy Rows from one sheet to others based on a condition Solved/Closed
Hello, I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often (addi...
-
How to count the number of occurrences in a range Closed
I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...
-
Formula for Unique ID's following a predefined rule Closed
Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...
-
Dates conversion Closed
Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...
-
Reformat date field to plain text Closed
I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...
-
How to find a product key for MS Office 2010? Closed
HOW CAN I GET PRODUCT KEY OF MICROSOFT OFFICE 2010?
-
how to give a students two ranks Closed
Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...
-
Delete or insert rows in a workbook Solved/Closed
Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...
-
How to make one summary file with 29 sum up sheets Closed
Hi My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large...
-
How to insert Reading Progress indicator in Microsoft Word .docx Closed
Hello, I use Word 2016. How do I insert 'Reading Progress Indicator / bar' in my .docx documents?
-
Autopopulate using dates Closed
Kind of a complicated one. I'll be appreciative/extremely impressed if someone can help me out. I'm budgeting and trying to autopopulate cells usi...
-
How do I create this conditional formula Closed
How do I create this formula? If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell ...
-
What formula can be used to share data in 2 sheets Closed
Hello, I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, havin...
-
Conditional Formatting Closed
I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...
-
How to use a macro to check data in 2 work sheets Solved/Closed
Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...
-
Can't send messages in Outlook 2010 Closed
I cannt sending my massages from outlook2010 but I revived very well
-
How to generate a STATIC unique identifier for each Excel row Solved/Closed
Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
