The discussions

Unable to change date format in excel


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...

39 replies Last reply on 6 Sep 2019 by

If statement


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" ...

4 replies Last reply on 30 Aug 2019 by

How to find the latest time per name in a table with names and times


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...

11 replies Last reply on 27 Aug 2019 by

Interest on term loan and working capital


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...

1 reply Last reply on 24 Aug 2019 by

Summarise hours incurred by month based on multiple criteria


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...

4 replies Last reply on 19 Aug 2019 by

Open office page numbering - start numbering on page 3


I would like to know how to start the page numbering on page 3 instead of 1.

3 replies Last reply on 14 Aug 2019 by

Message to appear when 5 cells uncolored cells contain values.


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 ...

1 reply Last reply on 13 Aug 2019 by

Code to move rows into another sheet based on certain values


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). ...

6 replies Last reply on 13 Aug 2019 by

Inserting an image without the white background


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 ...

20 replies Last reply on 8 Aug 2019 by

Auto-populate a sheet with data from different other sheets


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...

59 replies Last reply on 29 Jul 2019 by

Copy rows to other sheets based on value in column


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...

16 replies Last reply on 26 Jul 2019 by

Replace 'sheet' reference in a formula (not copy data, but get averages)


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...

5 replies Last reply on 13 Jul 2019 by

Ms word not displaying page numbers, images


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...

54 replies Last reply on 10 Jul 2019 by

Am not too good on percentage calculation


Hello please what is the 10 percent of,7200000000

1 reply Last reply on 10 Jul 2019 by

Why do my pdf documents open in word?


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! ...

32 replies Last reply on 8 Jul 2019 by

Macro to copy/paste down x times (where x is the number of rows)


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 ...

41 replies Last reply on 8 Jul 2019 by

Inserting day of week along with date


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...

6 replies Last reply on 27 Jun 2019 by

Not able to send mail from the gmail outlook


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...

41 replies Last reply on 22 Jun 2019 by

Send mail if today is the birthday.


Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

11 replies Last reply on 19 Jun 2019 by

Comparing two excel sheets and copying like data to third sheet


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...

11 replies Last reply on 18 Jun 2019 by

Using a named field for autofill


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...

2 replies Last reply on 12 Jun 2019 by

Excel macro - set and autofill a range?


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...

28 replies Last reply on 11 Jun 2019 by

Excel autofilter stops filtering


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...

45 replies Last reply on 11 Jun 2019 by

Word 2007 blank page displaying square boxes


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...

20 replies Last reply on 6 Jun 2019 by

If a cell contains any text then add a value


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...

20 replies Last reply on 5 Jun 2019 by

Formula in excel to turn numbers into text


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...

4 replies Last reply on 31 May 2019 by
venkatesan pop (imap) settings outlook


I got my email working using the following settings: Account type: Choose IMAP Incoming mail server: Outgoing mail server ...

23 replies Last reply on 28 May 2019 by

Automatically update a cell with last modified date and time


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...

2 replies Last reply on 16 May 2019 by

Vba find column by name and sort


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...

4 replies Last reply on 30 Apr 2019 by

Copy x rows from a worksheet and paste x rows into another worksheet n times


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...

20 replies Last reply on 29 Apr 2019 by

Create new sheets based on column a data.


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 ...

4 replies Last reply on 26 Apr 2019 by

How to put a password on my memory stick?


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...

31 replies Last reply on 16 Apr 2019 by

Arrow keys not working in excel


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...

59 replies Last reply on 15 Apr 2019 by

Unable to send emails from outlook


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...

32 replies Last reply on 11 Apr 2019 by

I want to change date format in excel


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.

13 replies Last reply on 2 Apr 2019 by

Automatically data to another sheet by adding new rows


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 ...

9 replies Last reply on 26 Mar 2019 by

Creating search and update command buttons in a userform


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...

19 replies Last reply on 24 Mar 2019 by

Compare 2 sheets with particular columns


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...

2 replies Last reply on 5 Mar 2019 by

Add data to row that already contains data


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...

2 replies Last reply on 1 Mar 2019 by

Automatically copy data from main sheet to child sheets.


Hello, I know this question was asked in another thread (

5 replies Last reply on 1 Mar 2019 by

Copying formulas to multiple worksheets


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...

11 replies Last reply on 2 Feb 2019 by

Copy data onto sheet only if cell has text


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...

17 replies Last reply on 29 Jan 2019 by

Conditional format "match range"


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...

6 replies Last reply on 24 Jan 2019 by

How to repair a pdf corrupted doc


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 ...

3 replies Last reply on 24 Jan 2019 by

Watermark to some pages not all


Hello Office Software Geek, I am currently writing a lengthy document and want to add my name as a watermark to some pages and another name to othe...

20 replies Last reply on 19 Jan 2019 by

I need a pdf to word 2007 converter


can you recommend a reliable pdf to word office 2007 converter? I downloaded pdfsmall converter and when I load the pdf file to be converted it gives...

3 replies Last reply on 11 Jan 2019 by

How can i convert a docx file to pdf ?


DOCX to PDF Converter software - you can convert your files from DOC or DOCX format to PDF format in just a few seconds with no other external compone...

1 reply Last reply on 8 Jan 2019 by

Vba code to open non excel programs


Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

10 replies Last reply on 7 Jan 2019 by

Problem with copy in one sheet


Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

26 replies Last reply on 4 Jan 2019 by

I need vba that creates a new sheet for every data entered in column d


Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

3 replies Last reply on 26 Dec 2018 by
Results 201 - 250 out of a total of 2,603