The discussions
Vba: delete empty rows based on value of cells
SolvedHello, 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
SolvedIs 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.
SolvedI 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
SolvedHello 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
SolvedHi 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
SolvedHi 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/ClosedHello, 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
SolvedHello, 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
SolvedHello; 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/ClosedDear 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
SolvedHi, 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
SolvedI 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.
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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)
SolvedHello, 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/ClosedHello, 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/ClosedHello please what is the 10 percent of,7200000000
Why do my pdf documents open in word?
Solved/ClosedHello, 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/ClosedHello, 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/ClosedHello, 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
SolvedHello, 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.
SolvedHello, 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/ClosedHi, 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
SolvedI 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/ClosedHello, 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/ClosedHello, 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/ClosedHello, 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
SolvedI 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
SolvedHello, 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/ClosedI 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
SolvedI 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
SolvedHello, 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
SolvedHi, 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.
SolvedHi, 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/ClosedHello, 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/ClosedHello, 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/ClosedHello, 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/ClosedHello, 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
SolvedHello, 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/ClosedI 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
SolvedHello, 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
SolvedI 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.
SolvedHello, 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
SolvedHi, 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/ClosedHello, 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"
SolvedI 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/ClosedHi, 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 ...
