Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
jinco wireless-n USB adapter Closed
Hello, sir & madam i will purchase for wireless-n USB Adapter so install from applacation
-
Yahoo account will not connect Closed
I try to add my yahoo account in outlook. I input the appropriate settings imap.mail.yahoo.com port 993 encryption method SSL/TLS smpt.mail...
-
VBA Coding Closed
I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sh...
-
Arrow keys not working Closed
Hello, my arrow keys are not working. up down left right
-
How to automatically number the pages in a document Closed
How could the engineers who designed Open Office be so bloody stupid? I mean what is so complicated for a software engineer to design something to au...
-
Unable to change date format in Excel Solved/Closed
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...
-
Excel 2013 to extract text in one cell Closed
Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...
-
how to transfer data from sheet to sheet 2 Closed
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...
-
IF statement Solved/Closed
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...
-
Dynamically Assign a Number in Data Set Closed
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...
-
transfer data from userform to sheet with the same format of table Closed
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...
-
How to find the latest time per name in a table with names and times Solved/Closed
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...
-
Need to create linked sheets Closed
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is lik...
-
SUMPRODUCT Based on WBS Closed
-
INTEREST ON TERM LOAN AND WORKING CAPITAL Solved/Closed
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...
-
get help Macro sheet Closed
Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i am ...
-
Spreadsheet help moving data Closed
So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....
-
Excel vba to color row based on wbs level Closed
Hello I need a macro to change row color based on "Level" column. Thanks Ebti
-
Copy from one cell and paste to another sheet based on length of another column Closed
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...
-
Summarise hours incurred by month based on multiple criteria Solved/Closed
Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...
-
Open Office page numbering - start numbering on page 3 Solved/Closed
I would like to know how to start the page numbering on page 3 instead of 1.
-
how to reset my nokia 1202-2 pin code Closed
Hello, im forgot my nokia 1202-2 pin code
-
Are you still taking questions? Closed
Hello, Are you still taking questions?
-
Message to appear when 5 cells uncolored cells contain values. Solved/Closed
Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...
-
Code to move rows into another sheet based on certain values Solved/Closed
Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...
-
create an ordering list for our consumables Closed
Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...
-
False Value removal Closed
Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))
-
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output Closed
Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...
-
Inserting an image without the white background Solved
Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square appears ...
-
Creating a data input sheet with excel Closed
Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...
-
Count cells containing text per row Closed
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...
-
Excel Formula to identify similar text Closed
Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...
-
update Open Office failed Closed
I did as you directed for updating Open Office but "update failed" several times what should I do next? thank you
-
Search using variable Closed
Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...
-
Auto-populate a sheet with data from different other sheets Solved/Closed
Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...
-
Copy rows to other sheets based on value in column Solved/Closed
Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...
-
transfer data from sheet1 to sheet2 Closed
Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna delet...
-
macro code vba exel sum dublicate data and delete Closed
hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum dublicate ...
-
Copy Template, Rename based on a reference list from a different spreadsheet Closed
Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my templa...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) Solved/Closed
Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...
-
Copying Excel data from one sheet to another based upon contents of a cell Closed
Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email address Col ...
-
MS Word not displaying page numbers, images Solved/Closed
Hello, So far MS word worked fine. But now it is not showing up images. Also not even page numbers. Instead showing up {Page}. Please let me know...
-
Am not too good on percentage calculation Solved/Closed
Hello please what is the 10 percent of,7200000000
-
How to duplicate rows x number of times Closed
Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A, Col...
-
Why do my PDF documents open in Word? Solved/Closed
Hello, I can't figure out why my PDFs always get open in Word but not the Adobe program? Does anyone have a quick answer? Thank you so much! ...
-
Follow up Q to how to add a certain number of days to a date in excel Closed
Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column, depending ...
-
Macro to copy/paste down X times (where X is the number of rows) Solved/Closed
Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...
-
Compare sheets macro Closed
Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the two ...
-
Which macro (of many) changes the data in my workbook Closed
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...
-
RTF to PDF Converter Closed
How can i convert a rtf file to pdf ?