Office Software Forum - solved topics
- Excel (9,764)
- Open Office (113)
- Outlook (641)
- PDF (334)
- PowerPoint (175)
- Word (2,186)
- Solved
-
VBA: Delete empty rows based on value of cells Solved/Closed
Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19: e32 i...
-
How to simply this Excel formula Solved/Closed
Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...
-
How to check if a cell contains "%" and calculate accordingly. Solved/Closed
I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...
-
VBA Copy/Paste fixed range a number of times Solved/Closed
Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...
-
Excel - IF function with multiple words Solved/Closed
Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...
-
Find a date in a range of dates Solved/Closed
Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...
-
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...
-
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" ...
-
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...
-
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...
-
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.
-
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). ...
-
Inserting an image without the white background Solved/Closed
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 ...
-
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...
-
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...
-
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
-
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! ...
-
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 ...
-
Inserting day of week along with date Solved/Closed
Hello, I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg Wed 1...
-
Not able to send mail from the Gmail outlook Solved/Closed
Hello, I had configured Gmail in Outlook 2007. I am able to recieve all the mails. But the problem is not able to send mail from outlook. I had giv...
-
Send mail if today is the birthday. Solved/Closed
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...
-
Comparing Two Excel Sheets and copying like data to third sheet Solved/Closed
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...
-
Using a Named Field for Autofill Solved/Closed
I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...
-
Excel Macro - Set and autofill a range? Solved/Closed
Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with a...
-
Excel autofilter stops filtering Solved/Closed
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...
-
Word 2007 blank page displaying square boxes Solved/Closed
Hello, Please can anyone help me. I was typing in english and then I wanted to change to chinese. I pressed shift and alt and immediately struck g to...
-
If a cell contains any text then add a value Solved/Closed
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...
-
Formula in Excel to turn numbers into text Solved/Closed
Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...
-
Mail.com POP (IMAP) settings outlook Solved/Closed
I got my mail.com email working using the following settings: Account type: Choose IMAP Incoming mail server: pop.mail.com Outgoing mail server ...
-
Automatically update a cell with last modified date and time Solved/Closed
I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...
-
VBA find column by name and sort Solved/Closed
Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...
-
copy x rows from a worksheet and paste x rows into another worksheet n times Solved/Closed
Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sh...
-
Create new sheets based on Column A data. Solved/Closed
Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...
-
How to put a password on my memory stick? Solved/Closed
Hello, I am looking for a way to protect my flash disk with a password. In case I lose my flash disk, and somebody else gets access to it, should n...
-
Arrow keys not working in Excel Solved/Closed
Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...
-
Unable to send emails from Outlook Solved/Closed
Hello, I have a friend who is suddenly unable to send emails. Can receive, however. Error Message is "unknown error" Ox800CCC81. Help would be most...
-
I want to change date format in Excel Solved/Closed
Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.
-
Automatically data to another sheet by adding new rows Solved/Closed
Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...
-
Creating search and update command buttons in a userform Solved/Closed
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...
-
compare 2 sheets with particular columns Solved/Closed
Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...
-
Add data to row that already contains data Solved/Closed
I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...
-
Automatically copy data from main sheet to child sheets. Solved/Closed
Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...
-
Copying formulas to multiple worksheets Solved/Closed
Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...
-
Copy data onto sheet only if cell has text Solved/Closed
Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...
-
Conditional format "match range" Solved/Closed
I am stumped and can't find an answer to this issue for Excel 2010 The best way I can describe this is that I am attempting to build an Excel based...
-
How to repair a PDF corrupted doc Solved/Closed
Hi, I am having a problem trying to open a PDF file. Ever time I attempt to open, Adobe Reader loads, but displays error message: There was an error ...
