http://en.kioskea.net/forum/forum-25-office-software Installation, configuration and use office software (Office, OpenOffice, and so on.). en Wed, 25 Nov 2009 21:00:05 GMT Wed, 25 Nov 2009 21:00:05 GMT http://en.kioskea.net/www/rss.php3 CommentCaMarche © 2009 CommentCaMarche.net/Kioskea.net webmaster@commentcamarche.net http://en.kioskea.net/forum/forum-25-office-software http://en.kioskea.net/img/logo-xs.png 120 54 http://en.kioskea.net/forum/affich-207164-vba-if-function-when-two-cells-are-different Hello, I've been looking unsuccesfully everywhere for an answer to how to create an IF loop for the following situation: I have an Excel sheet with different words eg. names, going all the way down column A. I want to create a loop where if two cells have different names, then 2 blank rows gets inserted between them. eg. Cell A1: Anne Cell A2: Anne Cell A3: Bob Cell A4: Charlie So between Wed, 25 Nov 2009 21:00:05 GMT http://en.kioskea.net/forum/affich-207164-vba-if-function-when-two-cells-are-different http://en.kioskea.net/forum/affich-207141-moving-2-fields-in-2-rows-into-2-colums Hello, Thanks for reading this. Please advise. Here is how my excel spread sheet is set up. A1 B1 C1 D1 E and F Empty C3 C4 Need to move C3 and C4 to E Column and F column in the same row have like over 10K records that need to be move. Please HELP!!! ! ! ! !Configuration: Windows Vista Firefox 3.5.5 Wed, 25 Nov 2009 20:02:49 GMT http://en.kioskea.net/forum/affich-207141-moving-2-fields-in-2-rows-into-2-colums http://en.kioskea.net/forum/affich-206853-excel-macro Hello, I want to write a macro which moves a cell value 'X' number of rows depending on the value entered in the cell on sheet 2 . ThanksConfiguration: Windows XP Internet Explorer 6.0 Wed, 25 Nov 2009 10:37:56 GMT http://en.kioskea.net/forum/affich-206853-excel-macro http://en.kioskea.net/forum/affich-206845-stable-date Hello, Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system in TODAY() and NOW(). once it takes the system date it should not change for the next day...... Thanks Samran PashaConfiguration: Windows XP Internet Explorer 6.0 Wed, 25 Nov 2009 10:22:05 GMT http://en.kioskea.net/forum/affich-206845-stable-date http://en.kioskea.net/forum/affich-206738-match-two-spreed-sheet Hello, I have two excel sheet one in tally other in stores, tally xlsx SL Item Name Unit Op Stock Inward Outward Cl Stock 301 .Developer 9 Ltrs pkt 1 2 3 0 302 .Developer 10 Ltrs pkt 5 5 0 10 303 .Developer 2 Ltrs pkt 5 5 0 10 Stores Xls SL Item Name Wed, 25 Nov 2009 06:18:20 GMT http://en.kioskea.net/forum/affich-206738-match-two-spreed-sheet http://en.kioskea.net/forum/affich-206630-please-help-it-has-to-be-simple-for-someone Hello, I need a Excel Formula What i need it to do is take information from the A cells and from the B cells and put it into C cells. Now here is the but for this question. I need it to display text or numbers. Example If i have 545 in sell A1 and i have nothing in cell b1 i want it to show 545 in cell C1 If i have the part name in A1 and nothing in cell b1 i want it to display the part name Wed, 25 Nov 2009 02:01:05 GMT http://en.kioskea.net/forum/affich-206630-please-help-it-has-to-be-simple-for-someone http://en.kioskea.net/forum/affich-206604-excel-2003-vba-formula-for-auto-sorting Hello, I have a worksheets (1) in which I have data in range A3:A10 that comes from another worksheets. I am trying to auto sort the whole range A3:D10 base on any date changes in A3:A10. I created the following Macro; Sub Macro1() Range("A3:D10").Select Selection.Sort Key1:=Range("A3"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, Wed, 25 Nov 2009 01:16:37 GMT http://en.kioskea.net/forum/affich-206604-excel-2003-vba-formula-for-auto-sorting http://en.kioskea.net/forum/affich-206588-excel-each-column-new-worksheet Hello, I was hoping somebody could help me with an Excel problem - I am not a very advanced excel user but I am hoping someone can give me some simplified advice. Basically I have got an Excel 2007 worksheet with 250 odd columns and I need to split each column of existing data onto a new worksheet. Column A is actually my list of headings, so ideally I would like to extract Columns A and B Wed, 25 Nov 2009 00:13:35 GMT http://en.kioskea.net/forum/affich-206588-excel-each-column-new-worksheet http://en.kioskea.net/forum/affich-206579-excel-macro Hello, I have a query in macro. I have 2 excel sheet. In 1st sheet i have list of rows. For eg: 20 rows (may vary)(5 columns). In 2nd sheet 1-3 names. Now, If in 2nd sheet, i have one name, then in 1st sheet at the end column (6th column) , i want that names to be displayed. If in 2nd sheet, there are 2 names, then in 1st sheet, i want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 1st Tue, 24 Nov 2009 23:34:02 GMT http://en.kioskea.net/forum/affich-206579-excel-macro http://en.kioskea.net/forum/affich-206553-help-with-excel-macro Hello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It has alocated columns for: ID numbers, arrival date, departure date, hotel name, number of pax, etc. What I need is a macro that selects the active cell I'm on and adds a new worksheet after the last one, then use that ID number to name the new Tue, 24 Nov 2009 22:33:04 GMT http://en.kioskea.net/forum/affich-206553-help-with-excel-macro http://en.kioskea.net/forum/affich-206547-excel-macro-won-t-loop Hello, I'm new to this forum and to VBA. I need help. Basically I've been search the internet for code to do what I need and nothing seems to work completely. This is what I need: I have an excel 2003 file with a "Data" tab and a "Template"tab. The data tab will have over 400 rows of client data that I need to copy individual client information into the template tab and Tue, 24 Nov 2009 22:01:57 GMT http://en.kioskea.net/forum/affich-206547-excel-macro-won-t-loop http://en.kioskea.net/forum/affich-206425-macro-to-clear-conditionally-formated-cells Hello, I am trying to clear cells with a specific fill color [Green], that have been conditionally formatted. If it's easier, they have been conditionally formatted to turn green when any date before today's date is entered. All I'm really trying to do is clear the cells with a date before the current day and if at all possible, bump the remaining dates in the row to the far left. The current Tue, 24 Nov 2009 17:05:44 GMT http://en.kioskea.net/forum/affich-206425-macro-to-clear-conditionally-formated-cells http://en.kioskea.net/forum/affich-206394-find-max-min-based-on-starting-date Hello, I need to do the following: Colm1 date col price 1 col 3 price 2 11/1/09 1 4 11/2/09 3 8 11/3/09 2 7 11/4/09 5 3 I need to use date as starting point and then go + or - 5 days to find min in the first col and then max in Tue, 24 Nov 2009 16:11:30 GMT http://en.kioskea.net/forum/affich-206394-find-max-min-based-on-starting-date http://en.kioskea.net/forum/affich-206374-conditional-countif-excluding-duplicates Hello, I have two columns one with a list of dates the other with a list of unique references numbers. I need a count function that looks into the date column and counts unique references numbers in the column ajacent. E.g. the exact same was a sumif works but with a count instead. Can anyone help?Configuration: Windows XP Internet Explorer 6.0 Tue, 24 Nov 2009 15:51:11 GMT http://en.kioskea.net/forum/affich-206374-conditional-countif-excluding-duplicates http://en.kioskea.net/forum/affich-206353-adding-color-to-cell Hello, I want, for example cell A1 to turn red if there is an entry put in cell C1Configuration: Windows XP Internet Explorer 6.0 Tue, 24 Nov 2009 15:32:38 GMT http://en.kioskea.net/forum/affich-206353-adding-color-to-cell http://en.kioskea.net/forum/affich-206320-creating-a-submit-macro-in-excel Hello, I'm trying to create a form for my staff to complete in Excel which then feeds into a 2nd sheet holding all the information. I've created the form itself. I've also created the database with the same headings as the form. I want to be able to erase the data on the first form once my staff have submitted it, and populate the database worksheet with the information on the form and ensure Tue, 24 Nov 2009 14:35:00 GMT http://en.kioskea.net/forum/affich-206320-creating-a-submit-macro-in-excel http://en.kioskea.net/forum/affich-206240-cell-colour-change Hello, Using Excel 2007 - I have used conditional formatting to change cell F4 to a colour when entering Y or N. I need to change the colour of F5 when F4=N. I have tried the conditional formatting but cannot produce the desired result.Configuration: Windows XP Internet Explorer 7.0 Tue, 24 Nov 2009 11:45:12 GMT http://en.kioskea.net/forum/affich-206240-cell-colour-change http://en.kioskea.net/forum/affich-206224-vba-to-delete-row-in-table Hello, I need help to delete all the empty rows in a table and then stop once it reaches a particular value. Does anyone know the vba to do this?? thanks in advance!Configuration: Windows XP Internet Explorer 6.0 Excel 2003 Tue, 24 Nov 2009 10:58:38 GMT http://en.kioskea.net/forum/affich-206224-vba-to-delete-row-in-table http://en.kioskea.net/forum/affich-206182-report-in-required-format Hello, Sir, I am facing a sevier problem since from 4 years. I work for Commercial Taxes Department at Mahabubnagar district of Andhra Pradesh State of India 509001. The question is I have a defaulters list in 12 different sheets. The sheets are named as Apr-05, May-05, Jun-05, Jul-05, Aug-05, Sep-05, Oct-05, Nov-05, Dec-05, Jan-05, Feb-05 and Mar-05. Each of the sheet contains Tue, 24 Nov 2009 09:58:01 GMT http://en.kioskea.net/forum/affich-206182-report-in-required-format http://en.kioskea.net/forum/affich-205967-exele-sheetr Hello, DATA IMPORT INTO SQL QUERYENLIGER PAST DATE IN EXELE SHEET HOW TO CHANG DATE FORMTConfiguration: Windows XP Internet Explorer 6.0 Tue, 24 Nov 2009 04:54:01 GMT http://en.kioskea.net/forum/affich-205967-exele-sheetr http://en.kioskea.net/forum/affich-205943-copying-multipal-cell-text-to-one-single-cel Hello, i had entered data in excel now situation is come so that i have to have text in multiple cell of same column to be combined in single cell so that data with multiple rows and single column will become single row single column please help how to do it.Configuration: Windows XP Firefox 3.5.5 Tue, 24 Nov 2009 04:02:26 GMT http://en.kioskea.net/forum/affich-205943-copying-multipal-cell-text-to-one-single-cel http://en.kioskea.net/forum/affich-205926-counting-value-that-duplicate-data Hello All, I have trouble in VBA code that use for counting right cell that duplicate in left cell. Let i show you my data : A 5000 B 1000 A 1500 B 2000 The count of A should be result 6500 then B is 3000. Anyone can help with VBA code for this case. Thanks b4.Configuration: Windows XP Firefox 2.0.0.13 Tue, 24 Nov 2009 03:20:47 GMT http://en.kioskea.net/forum/affich-205926-counting-value-that-duplicate-data http://en.kioskea.net/forum/affich-205771-if-statement-in-excel-looking-for-text I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have either "pencil" or "eraser". Thanks in advance. xmtlr Mon, 23 Nov 2009 18:31:35 GMT http://en.kioskea.net/forum/affich-205771-if-statement-in-excel-looking-for-text http://en.kioskea.net/forum/affich-205690-auto-number-columns-based-on-an-input-cell Hello, I have problem. I want to be able to put a number into a cell, Number of weeks = X, and then have X drive the number of columns in a chart and label themselves. Ex, If number of weeks = 8, then automatically columns are numbered 1, 2, 3, 4, 5, etc. If I changed X, then I want the columns and labels to change too. Any ideas? Thanks in advance for the help!Configuration: Windows Vista Mon, 23 Nov 2009 15:40:35 GMT http://en.kioskea.net/forum/affich-205690-auto-number-columns-based-on-an-input-cell http://en.kioskea.net/forum/affich-205676-auto-filter-issues Hello, I am having issues with the auto filter in 2007 Excel. When I choose only certain information several other lines tend to hang on even though they do not meet the criteria of the filter. Example- I have a column that is only single letter identifier, I will choose to filter for A, and B but it brings up the some C's too. The C's are usually the last two to three lines of the spreadsheet Mon, 23 Nov 2009 15:11:55 GMT http://en.kioskea.net/forum/affich-205676-auto-filter-issues http://en.kioskea.net/forum/affich-205639-using-a-named-cell-in-a-macro-same-workbook Hello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sheet (which will be the active sheet) - any clues?Configuration: Windows XP Internet Explorer 6.0, excel 2003 Mon, 23 Nov 2009 14:17:46 GMT http://en.kioskea.net/forum/affich-205639-using-a-named-cell-in-a-macro-same-workbook http://en.kioskea.net/forum/affich-205614-excel-advanced-filter Hello, I have a problem with excel advanced filter. I want to use the advanced filter to this: Tasks, Resp., 1,2,3,4,1,2,3,4 Task 1, JJP , 1,1,1,1,0,0,0,0 Task 2, JJP , 0,0,0,0,1,1,1,1 Task 3, RH , 1,1,1,1,1,1,1,0 And use the critirion Resp.=JJP In return i get: Tasks, Resp., 1,2,3,4,1,2,3,4 Task 1, JJP , 1,1,1,1,1,1,1,1 Task 2, JJP , 0,0,0,0,0,0,0,0 I was hoping to get the Mon, 23 Nov 2009 13:40:15 GMT http://en.kioskea.net/forum/affich-205614-excel-advanced-filter http://en.kioskea.net/forum/affich-205543-when-to-use-if-iserror Hello, I am using excel since a long time now. I can also use if(iserror. However I want to know the technicality behind the same.Configuration: Windows XP Internet Explorer 6.0 Mon, 23 Nov 2009 11:43:23 GMT http://en.kioskea.net/forum/affich-205543-when-to-use-if-iserror http://en.kioskea.net/forum/affich-205453-face-book Hello, I have a problem with my facebook account.when im going to sign in they tell me that they will send me a mail.whats the mean of that?Configuration: Windows XP Internet Explorer 6.0 Mon, 23 Nov 2009 09:47:30 GMT http://en.kioskea.net/forum/affich-205453-face-book http://en.kioskea.net/forum/affich-205338-excel-formula-adding-point-to-answers Hello, Using excel 2000. I am creating a question which needs to creating points for answer. Cell A187 Example: What colour of car is expensive? Answer: blue, yellow, green. typing in formula in Cell A188 If a person type blue, Cell A2 will get 1. If a person type blue and green, Cell A2 will get 2 and so on. I have 2 codes for this cell but only managed to get 1 point. =IF( Mon, 23 Nov 2009 07:39:13 GMT http://en.kioskea.net/forum/affich-205338-excel-formula-adding-point-to-answers