Forum
Office software
-
How can I separate each slides from one PPT file? [Solved]
Hi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to...
-
When the field is =N, want to subtract that field [Solved]
Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that...
-
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...
-
Conditional formatting across multiple columns [Solved]
Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two...
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
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...
-
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...
-
Copy conditional formatting for an entire row based on one cell [Solved/Closed]
Hello. I'm working on an Excel sheet, where the entire row is coloured based on the values of two cells in the current row. If one of the cells...
-
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. ...
-
Duplicate rows from multiple worksheets [Solved]
Hello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to...
-
Microsoft Word icon changed to unknown program [Solved/Closed]
Hello, Recently my microsoft word (program) icon changed from the classic picture to the unknown programs icon. I wanted to know how to get...
-
Excel "IF" function w/ date in test cell [Solved/Closed]
Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to...
-
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...
-
Change color for specific number of cells by value [Solved]
I have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project....
-
Auto populate from master file to other [Solved]
Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract...
-
Auto create info sheets from master spreadsheet [Solved]
UPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My...
-
I need a pdf to Word 2007 converter [Solved]
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...
-
Microsft Word icon is gone. [Solved/Closed]
Hello, I have a question. Until recently there has been a Micorosft icon on my desktop and it showed up under the "All Programs" list on my...
-
Convert PDF to Word without altering PDF images [Solved/Closed]
Can converting from PDF to word be done without alterations of the PDF images?
-
Inserting an image without the white backgrou [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...
-
Use in Scripting.Dictionary- item join string 3col [Solved]
Hello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of...
-
How to change date format from yyyymmdd to mm/dd/yy in Excel [Solved/Closed]
Hello, I have data with dates arranged thusly: yyyymmdd Is there an easy way to change the format to mm/dd/yy in Excel...
-
How can I automatically copy table to next sheet? [Solved]
Hello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once...
-
Change date format dd.mm.yyyy to dd/mm/yyyy [Solved/Closed]
Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System...
-
Excel partial match [Solved]
Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has...
-
Convert number to spelling [Solved/Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) =...
-
Transfer data from 1 sheet to another with cond. [Solved]
Hi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the...
-
Macro to manipulate lines of text [Solved]
I have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z...
-
Find and replace from a dropdown [Solved]
hi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel...
-
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.
-
How to easily cummulate data [Solved]
Hi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it,...
-
Watermark to some pages not all [Solved/Closed]
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...
-
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...
-
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...
-
How to add 200 working days to a given date. [Solved]
Hello, Please I want to know how I can add 200 working days to a specific date to get a new date
-
Auto populate data between Excel sheets [Solved]
Have project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could...
-
Cannot change the date format in Excel 2007 [Solved/Closed]
Hello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I...
-
Excel lookup 2 cells to match in 2 rows. [Solved/Closed]
Hello, I am using Excel to makes archives of PC issues we have in our compagny I have Info that i have to write in two cells that are...
-
Row conditional formating in Excel [Solved]
Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain...
-
Highlight Help [Solved]
Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am...
-
Counting Sites visits within a year [Solved]
Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of...
-
How to apply conditional formatting [Solved]
I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and...
-
How to copy data to a different worksheet? [Solved]
Hello, I would like to copy data from a specific cell of a worksheet and paste into a specific cell in a different worksheet Eg from cell b2 of...
-
Conditional Formatting - Dates [Solved]
Hello, On a spreadsheet, the cells in column N contain a date. I need any date that is 6 weeks ago or longer to be highlighted. How do I...
-
Rearrange multiple columns in four columns, VBA [Solved]
Hello guys, An excel rookie needs the help of more experienced users of Excel and VBA. I have a data set that looks the following...
-
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 ...
-
Matchpoint score [Solved]
hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points...
-
Can't reinstall Office 2010 [Solved]
Can't reinstall Office 2010. Always get a notice that an error has happened and it will not install !
-
Yahoo ID and password hacked [Solved/Closed]
Hello, My Yahoo ID and password has been hacked by someone, coz of that I could I m unable 2 log in. Plz help me out and dont send a mail...
-
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...