You are here:
Excel/Questions Answered by Expert Adelaide carvalho
| Subject | Date Asked |
| Macro or Better Formula | 12/21/2011 |
| Q: I hope you are well and that you may be able to help with my problem. I have a spreadsheet to track ... A: How are you? Please try the following macro> Sub Macro1() Dim R As Range Y = InputBox("Please type ... | |
| How to use sum formula to sum values between dates | 12/8/2011 |
| Q: Can you provide the formula to SUM the values between two different dates, i.e: Example for ... A: How are you? I think you mean count instead of sum. If so just replace sum by count Assuming your ... | |
| excel macro | 11/12/2011 |
| Q: I am using excel 2000. My table contains column with A, A1 A2, A3.... I would like to create a macro ... A: How are you? Please do the following 1. Run the vba Editor 2. Insert module 3. Copy the code: Sub ... | |
| Macros, Forms, and Hassle | 11/10/2011 |
| Q: Hope you are well. I am writing for guidance on a little strange (Well strange for me) problem. At ... A: How are you? I am sorry but I cannot test your program. I had a look at it though. Please see the ... | |
| hold running | 10/22/2011 |
| Q: i want to hod my program when not enter the data. ex:-If cmbPayment.Text = "" Then MsgBox "Please ... A: How are you? Please have a look at the following code and adjust to your problem Sub ... | |
| custom function, "maxif" | 10/20/2011 |
| Q: and thanks in advance! assume i have data laid out as you see in the image. i have a formula that i ... A: How are you? Please see the following: R1 is the range A2:A10 e R2 is E2, then E3, then E4 Public ... | |
| Creating range names | 10/13/2011 |
| Q: I need to apply large number of range names (81) to each of a large number of existing excel ... A: How are you? Please have a look at: Sub RNtoWB() rncount = ActiveWorkbook.Names.Count Dim Rx ... | |
| Resize a range | 10/7/2011 |
| Q: I have client worksheets with dates starting in row 9 in column A. The macro selects the range where ... A: How are you? (wie geht es dir?) I know the following does nor do what you want, but it is easier to ... | |
| Excel | 10/5/2011 |
| Q: Sir, I have a query in excel. for e.g: I am using formulae in cells as follows. A1= ... A: How are you? Please do t5he following> 1. Type 11 in B1 2. Type = TAN(5*5*(1/10^2-1/B1^2)) in A1 3. ... | |
| Link code to sheet | 10/2/2011 |
| Q: in "txtDate.text" is equal to my one of sheet name.what is the code for activate that sheet with ... A: How are you? Please do the following 1. Draw a command button 2. Assign to it the following macro ... | |
| Exctracting string in cell | 9/28/2011 |
| Q: Currently I'm stuck to extract string in a cell, hope you can let me out. I got a list of string as ... A: How are you? Please write do the following: 1. Type your string in A14 2. Type in B14 ... | |
| formula dependent drop down lists | 7/18/2011 |
| Q: I have a table that lists specific categories in the first column and each have a code associated ... A: How are you? I do not think you can do this in Excel because you would have to use a circular ... | |
| VBA to Export Data | 6/13/2011 |
| Q: Hope you are well, I wondered if you might be able to help with a VBA problem I have. I've got a ... A: How are you? Please have a look at this. You still have to adjust to your problem Public Sub ... | |
| detecting duplicate entries in a worksheet | 6/1/2011 |
| Q: Can you please help me by suggesting a way (Macro or any other ) so that we can check for duplicate ... A: How are you? Please try the following: Sub highligtrept() Dim R As Range, c As Range Set R = ... | |
| To Compare two columns and find result | 5/30/2011 |
| Q: I want to match the two columns in 2 different worksheets , ie, Col A in sheet1 and Col A in sheet2 ... A: How are you? What about this? Sub prodload() Dim myprange As Range, Lrange Dim myprange1 As Range, ... | |
| To Compare two columns and find result | 5/25/2011 |
| Q: I want to match the two columns in 2 different worksheets , ie, Col A in sheet1 and Col A in sheet2 ... A: How are you? What about this Sub prodload() Dim myprange As Range, Lrange Dim myprange1 As Range, ... | |
| Flagging due dates | 5/18/2011 |
| Q: In my department we have a spreadsheet that we use to keep track of the harnesses that our engineers ... A: How are you? I am probably doing this too simple but please have a look at the following 1. Type ... | |
| How to write an Excel function: | 4/19/2011 |
| Q: How would I write an Excel function to determine whether "All" the work orders are confirmed or not? ... A: How are you? Please do the following: 1. Activate Programmer in the Menu Office button Options ... | |
| How to write an Excel function: | 4/16/2011 |
| Q: How would I write an Excel function to determine whether "All" the work orders are confirmed or not? ... A: How are you? Please do the following 1: Active Programmer in the 2007 Excel Menu 1.1. Press Office ... | |
| How to write an Excel function: | 4/15/2011 |
| Q: How would I write an Excel function to determine whether "All" the work orders are confirmed or not? ... A: How are you? What about this? Function AllConfirmed(R As Range) As Boolean Dim d As String, c As ... | |
| Copy word data in excel | 4/5/2011 |
| Q: i want to copy and convert the word data in excel column wise for example i have data like this ... A: How are you? Please see the following code Sub SentenceToCells() Dim R As Range Set R = ... | |
| excel problem | 3/31/2011 |
| Q: i have two workbooks in the first workbook first sheet there are some data in first column in some ... A: How are you? This is just for starting 1. Open the two workbooks (First and Second) 2. Type in A1 ... | |
| VBA 2003 loop trouble | 3/29/2011 |
| Q: Getting an error that I have a loop without a do, as far as I can see I have a do for my loop any ... A: I have just checked a few statements and the code seems fine. Please have a look at Sub ... | |
| creat sheet | 3/23/2011 |
| Q: I have an excel sheet in which employee names are in ascending order. What I would like to do is to ... A: How are you? Please start by trying the following vba code Sub Insertnewsheets() Dim R As Range, ... | |
| periodic sampling | 3/22/2011 |
| Q: I have a file in excel 2007 having more than 5000 records. i want to select the records with ... A: How are you? Please try the following vba program Sub samplingrecord() Dim R As Range, D As Range ... | |
| compare cells | 3/14/2011 |
| Q: Cell C1=1,D1=2,E1=3...N1=12 Cell C2=1,C3=2,C4=3,D2=4,D3=5,D5=6,E2=7,E3=8,E4=9...N2=34,N3=35,N4=36 ... A: How are you? The easiest way is to type in 1. the lower bound of each range in C5:N5 2. the ... | |
| Excel | 3/10/2011 |
| Q: I have a couple of lists that have about 800 clients. One list is of clients I prepared letters ... A: How are you? Yes, you can do this, but in order tio help you I need to knw which data tells a "old" ... | |
| Calculate school year group based on age | 3/9/2011 |
| Q: I think i need a vlookup but hope you can advise the best way to calculate the following: I need to ... A: How are you? Please try the following 0. Create the vertical table in G3:H7 Type 0, 4, 5, 6, 7 ... ... | |
| Excel Date help | 3/3/2011 |
| Q: I've two dates with time. I want to get date difference in hour and time with the help of formula ... A: How are you? Please try the following 1. Type date 1 in A2 and date 2 in B2 2. Type =A2-B2 in C2 ... | |
| Excel Macro | 2/22/2011 |
| Q: I have a problem i have 2 excel sheets like this a.xls it has columns like :- rollno name age and ... A: How are you? Please try the following small example 1. Type no and name in A1:B5 of A.xls 2. Save ... | |
| Running total | 2/11/2011 |
| Q: I have created 2 rows with 4 cells with same data in a excel sheet.(r1c1=14,r1c2=5,r1c3=4, ... A: How are you? If you want to try Excel macros, this is not difficult to do, you have to write a ... | |
| Critical Problem | 2/7/2011 |
| Q: sir, I have been dealing with a problem for long which I could not solve yet. please help me out. ... A: How are you? I have been trying the match and indirect functions to solve your problem. I have not ... | |
| detection absentee from mark table | 2/2/2011 |
| Q: i have to rate my students level of grading in different subjects. i can calculate there marks using ... A: How are you? Please try the following 1. Type the marks of the first student in A1:C1 10, 12, 14 ... | |
| Macro to select specific rows and copy to end worksheet | 2/1/2011 |
| Q: I need to extract just those lines that contain the combination of GL code (column G) and amount ... A: How are you? Please see this very first draft Sub finding() Dim ammount As Range, cod As Range, c ... | |
| VBA Macro won't run | 1/21/2011 |
| Q: I have a macro that won't seem to run, or be selectable from the list. In practise I would like it ... A: How are you? Please have a look at Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, ... | |
| Calculating a formula directly to a VBA variable | 1/16/2011 |
| Q: In Excel VBA, how can I create a variable with a calculation? Let me explain with an example. I ... A: .. Olá Como está? ((How are you?) Experimente por favor o seguinte código que tem 3 maneiras de ... | |
| Excel Macro | 1/14/2011 |
| Q: How to put more than one result or name in one cell using macro? A: How are you? Please have a look at the following code: Sub MorethanOne() Dim R As Range, T As ... | |
| Macro to auto subtotal | 12/28/2010 |
| Q: Do you have any suggestions on a macro that will automatically sum data within a column based on its ... A: How are you? What about the following Sub abovetiers() Dim R As Range, X As String, L As Integer ... | |
| If find and then copy & paste results | 12/27/2010 |
| Q: I was using a copy of a code that was done by Damon Ostrander, but he is on vacation so I was hoping ... A: How are you? What about the following below? Sub CopyBO() 'Copy cells of cols A,B from rows ... | |
| Formatting with formula | 12/2/2010 |
| Q: Is there any way to format a cell colour (background or text) based on the result of an IF function ... A: How are you? Please consider the following VBA code: Sub formattingwithFormula() Dim R As ... | |
| Question with formula | 11/24/2010 |
| Q: I'm hoping you can help me with my formula. I have a report template that pulls data from my ... A: How are you? =IF(C10="X",LOOKUP(B10,'[dailyam.xml]Table 1'!$D:$D,'[dailyam.xml]Table 1'!$A:$A),"") ... | |
| reg : how do i find a value next nearest value, | 11/22/2010 |
| Q: A B C D 360 1528 146 2614 My question, A-360, and i want to bring out that its next nearest value ... A: How are you? Please try the following 1. Type A B C D 360 1528 146 2614 in B8:C11 2. Type B in B14 ... | |
| Changing Tab Reference In a SUMIF | 11/4/2010 |
| Q: I am trying to make a sumif formula reference different tabs when I copy down. Each tab is ... A: How are you? Please start to try the following then I think you can adjust to the sumif: 1. Type ... | |
| Excel Table Results | 10/6/2010 |
| Q: I have a table (roster) in its simplest form, there are four columns and four rows. ... A: How are you? Please extend the following code to all the tasks. Sub TASKS() Dim r As Range, FIRST, ... | |
| find/replace | 10/5/2010 |
| Q: pls help me on this. i have a code here and i paste the code follwed this text.. Sub ... A: How are you? Please Have a look at the following: Dim wks As Worksheet, nNum As String nNum = ... | |
| formular to work out a % | 6/18/2010 |
| Q: The item is 150 and the amount we want to charge is 50 what formular would we use to find the ... A: How ae you? Please do the following: 1. Type 65%, 66%, 67% in A1:A3 2. Type 52,5, 51, 49,5 in B1:B3 ... | |
| VBA Loop | 6/9/2010 |
| Q: Could you please assist me with the below? I am looking to get this function to loop until ... A: How are you? Please try something like: Sub whilegroups() GROUPNUMSS = 1 GroupNummF = 3 Do ... | |
| rows repeat | 6/7/2010 |
| Q: I have N number of link name in column A, I need each link to repeated 64 times with numbering 1-64 ... A: How are? Please have a look at the following vba code: Sub repetingLinks() Dim Inrange As Range, ... | |
| comparar colunas | 5/24/2010 |
| Q: Boa tarde, estou com dificuldade em copmparar valores de duas colunas. Basicamente sao valores de ... A: How are you? I wonder whether I´ve inderstood your question. Please, try to use the Vlookup ... | |
| VBA Query | 5/21/2010 |
| Q: I am looking to write a macro which match each value from sheet1 column B to Sheet2 column B. If ... A: How are you? Please have a look at Sub Matching() Dim R1 As Range, R2 As Range, i As Integer Set R1 ... | |
| Incrementing a formula | 4/13/2010 |
| Q: I want to have formulas in the rows like below A10 = A1 + B1, B10 = C1 + D1 , C10 = E1 + F1 ... A: How are you? The easiest way is to type your formula in B1, D1, F1, i.e., type in B1 and copy to the ... | |
| How to copy specific rows on another workbook | 4/12/2010 |
| Q: How do I copy data from all the workbooks in the folder onto workbook 1 into it's corresponding row ... A: How are you? Please try the following 1. Open the 2 workbooks 2. View them in the screen at the same ... | |
| If Statment | 4/9/2010 |
| Q: I am trying to pull information from a sheet "raw" I want to know if(K2 is not "A", vlookup(column D ... A: How are you? I wonder if I have understood what you mean, but please try the following: 1. Type in ... | |
| VBA | 3/25/2010 |
| Q: Ola Adelaide,tudo bem? :) Estou a criar um codigo para exportar uns graficos de excel para word. ... A: Como está? /How are you? Tente por favor / Please try the following Sub PasteToWord() Dim a, b, c, ... | |
| Formula to split text into separate cells | 3/19/2010 |
| Q: I have a cell that contains text over 1200 characters long. I need to cut the text into multiple ... A: How are you? I am tempted to suggest to you something you can control better. Assume your text data ... | |
| Creating Multiple Checkboxes in Excel | 3/4/2010 |
| Q: I saw a thread you responded to where you wrote some code to create checkboxes. It was as follows: ... A: How are you? This code aims to link checkboxes, spinbuttons, etc. to successive cells To run it ... | |
| Simple VBA... | 2/26/2010 |
| Q: I hope this will be simple for you but I'm very new to VBA so it's not for me!! I have a column ... A: How are you? What about this Sub NAErrors() Dim R As Range Set R = ActiveSheet.Range("G6:G26") For ... | |
| Simple VBA... | 2/19/2010 |
| Q: I hope this will be simple for you but I'm very new to VBA so it's not for me!! I have a column ... A: How are you? Please have a look at Sub NAErrors() Dim R As Range Set R = ... | |
| Column to rows with criteria | 2/15/2010 |
| Q: Good afternoon. I would like to Convert long colunm to rows with a criteria: if in column A is ... A: How are you? This can be either simple or very complicated. The simplest way is to write in column ... | |
| Excel 2007 shape fill colour problem | 2/12/2010 |
| Q: I have a generic VBA routine that adds a specified shape to each cell within a target range on a ... A: How are you? I do not have Excel 2007 anymore. I've tried this with 2010. I changed the code and ... | |
| Pictures in XL | 2/5/2010 |
| Q: I'm working on a tool that makes it possible to select a item number by making several selections. ... A: How are you? If you are familiar with Macros (VBA for Excel), please do the following: 1. Run the ... | |
| calendar in excel | 2/4/2010 |
| Q: i have a calendar userform in excel.When I click on a particular date on the calendar,a specific ... A: How are you? This is not the solution for your problem, but I hope it helps. 1. After opressing the ... | |
| How to link sheets and values and if statements together | 1/31/2010 |
| Q: I need to construct an IF statement (or perhaps a lookup I am not sure)that will give a value..I ... A: How are you? I am not sure wheter I have exactly understood the problem. I hope the following helps ... | |
| Multiple rows into columns. | 12/19/2009 |
| Q: I am looking for a macros or anything that can help me combine rows in excel. Allow me to ... A: How are you? Please have a look at Sub mergingcells() Dim Rin As Range, rour As Range Dim i, j, ai ... | |
| Password protect cell editing | 11/7/2009 |
| Q: :) Please look at this post before trying to answer my question. ... A: How are you? Yes it is possible. Please see the following for Excel 2007. But similar way for Excel ... | |
| Please Help Me with a Macro | 10/29/2009 |
| Q: I have an Excel Sheet named "Sample Export". if we are getting the word" Data not matching" in the ... A: How are you? Please see the following Option Base 1 Sub copying() Rem On Error Resume Next Const ... | |
| Excel | 10/27/2009 |
| Q: "Excel 2004, Mac 10.6.1 My speed in minutes per mile: Distance (4.25) / Time (60) = 14.12 (in F25) ... A: How are you? How many miles do you run)? in how many minutes? 4.25/60 is the number of miles per ... | |
| Macro to insert date | 10/23/2009 |
| Q: I want a macro that will insert date of last month (mm/yy) by taking the current date from the ... A: How are you? Please see below Sub LastMonth() Dim R As Range, F As Date, F1 As Date Set R = ... | |
| Auto numbering Macro | 10/15/2009 |
| Q: I have the sheet: WBS&Action&Planning (see appendix) and using Excel2007 For numbering the actions ... A: How are you? This formula is fine. But, if you inset a row in, e.g. A23, this new cell doest not ... | |
| Multiple if statements to count items that meet two criteria | 10/12/2009 |
| Q: I have a sheet with data I need to analyse by areas of a city. In column A, I have postcodes (BD1, ... A: Ho Dean How are you? Excel 2007 has the function Countifs do this If you are familiar with VBA, ... | |
| VBA FOR AUTO-FILL | 10/11/2009 |
| Q: Can you please help me with a couple of VBA scripts. I would like a VBA script which will autofill ... A: How are you? Please try the following Sub autofilling() Dim R As Range, C As Range Set R = ... | |
| for next with condition | 10/10/2009 |
| Q: I am trying to put together one macro... but I have a problem where I do not see the solution with ... A: How are you? The VBA code for this is someyhing like Sub coppying() Dim R As Range, D As Range, J ... | |
| VBA IF STATEMENT | 10/8/2009 |
| Q: Adelaide, cool name by the way. I am using excel 2000 version. Can you please help with the ... A: !! How are you? Yes, I knew immediately you were from Australia ... Thank you, but I believe the ... | |
| "COUNTIF" technique | 7/21/2009 |
| Q: i have an excel sheet of a survey that i just did in the company where the survey is a question with ... A: How are you? There must be a more efficient solution, but the following just came to my mind. 1. ... | |
| Excel invoice | 7/17/2009 |
| Q: I created an invoice;from code,catalogue data,customer details,description,unit price.(all vertical ... A: How are you? Please try the following, then ask again :-) Suppose you have the qauntities in D2:D10 ... | |
| Formulário | 7/14/2009 |
| Q: Adelaide, como percebi que você é de Portugal, estou escrevendo em Português. Estou aprendendo VBA ... A: Olá, Italo! Como está? Sim Sou Portuguesa e vivo actualmente em Portugal. De que estado do Brasil é? ... | |
| An Alternative Formula for Office 2003 | 7/11/2009 |
| Q: I've been playing around with data on my 2008 MAC version excel. In some parts of the spreadsheet, ... A: How are you? For Excel 2007, it is exactly the same =AverageIf(A5:A35,"=*Tuesday", B5:B35) I have ... | |
| qu | 7/9/2009 |
| Q: someone showed me how to call up a dialogue box which showed you what columns were hidden in a ... A: How are you? I am 99% sure that such a feature is not built in Excel 2003. You should have seen a ... | |
| Regarding Macros | 6/29/2009 |
| Q: A7 61B C7 A8 61B C8 A9 61B C9 A10 71C C10 A11 71C C11 A12 71C C12 Sample Data What i want: The ... A: How arte you? What about the following Option Explicit Sub InsertingRows() Dim R As Range, enc As ... | |
| To Remove Hyperlinks | 6/25/2009 |
| Q: I have an excel sheet. Column L has hyperlinks and display text is "Form". Column E has dates. I ... A: How are you? This is not the fully solution to your problem. But I hope it helps you. Sub ... | |
| Summary Report | 6/24/2009 |
| Q: I have a excel sheet which a lot of data in many columns and rows. In column A therez some data ... A: How are you? Please have a look at Public Function findchanges() Dim R As Range, c As Integer, cel ... | |
| If-Then macro | 6/21/2009 |
| Q: I need a macro for - if the cell in column D is empty, delete row and shift cells up. Thanks! A: How are you? Please have a look at Sub deleteRows() Dim R As Range, C As Range Set R = ... | |
| Find misplaced digits or decimal points | 6/17/2009 |
| Q: Currently, if a cashier is out of balance, then we perform a manual process of trying to identify ... A: How are you? This depends on how far you want to automate the checking process. E.g. You can detect ... | |
| Question in Excel | 6/16/2009 |
| Q: I have a excel sheet containing one cloumn and 20 rows like below: 1 2 3 4 5 6 7 8 9 18 19 20 21 22 ... A: How are you? Please do the following 1. Tools - Macro - Visual Basic Editor (for Excel 2003). In ... | |
| Question in Excel | 6/15/2009 |
| Q: I have a excel sheet containing one cloumn and 20 rows like below: 1 2 3 4 5 6 7 8 9 18 19 20 21 22 ... A: How are you? I wonder whether you are familiar with VBA. I wrote this function that accomplish what ... | |
| If Formula | 6/10/2009 |
| Q: I have about 20 conditions in one situation , I want to use if formula , but I fail to use it more ... A: How are you? I think that there only is two solutions: Either you write a VBA procedure to compute ... | |
| Checkbox question | 6/6/2009 |
| Q: On sheet1 I want to have a checkbox1 that when checked makes a Label1 visable on Sheet2. I can do ... A: How are you? I used controls to do this 1. Insert a checkbox control on Sheet1 2. Insert a Label ... | |
| Sorting Data | 6/5/2009 |
| Q: I have a sheet that I created that calculates data for a group of surveys received by a team. I have ... A: How are you? There should be no problem with that. 1. Select the range - all columns and rows - you ... | |
| Color count | 6/4/2009 |
| Q: Is it possible to get the count of cells colored in yellow in a sheet as a Msgbox using a macro. ... A: How are you? Please do the following 1. Run the Visual Basic Editor 2. Insert - Module 3. Copy the ... | |
| sequential numbering | 6/1/2009 |
| Q: I am trying to create a job card system. That when the next person goes into the file they will ... A: How are you? I think that you should start it simple. For example Whenever you write a name in A2, ... | |
| headers | 5/30/2009 |
| Q: if so how can i do this? Example... a1 - Name a2 - date, a3 - function. this way every page ... A: How are you? Yes, you can set the first row as a header for each printed page. You caqn find how ... | |
| Cell reference | 5/27/2009 |
| Q: I am trying to use the content of a cell as the cell number to get data from. =INDIRECT("D"&$D$57) ... A: How are you? Please try the following: 1. Assume your data is in D6 of Sheet1 2. Type in DD57 of ... | |
| How to write a formula | 5/25/2009 |
| Q: Please help with writing this formula.It is used to calculate grams of pure gold from a gold bar. PS ... A: How are you? Please do the following Type 1. PS in A1 2. PH in B1 3. Factor 1 in C1 4. Factor 2 in ... | |
| Cell Changes in other spreadsheets. | 5/18/2009 |
| Q: I posted a query and regrettably made it too simple. My query was : is it possible to change, for ... A: How are you? Yes, you can do that. If, for instance, you want B24 of sheet2 reflect any change of ... | |
| how to use excel formula | 5/10/2009 |
| Q: I am facing a difficulty in using formulas of excel. I have a given table having numbers. I want fin ... A: How are you? Please try the following: 1. Type the limits of your intervals in A1:A20 2. Type ... | |
| VBA code - *.txt files content to transfer to xls | 5/9/2009 |
| Q: Sir, I have one folder containing 10 Nos. *.txt logs generated by system. what I normally do is ... A: How are you? I have not run your code but what about the following: Sub copy_text_files() Dim ... | |
| time change in multiple cells based on drop down event | 5/6/2009 |
| Q: I'm very new to the intermediate parts of excel. I've put together a scheduling document using excel ... A: How are you? This is an interesting question !! Work this out step by step 1. Type in A3 ... | |
| check for highlight cells | 5/1/2009 |
| Q: i wish you cud help me with this query. i want to know how do this logic in msexcel 07. the logic is ... A: How are you? I wonder how familiar you are with VBA. Anyway, please have a look at 1. Run the VBA ... | |
| VB macro issue | 4/19/2009 |
| Q: I was creating a macro and got stucked somewhere. Every month i have to insert a formula (additon) ... A: How are you? Please see a demonstration of the use of selection end Sub insertformula() Dim R As ... | |
| find the top 5 quantity of product sold | 4/16/2009 |
| Q: In my excel file, row one is the names of the various product code sold eg. A1,A2.... Row 2 are the ... A: How are you? You can use the function Largest(range, K), i.e. If you have 6 products - names in ... | |
| Page break | 4/9/2009 |
| Q: I have selected and option that I can't remember any more. It has divided my page into four parts. I ... A: How are you? This depends on your Excel version. You have to explore the menu Windows. In Excel ... | |
| CELL CHANGING | 4/8/2009 |
| Q: 1) How do I transpose cells from horizontal to vertical? I have say : 1 2 3 4 5 6 7 8 9 9 9 9 and ... A: How are you? Firstyou can use the transpose function: 1. select 4 cells in a column 2. Type ... | |
| MS Excel | 4/7/2009 |
| Q: I would like to set the cell background or shading to an RGB setting. I realize this can be done ... A: How are you? Please try the following 1. Type your numbers in a1, b1 and c1 2. Run the Visual Basic ... | |
| excel formula to convert min:sec to seconds | 4/1/2009 |
| Q: I am trying to do two things on excel: 1. Format a cell to display "min:secs" ie. 7:30 (seven mins ... A: How are you? Please do the following: 1. Type the time 7:30:00 in A3 2. Select A3 3. Format- Format ... | |
| Excel Matching | 3/31/2009 |
| Q: I'm trying to create a macro that would match a number in one row and bring up the name on the row ... A: How are you? Please try the following 1. Type 1 in A1 2. Type in B1 ="Product "&CARÁCT(A1+64) The ... | |
| Creating a variable that would make it easier for the macros | 3/30/2009 |
| Q: I have recorded a macro that basically drag downs cell (with validation) into a "x" amount of rows. ... A: How are you? What about this? Sub Drop_Down() ActiveSheet.Unprotect Password:="1234" ' ' Drop_Down ... | |
| Finding number of characters in a cell and... | 3/26/2009 |
| Q: Please help me!!! It will be very helpful for me in my daily work.... I have an excel sheet and all ... A: How are you? Please do as following: 1. Run Visual Basic editor (it depends on the Excel version.( ... | |
| Determining the existence of a sheet in a workbook | 3/23/2009 |
| Q: I have a problem regarding my macro. I want to put a code statement that would look if a certain ... A: How are you? Please have a look at the following code which should preceed Dim i as Range of your ... | |
| Excel formula/ UDF | 3/18/2009 |
| Q: Is there any formula that gives me the closest value to my desired value. For example My desired ... A: How are you? I do not know any function for that. You may want to have a look at the list of ... | |
| Excel | 3/17/2009 |
| Q: I need help in Excel. here's my problem: let's say I have something to do on 10 July 2009. Is there ... A: How are you? Please do the following 1. Type in A1 =today() 2. Type in B1 10-07-09 3. Type in C1 ... | |
| Excel VB | 3/11/2009 |
| Q: I am trying to identify a cell 'First Placement' and a cell in the same column 'Last Placement'. I ... A: How are you? What about the following: Sub test() Dim FirstP As Range, LastP As Range, WaRange As ... | |
| excel file | 3/7/2009 |
| Q: I need to find the minimum or smallest # in a column that is not zero. Min will not do it and small ... A: How are you? That is an interestingit seems easy but it is not. I have btried the following 1. ... | |
| Colour AutoSUM | 3/6/2009 |
| Q: I am using a spreadsheet where rows F3:F233 have values in and are either one of eight colors. At ... A: How are you? This is event driven programming: Your formula has to be recalculate whenever the ... | |
| Vlookup | 3/4/2009 |
| Q: How can i lookup when both the datas are not identical For Eg: Berthold Technologies GmbH & Co. and ... A: How are you? I think that if you write on the table just Berthold, the vlookup function looks for ... | |
| Multiple check boxes | 2/22/2009 |
| Q: I have create a check box which gives the cell a value of true when ticked. However when I drag the ... A: How are you? Please see the following code Sub checckboxes() Dim c As Shape, s As Worksheet, L Set ... | |
| Multiple check boxes | 2/21/2009 |
| Q: I have create a check box which gives the cell a value of true when ticked. However when I drag the ... A: How are you? If you wanted to do this just for one checkbox, I would suggest the following: 1. ... | |
| How to calculating this date to this date | 2/9/2009 |
| Q: 30-01-2003 to 31-11-2008 = 5Years, 10Months, 1Day how above type of experence callculating ... A: How are you? Please do the following 1. type in A1 30-11-2008 (there is no 31st in November :-) 2. ... | |
| Delete all objects in a workbook simultaneously | 1/30/2009 |
| Q: I have many spreadsheets in one workbook and need to delete all objects on each sheet in that ... A: How are you? What about the following vba code Sub deleting() Dim F As Worksheet, S As Shape For ... | |
| Add Delete Modify | 1/29/2009 |
| Q: From last many years in my company, all the employees still using excel and bcos of it there is lots ... A: How are you? Please have a look at the following example that writes the name read in textBox1 of ... | |
| consecutive blank cell count | 1/25/2009 |
| Q: PLEASE FIRST TRY TO UNDERSTAND WHAT I AM LOOKING FOR. YOU HELP WILL BE GREATLY APPRECIATED. I need ... A: How are you? The following does not anwer your question but it may help you. Sub ... | |
| Automatic Display of Text | 1/23/2009 |
| Q: I am trying to design a spreadsheet where a user can enter a code into a cell (i.e., 123) and from ... A: How are you? Please do the folowing: 1. Type in A1:A10 of sheet2 the codes by ascending order 2. ... | |
| Macro to hide rows. | 1/22/2009 |
| Q: I have a sheet in excel with about 50 columns. As you can understand it is now very printer ... A: How are you? Please have a look at Sub hidingcol() Dim R As Range, c As Range Set R = ... | |
| Selecting multiple sheets - Thanks!! | 1/19/2009 |
| Q: I have a macro that suppresses rows with "0's in column P of "sheet1" where I place it. I need to ... A: How are you? What about this Sub Macro1() Dim s As Worksheet, cell As Range For Each s In ... | |
| conditional lookup problem | 1/18/2009 |
| Q: I am facing a terrible problem in linking two sheet using vlookup that requires some condition as ... A: How are you? There may be a easier and more effective solution, but the only I can think now is to ... | |
| Tab direction... | 1/17/2009 |
| Q: I recently came across your Macros Module to make the tab key move down a column instead of across ... A: How are you? This does not solve your problem, but please have a look at Sub GODOWN() Dim A As ... | |
| Excel VBA - Lock project for viewing | 1/13/2009 |
| Q: I've developed an Excel sheet with some extensive macros, which I would like to protect via the ... A: How are you? I think the best solution is to join all the macros in an add-in which will be ... | |
| vba for excel inheritance | 1/12/2009 |
| Q: Does vba support inheritance for its classes. If so how do you declare this in the subclass. Many ... A: How are you? No, VBA does not support inheritance for user defined classes. However, it does ... | |
| Excel (VBA) | 1/8/2009 |
| Q: I am trying to write some VBA code (Excel) that loops through a series of files and extracts the ... A: How are you? I know this does not answer your quetion but it can be a good start: Sub Logos() Dim ... | |
| Conditional Formatting | 1/5/2009 |
| Q: I wish to apply conditional formatting to a range of cells e.g. B3:H7. I already have conditional ... A: How are you? If you know how to use VBA for Excel, please have a look at: Sub CondFormatting() Dim ... | |
| Use of If Function | 1/2/2009 |
| Q: I wanna use a range formula for calculations for example in excel sheet... I have 5 values and their ... A: How are you? Please do as following 1. Type numbers you want to sium up in A1:A5 2. Type in A6 ... | |
| Conditional sum | 12/18/2008 |
| Q: for example, in cell A1 type 30+40 (not "=30+40") so that it appears "30+40" instead of "70". Now, ... A: How are you? What about the following 1. Type in B1 =Mid(A1,1,2) 2. Type in C1 =Mid(A1,4,2) 3. Type ... | |
| Custom data validation too manual | 12/14/2008 |
| Q: I would like the users when entering a new product to use a unique number. I have come up with ... A: How are you? Please have a look at the following: 1. for excel 2003 Tools-macros- VBA editor Or ... | |
| macro subroutine | 12/12/2008 |
| Q: i am novice in vba and intersested to develop further.i have seen sample program which contains ... A: BHASKAR SELVEN How are you? Sub blankrows(list of parameters) is a procedure which is called from ... | |
| Pass, Fail | 12/9/2008 |
| Q: i want vb code for following situation.There is two text boxes.one is Student marks ( txtmarks ... A: How are you? Please do the following: 1. Insert a UserForn 2. Place the two textboxes and a ... | |
| Find not working consistently after using in macro | 12/7/2008 |
| Q: I have noticed that when I do Edit > Find in Excel 2003 at some point in the same session after I've ... A: How arte you? Please try the following and adjust to your problem: Sub ggg() Dim C As Range, D As ... | |
| Excel Macro | 12/6/2008 |
| Q: I have written a macro for a spreadsheet which eventually has to transfer data to another ... A: How are you? Please have a look at: Sub aaa() Dim R1 As Range, R2 As Range Application.CutCopyMode ... | |
| Filenames & dates from WinEx to Excel | 12/5/2008 |
| Q: I am running Office 2000 in Win XP Pro. I found your earlier macro to transfer filenames, but can't ... A: How are you? Please have a look at Sub AllFilenames() Rem Change D: to your folder path D = "C:\" ... | |
| vba solution | 11/30/2008 |
| Q: i want a macro with under mentioned options. 1. range a1 to a10 contains same data 2. range a11 to ... A: How are you? Please have a look at Sub deleteduplicates() Dim R As Range, I As Integer, J As ... | |
| "UnMerge" Titles | 11/21/2008 |
| Q: I'm using Excel 2003 and am somewhat experienced in VBA. My program reads in a workbook which can be ... A: How are you? To unmerge the headings, just do this Sub unmergetitles() Range("A6:F6").Select ... | |
| Return all occurrences | 11/20/2008 |
| Q: I have column "A" which is my number line (row) reference and starts at position "A3". I have ... A: How are you? Please do the following if you have Excel 2003 0. Write your data (line and vehicles) ... | |
| Return all occurrences | 11/16/2008 |
| Q: I have column "A" which is my number line (row) reference and starts at position "A3". I have ... A: How are you? Please try the following example 1. Tools - macros-Visual Basic Editor 2. Insert ... | |
| filtering | 11/13/2008 |
| Q: I HAVE A QUESTTION ABOUT FILTERING IN EXCEL. I HAVE 3 SHEETS THAT HAVE ONE COMMON COLUMN(A) WHICH ... A: How are you? How is the following code Sub FILTER_ABS() ' ' FILTER_ABS Macro ' FILTERING Dim s As ... | |
| Auto Wrap Text. | 11/11/2008 |
| Q: Good Morning. Our office is having a problem with a spreadsheet we created in excel. Our cells ... A: How are you? I have tried the following on Excel 2007 and apparently it works: 1. Select the cells ... | |
| permutations | 11/3/2008 |
| Q: I have 5 dishes to make: 1 with meat, and 4 with eggs. To avoid cross contamination when I change ... A: How are you? Please see the function Permut and Combin. If you have just one dish of meat you can ... | |
| Auto Update in excel from site | 10/31/2008 |
| Q: I have grab the values from a website in my 2-3 columns in excel sheet and it keeps on changing ... A: How are you? Indeed this works whenever you change the data directly on the sheet. If the data ... | |
| Auto Update in excel from site | 10/30/2008 |
| Q: I have grab the values from a website in my 2-3 columns in excel sheet and it keeps on changing ... A: How are you? Assumming your data is transferred from the web to columns A and B of sheet2, please ... | |
| visual basic | 10/29/2008 |
| Q: I have been trying to build a macro that evaluates different lines of excel and then gives me a ... A: How are you? I do not know what you are trying to get but please have a look at the following ... | |
| Question | 10/23/2008 |
| Q: How to change the font color of the ceel's data by using formula? A: How are you? I do not know of there osw a funtion for that. But you can do it with a small macro ... | |
| Length Auto Chop | 10/22/2008 |
| Q: I have an excel sheet with 2 columns. One column contains sentences while the second column contains ... A: How are you? Please try the following: Sub ShorteningSentences() Dim R As Range, I As Integer ... | |
| vlookup in macro... | 10/19/2008 |
| Q: I need to use a vlookup to compare 2 lists during a macro. The number of columns in the lookup ... A: How are you? This may help you: 1. Type the table in E1:F10 2. Type the values to look up in A1:A3 ... | |
| formula for employee hours in and out | 10/12/2008 |
| Q: please sent me the formula to calculate hour ex in at 8 out at 5 how many hours work per day ... A: How are you? Your problem is that you typed 1700 (the one thousand seven hundredth hour). You have ... | |
| excel comparision | 10/9/2008 |
| Q: how r u doin? Here is a piece of code. what I am doin here is getting an input value for ... A: How are you? This is an answer to a very small part of your question ... but I hope it helps> 1. ... | |
| Write a Marco | 10/7/2008 |
| Q: I want to write a Marco for the following function: To mark the staff between General Holiday and ... A: How are you? I wonder if you can twist the following example to do what you want: Sub Holidays() ... | |
| EXCEL creating commandbutton | 10/6/2008 |
| Q: I have some problem when creating a program in excel. i want to create a command button ... A: How are you? Please do the following 1. activate the reference to Microsoft visual basici ... | |
| instr / vlookup (?) | 10/3/2008 |
| Q: I have coloumn containing data. Say I'm looking for the word "excel" in any combination in this ... A: How are you? What about this: =If(IsError(Locate($F$38;A37;1))<>True;$G$38;"") F38 contains Excel ... | |
| to chk max min values by vba | 10/2/2008 |
| Q: i am working on a project which currently requires checking of values. I have 2 excel files. what i ... A: How are you? What about this? 1st.Open the 2 workbooks 2nd Run the following Sub MinMaxi() Dim a ... | |
| Vlookup help | 10/1/2008 |
| Q: I get to know a worker's proficiency value say 22.5, for this I need to know the approximate ... A: How are you? Your data table has to be set in 2 or more columns: the first is the Lower bound of ... | |
| Problem with VBA | 9/23/2008 |
| Q: I am a starter in VBA. It may look like a silly question to you. ... A: How are you? There are standard modules where you write VBA code that works for each sheet and ... | |
| VB Script for drawing charts in Excel | 9/20/2008 |
| Q: I am using Microsoft Excel 2007. I want to draw a XY-Scatter chart with VB Script internal to Excel. ... A: How are you? Please have a look at Sub ColouringChartLine() Dim S As ChartObject, Se As Series Set ... | |
| Excel macro to copy cells from one workbook to an existing workbook. | 9/19/2008 |
| Q: I have a proposal process that has multiple stages that are covered in a single workbook on multiple ... A: How are you? I'd suggest you to do it step by step. 1st write a macro to copy data from one sheet ... | |
| Employees on the book | 9/17/2008 |
| Q: I need to show how many employees I have employed in the following years 2006, 2007, 2008. So ... A: How are you> Please do the following Assuming your data is in A1:C5> 1. Add a column =Year(B2) 2. ... | |
| MULTIPLE VLOOKUP | 9/10/2008 |
| Q: Scenario 1 A B 1 Name Marks 2 Amir 25 3 Bobby 63 4 Charlie 45 5 Don 95 6 Eliyaas 75 ... A: How are you? Can it be something like: ... | |
| Display Specific Data filtered by Date and Time | 7/26/2008 |
| Q: I have a huge list of data in my Excel and I would like it to display only the specific data which ... A: How are you? Please try thev following> 1. I assume that your date and time are in cell A1 2. ... | |
| Display Specific Data filtered by Date and Time | 7/25/2008 |
| Q: I have a huge list of data in my Excel and I would like it to display only the specific data which ... A: How are you? You can use the data - advanced filter features. I cannot tell you exactly because ... | |
| sub within a sub | 7/23/2008 |
| Q: Adelaide, I want a certain sub (AE_transpose) to run everytime the worksheet "pivot_progression" is ... A: How are you? Please have a look at Private Sub Workbook_SheetActivate(ByVal Sh As Object) If ... | |
| Is there a way for excel to differentiate two numbers with the same value but diiferent color? | 7/22/2008 |
| Q: I am trying to get excel to differentiate between a cell containing 35(grey) 36(red) 37(red) and a ... A: I do not find a way of doing it without a vba program. If you know how to edit and run a vba ... | |
| Conditional formatting using macros or any other possible ways | 7/14/2008 |
| Q: I would like to know, how can we apply more than three conditions in a cell. Kindly let me know as ... A: How are you? The code to do that is something like Sub condformatting() Const RFT = 10, RCT = 5 Dim ... | |
| Conditional formatting using macros or any other possible ways | 7/11/2008 |
| Q: I would like to know, how can we apply more than three conditions in a cell. Kindly let me know as ... A: How are you? You can use If conditions in several ways. E.g. =If(A1>10,"aa",if( ... | |
| source | 7/10/2008 |
| Q: were is the source for macros located in spreadsheet documnet in excel? A: How are you? If you have the 2003 version for Excel, please do the following 1. Tools - macro - ... | |
| Two different conditional formats | 7/7/2008 |
| Q: this is an Excel conditional format related question. I have constructed a checkbook register of ... A: How are you? What about joining the 2 conditions into one =And(Iserror(B:B)=True, Mod(Row(),2)=1 ) ... | |
| VBA -code to go to last blank cell | 7/5/2008 |
| Q: I wonder if you can help me. I have list of data in column A. I want to write a VBA code that makes ... A: How are you? Is it to locate the data that follows an empty cell? Please see the following: Sub ... | |
| Retrieval of data from multiple sheet to one sheet | 7/4/2008 |
| Q: I need to do some huge task in excel wherein i have some doubts. In a Excel file, i have more ... A: How are you? If the problem is not have a function for retrieving the name of the sheet, you can ... | |
| Excel query? | 7/3/2008 |
| Q: I would like to know if it is possible to insert a formula to display today's date into, say, cell ... A: How are you? Please try the following 1. tools-macro-macros 2. view - project explorer 3. click ... | |
| Insert a row by clicking on a button | 7/1/2008 |
| Q: How do you insert rows by clicking a button in that row? Because the activecell isn't the one ... A: How are you? Please try the following 1. Draw the button on sheet1 2. Tools - macro - visual basic ... | |
| Excel VBA | 6/24/2008 |
| Q: I need to call another program through Excel VBA (macro) and to navigate through the new programs ... A: How are you? I wonder if the following helps 1. Tools - macro - visual basic editor 2. Inser module ... | |
| Wildcard Sheet Selection | 6/23/2008 |
| Q: Adelaide, First off I appreciate you putting you time and effort into this website. Currently I ... A: How are you? Please try to insert the following in your code Sub openingafile() Dim Wb As ... | |
| excel time | 6/20/2008 |
| Q: How do I get excel to know if a time that is typed in a cell is am or PM. To my understanding there ... A: How are you? Sorry if I make it too simple, but why don't you type 09:00:00 AM or 09:00:00 PM ... | |
| Excel formula | 6/13/2008 |
| Q: I will state this with an example: suppose i assign values to alphabets Eg: A=2, B=3, c=4, D=2...., ... A: How are you? A macro would do this better, but please try the following: 1. Type 1,2, 3 in A3:A5 ... | |
| excel | 6/8/2008 |
| Q: I'm looking for a formula that will return all the different dates entered into a spreadsheet. i.e. ... A: How are you? The following code, solves part of your problem: Sub enteredDates() Dim R As Range, c ... | |
| excel | 6/7/2008 |
| Q: I'm looking for a formula that will return all the different dates entered into a spreadsheet. i.e. ... A: How are you? I wonder whether you are familiar with vba. If you do, thry the following procedure ... | |
| Excel formula | 5/26/2008 |
| Q: I'm looking for a way to automatically insert a row, when data is entered into a particular cell. ... A: How are you? Please copy to the code module of Sheet1 the following Private Sub ... | |
| Sort Columns Numerically | 5/25/2008 |
| Q: I am writing an excel VB macro that sorts columns based on the header column title ("DEVICE") and ... A: How are you? Please try the following: Sub sorttingDevice() Dim scancolumn As Integer, c As ... | |
| Updating with new information into different sheet | 5/17/2008 |
| Q: I have a data input Sheet say sheet1. I also have a database in sheet2. By doing a vlookup I can ... A: How are you? Please try the following example 1. On Sheet1, A1, type 100 2. On sheet2, type in ... | |
| Excel macro that highlights search results in a different color each time | 5/15/2008 |
| Q: I am trying to write a macro that searches a particular value in a certain column (say VIA column). ... A: How are you? Please have a look at the following code and then expand it for a second search Sub ... | |
| RE: code for closing an excel file without saving it (go through the code) | 5/14/2008 |
| Q: I have developed some code for Excel application through which i am going to create an excel ... A: How are you? I can suggest you to do the following 1. Turn off the display alerts for skipping the ... | |
| MsgBox reflecting Work sheet name | 5/12/2008 |
| Q: I was using an simple Macro posted on your webpage; Sub Count2() mycount = Application.Sheets.Count ... A: How are you? Please do the following 1.Tools- Macro - Visual Basic Editor 2. View - Project ... | |
| MsgBox reflecting Work sheet name | 5/11/2008 |
| Q: I was using an simple Macro posted on your webpage; Sub Count2() mycount = Application.Sheets.Count ... A: How are you? What about the following Sub Count2() Dim I As Integer, mycount As String For I = 1 To ... | |
| Deleting Multiple Rows | 5/8/2008 |
| Q: I have rows that are color coded, is there an easy way to delete the rows that are not color coded? A: How are you? This does not mean to answer your question but please study this example: 1. Colour ... | |
| Excel | 5/5/2008 |
| Q: This is a receipt for a question you recently asked at allexperts.com of Ken Marron. You should ... A: How are you? The easiest way I can think of is to write a user defined function for that. Write the ... | |
| Changing a Macro | 4/29/2008 |
| Q: I have a macro (shown below), but I want to change it so that rather than the duplicated cells are ... A: How are you? Please have a look at the following: Sub FindDups() Dim S As Range, F As Range ... | |
| Excel | 4/24/2008 |
| Q: i need to have a formula based on the formula ... since i'm no excel expert i'm asking for your ... A: How are you? Please try the following: Assuming that your products numbers are in A1:A10 and the ... | |
| Excel help | 4/23/2008 |
| Q: I could not post a general message hence emaling you so you could help me I have this pivot formula ... A: How are you? If you want A16 to become A17, A18, A19, just replace $A$16 with A16 the $ sign ... | |
| Linking excels' cells to specific Word documents | 4/19/2008 |
| Q: Can & how can this be done? I want to connect a serial # on a cell row so that a page of historic ... A: How are you? There are many ways of doing this. The easiest is to set a hyperlink to the word file. ... | |
| Transposing data in Excel | 4/11/2008 |
| Q: I want to create a Macro that will Transpose my data from sheet1 to sheet2. Input data: ... A: How are you? Please do the following (I assume that your data is in A1:F7) 1.Select Sheet2 ... | |
| Array Formula -Excel or sumif | 4/10/2008 |
| Q: I am trying to sum a formula which needs to look at two sets of criteria...it should only sum if ... A: How are you? If you are using Excel 2007, this straightforward because there is a function that ... | |
| Worksheet Event change | 4/9/2008 |
| Q: Firstly, thanks very much for your help with a previous question I asked. You were both quick and ... A: How are you? I have just looked at your second procedure. The first one is too long you may probably ... | |
| Excel Tab Name List | 4/7/2008 |
| Q: I want to show a list of the tab names in excel. How do I do this? A: How are you? Please do the following 1. Tools - Macros - Visual Baic Editor 2. Insert - Module 3. ... | |
| add 2 numbers to a group of cells automatically | 4/6/2008 |
| Q: I've just imported a bunch of data into a spreadsheet and the first two columns are dates, mostly ... A: How are you? I am sorry I has sent you the answer intended to other person So, assuming that your ... | |
| excel functions | 4/3/2008 |
| Q: 1) how to lock particular cell in protected sheet? because when i protect sheet it lock all cell. ... A: How are you? For the 1st question pleaee do the following: 1. Unprotect all the cells Select the ... | |
| userform textbox_change code | 4/2/2008 |
| Q: Let me begin by sAying that i am not a professional programmer/developer, so my question may not be ... A: How are you? There are many ways to solve this, but one of the easiest solutions is to add the ... | |
| DELETE DUPLICATE RECORD | 4/1/2008 |
| Q: i filter all the column from A1:AW8390 and Data/filter/advance filter/ click filter the list,in ... A: How are you? Please try the following: 1. Type the fields names in the Row 1 2. Copy the fields ... | |
| Loop or repeat vba process for many rows | 3/29/2008 |
| Q: I have the following code: Sub Macro3() ' ' Macro3 Macro ' Macro recorded 29/03/2008 by JK ' ' ... A: How are you? I am not sure if I have understood what you mean. But please try the following Sub ... | |
| specifying a path/directory | 3/28/2008 |
| Q: I would just like to know the exact command on how to specify a path or directory where the program ... A: How are you? This has to be done with a VBA program. Have you already done some programming? ... | |
| NO UP_LOAD FROM FORMULAS | 3/26/2008 |
| Q: i'm developing an EXCEL 2003 file made with 3 sheets, a good nr of formulas, hyper links and ... A: How are you? i am sorry I cannot help you much because I have Office 2003 no longer. Yet, as Excel ... | |
| Macro for Substitution | 3/24/2008 |
| Q: I would like to write a macro to replace certain characters in a selection. For example in rows 1 ... A: How are you? How about this? Sub Macro_Test() Dim Y As Range, a As String, R As Integer, C As ... | |
| date | 3/22/2008 |
| Q: i would like to ask the excel sheet to look at the date on my computer and update it on the sheet on ... A: How are you? Please try the following 1. Type in A3 =today() 2. Type 14 in D3 3. Type your dates in ... | |
| using VBA to "find" a certain value in a column | 3/3/2008 |
| Q: I have a table of "current files" that is updated daily by the whole team as soon as a new file has ... A: How are you? I think the following will do what you want Sub Currentfiles() On Error Resume Next ... | |
| Add series to a chart | 2/29/2008 |
| Q: I would like to automate adding series to an existing chart using a command button. Y values will be ... A: How are you? I suggest you to record a macro with the procedure you want to do. Then edit the code ... | |
| EXCEL RANGE ISSUES | 2/27/2008 |
| Q: The data i have to work with comes in the format below in a single cell: Gi0/1 300,331-333 ... A: How are you? I wrote a userdefined function for this problem and hope you can use it. Please do the ... | |
| sorting table while skipping blanks | 2/23/2008 |
| Q: I have written a VBA code in Excel which works fine, except that it places all empty cells at the ... A: How are you? If you have sorted the problem, that is fine. But you can also use the following ... | |
| sorting table while skipping blanks | 2/21/2008 |
| Q: I have written a VBA code in Excel which works fine, except that it places all empty cells at the ... A: How are you? You can always delete the blank lines beforethe sorting Something like: Sub ... | |
| Compile error - Procedure too large | 2/20/2008 |
| Q: I have done a macro in Excel VBA. Its very large macro. (About 800 lines). Up to this the macro is ... A: How are you? I have no idea abouth the maximum length of a procedure. But you can have a main ... | |
| excel macro | 2/19/2008 |
| Q: I am trying to write a macro in excel VB. I know ms basic language and some Paradox object pal ... A: How are you? What about these two VB procedures? Sub Checkingpairs() Dim X, Y, AA, BB Dim RA As ... | |
| Links | 2/18/2008 |
| Q: I have a workbook that contains 7 sheets(1 for each weekday)and a summary sheet. I have ranges in ... A: How are you? I think that something simple as the following can do the job for you 1. Name the ... | |
| udf for sumproduct | 2/9/2008 |
| Q: HELLO, SORRY TO TROUBLE YOU AGAIN. YOUR UDF FOR SOMEPRODUCTVISIBLE HELP ME VERY MUCH.BUT IT DOESNOT ... A: How are you? I have checked the code and it works. Please do as following 1. Write the data in A2:D7 ... | |
| sumproductvisible | 2/6/2008 |
| Q: I HOPE YOU ARE WELL,I HAVE A PROBLEM TO USE “SOMEPRODUCT” JUST FOR ONLY VISIBLE CELLS. I WANT TO USE ... A: How are you? What about the following: Public Function sumproductvisible(sourcerange As Range, ... | |
| Reconciling variable figures to given totals | 2/5/2008 |
| Q: I have been struggling to create a macro that, given a target total and a number of amounts, can ... A: How are you? I think the following suits your problem: 1. Tools - Macro - VBA Editor 2. Insert ... | |
| Appending | 1/3/2008 |
| Q: My problem is " i am getting values from forms and pasting it into my worksheet,the form is the user ... A: How are you? What about Private Sub Submit_Click() Dim C As Range, i as integer Set C = ... | |
| Time Track for Break Schedule for our team | 12/31/2007 |
| Q: I would like to track our team break timing schedule, actaully we have 2 short breaks of 15 min and ... A: How are you? I need to know a bit more about the data processing you want to implement. But I ... | |
| missing help on excel tutorials | 12/28/2007 |
| Q: Greetings, I have to manage a stock, to simplify let's say I sum up all on two columns F5:G[end of ... A: How are you? If you are using VBA, you can detect the first empty cell on a column by applying the ... | |
| proble i excell | 12/24/2007 |
| Q: I would like to set a format that if cell A1 is Contained the value "NO" than hide the raw no 2 to 5 ... A: How are you? This can be done with a vba program. Please do the folowing: 1. Tools / Macros / ... | |
| VBA - Compound interest & take % from reinvested amount | 11/30/2007 |
| Q: I need help in adding additional contributions eg. 100 month, i also need to add a 15% tax on ... A: How are you? I think that the following, with some currency formats would do: 1. Type 10000 in A3 ... | |
| Excel question | 11/29/2007 |
| Q: You helped me just recently here was myCombo Box , List Box Excel 2003 I am working with a Data Page ... A: How are you? Yes, you are right. the Vlookup function should be =VLOOKUP(A1;Sheet1!$A$19:$B$30;2) ... | |
| Combo Box , List Box Excel 2003 | 11/27/2007 |
| Q: I am working with a Data Page which I have placed combo boxes on which I would like to display there ... A: How are you? I still do not entirely understand your question. However, I hope the following helps ... | |
| Excel conditional formating | 11/24/2007 |
| Q: How can I perform a conditional formatting in cell A1 like if A1 < B1 then color in red. similarly ... A: How are you? Please do the following 1. select A1:A10 2. Format / Conditional formatting 3. Select ... | |
| generating a formula | 11/22/2007 |
| Q: could you help me in the following, if i have a cell contains a mix of numbers and letters, i.e ... A: How are you? It easier to write a user defined function for that. Please do the following: 1 Tools ... | |
| blank cell getting ignored | 11/21/2007 |
| Q: I am copying certain data from one workbook to another workbook and appending it.my problem is when ... A: How are you? I am sorry I do not know exactly what you want to do. I assume that you do not want ... | |
| split cell values | 11/19/2007 |
| Q: My problem is: I have a list of 7 items ItemOne ItemTwo ItemThree Itemfour Itemfive Itemsix ... A: How are you? Please take a look at Sub separinglists() Dim ori As Range, lista As String Dim Dest ... | |
| Filter Out Duplicate Names | 11/12/2007 |
| Q: I am creating a large directory, with names, numbers and addresses. The problem is , there are many ... A: How are you? I wonder if the following is simpler than you need: A. To filter the data, please do 1. ... | |
| Running Macro upon cell change and running macro for different rows? | 11/11/2007 |
| Q: Hope you had a great day! I'm facing some trouble with excel and it'd be great if you could take ... A: How are you? I am sorry but your question is too long. But there it goes some hints: A. To do delete ... | |
| IF And condition | 10/25/2007 |
| Q: I have a range of data. I have set a condition that if says K2)Style = 7768, L2)ID = IKB, M2)Dept = ... A: How are you? In Excel 2007 this will simpler because it offers a function that counts ranges that ... | |
| basic excel VBA | 10/24/2007 |
| Q: I am very new to VBA/Macros. I have a Macro written(from internet searches) that inserts a blank ... A: how are you? I think that something like Sub InsertRows() Application.ScreenUpdating = False Dim ... | |
| Autocomplete Repetitive Lists | 10/23/2007 |
| Q: I create a weekly list which has the following colums: Name | Phone Number | Amount ($) | Time ... A: How are you? You try the following: 1. Type the 3 characters of the name, the remainder characters ... | |
| compare two lists for duplicate numbers | 10/22/2007 |
| Q: - Originally, I had two columns of numbers in excel. Please, how do I compare them to determine if ... A: How are you? I guess that there is simpler solutions but I suggest the following> 1. Assume your ... | |
| OnTime VBA | 10/18/2007 |
| Q: I am trying to use the OnTime feature in VBA for excel where it will save the workbook every 20 ... A: How are you? What about that? 1. Attach the following code to thisworkbook Public dTime As Date ... | |
| VBA code for auto date in excel | 10/15/2007 |
| Q: What is the excel VBA code to auto populate date on another cell if you input a specific text only ... A: How are you? I have not checked your quetion entirely, but thois could be a good start Private Sub ... | |
| Web Query VBA time stamp | 10/14/2007 |
| Q: I have two identical web query's on the same sheet. One from column A to column I and the other ... A: How are you? I have not checked your question completely, but I think that it would be useful for ... | |
| Changing line color | 10/8/2007 |
| Q: On my worksheet, I have a line and two command buttons. When I click on the fist command button, I ... A: How are You? Assumming the line is the bottom border of a range, please do0 the following 1. Tools - ... | |
| rate calculation | 10/5/2007 |
| Q: If a company earns $1000 in year 1 and $5000 in year 5 then I have no problem calculating the rate ... A: How are you? This is bit weird to explain remotely as the reason derives from the mathematics. We ... | |
| excel functions | 10/2/2007 |
| Q: i am trying to record a time in excel 97 every time a single entry is made in the woorksheet. i can ... A: How are you? Firstly, I am using Excel 2003 ... This likely applies to Excel 97, but not surely. I ... | |
| Hyperlinks with Calendar Control 11 | 9/27/2007 |
| Q: Basically, I would like to be able to click on a day in the embedded calendar from Calendar 11, and ... A: Hope you are excelling The following may help you to sort out your problem with a little more effort ... | |
| Hyperlinks with Calendar Control 11 | 9/26/2007 |
| Q: Basically, I would like to be able to click on a day in the embedded calendar from Calendar 11, and ... A: How are you? I have googled your question and was led to a site that may contain the answer to your ... | |
| adding cells that have the result of an if function | 9/24/2007 |
| Q: I have created a spreadsheet that adds the values in cells that get the results from cells that have ... A: How are you? Your formula is Ok, but if you want to sum up numbers you cannot put them between "". ... | |
| possibly crosstraining into Excel | 9/22/2007 |
| Q: I am thinking about cross training into Excel. I have taken a class that taught the entire MS ... A: How are you? I really recommend you to get into Excel. It is big fun. An introductory book is ... | |
| Excel Menus | 9/16/2007 |
| Q: I have done something to my Excel spreadsheets and lost all the menus. How do I get them back? ... A: Hope you are well Sorry but I do not know what happened to your Excel spreadsheet. I need to know ... | |
| Substituting Text Based on Colorindex | 5/21/2007 |
| Q: I have a spreadsheet that is a capability matrix. Based on relevancy, cell were changed to show a ... A: How are you? You may easily find a better solution but this is a very simple one select Edit - ... | |
| Login Password and dont prompt a questions to enable macros | 5/7/2007 |
| Q: I was wondering if you have and could you help me out with these problems I'm having. I have a ... A: How are you? How about saving the file with a password ? Please try Open the file File - Save As ... | |
| deleting cells | 5/6/2007 |
| Q: I am new to VBA, and in fact taking a class on it, my project asks me to check for a value in a cell ... A: How are you? How's that Private Sub Workbook_Open() Dim R As Range, companyname As String Set R = ... | |
| A complex macro | 4/28/2007 |
| Q: how are you? Thank you very much for the past help. You’re amazing!! Sorry for bothering you again, ... A: How are you? I can only solve your first quetion. I am sorry but it would take longer than I can ... | |
| dialog boxes | 4/18/2007 |
| Q: I'm trying to create a question workbook for our office and I don’t know how to link a question ... A: How are you? The best way I can think of uses VBA programs 1. Insert a Command Button in sheet1 View ... | |
| TextBox Control Formatting | 4/15/2007 |
| Q: I am trying to use text box controls in a user form in which the user will enter time in hh:mm:ss ... A: How are you? Please try the following example 1. Create an Userform with a textBox, Label and ... | |
| external data link | 4/2/2007 |
| Q: I have a workbook that links to another. each year I make a new workbook but have to change the ... A: Please try the following example 1. Create 2 workbooks test.xls and test1.xls and save them in ... | |
| external data link | 4/1/2007 |
| Q: I have a workbook that links to another. each year I make a new workbook but have to change the ... A: How are you? I think I have an idea for that but as I am too busy now I'll try Tomorrow. It has to ... | |
| excel functions | 3/31/2007 |
| Q: I am doing a weekly grocery list. Need the function that would multiply 2 columns and then subtract ... A: How are you? You have to follow the procedure exactly as I told you. But of you need some trainingm ... | |
| EXCELL SPREADSHEET | 3/30/2007 |
| Q: I am new to Excel and I would like a spreadsheet for compound interest witha monthly withdrawal, ... A: i Joseph How are you? Please do the following 1. Type in H1 the monthly rate, e.g =6%/12 2. Type in ... | |
| excel functions | 3/29/2007 |
| Q: I am doing a weekly grocery list. Need the function that would multiply 2 columns and then subtract ... A: How are you? Warming up notes: Each cell is addressed by a column (a letter) and row (a number). Eg. ... | |
| Lookup a Sum of Numbers | 3/17/2007 |
| Q: I have some data as follows: Item Jan Feb Mar A 1 2 3 B 4 5 6 C 7 8 9 If I ... A: How are you? If you want I can write a vba program to do this, but the easiest way is to use an ... | |
| VBA to Mark a cell then return to it. | 3/7/2007 |
| Q: Can you suggest a tidier way to "remember where I am" on a spreadsheet, so I can come back to the ... A: How are you? What about the following Sub WhereIWas() Dim a As Range, b As Range addr = ... | |
| Function using IF and COUNT | 3/6/2007 |
| Q: I am trying to write a formula to count the number of cells in a column that have a value from ... A: How are you? How is this 1. Write the bin range 59, 100,159,200,259 in G12:G100 in G12:G200 2. ... | |
| text - numeric conversion | 2/23/2007 |
| Q: I would be looking to covnerting text entered in my textbox to a numeric decimal value to be used ... A: How are you? I assumed that you have insert a userform with a textBox1 and two command buttons by ... | |
| format change | 2/17/2007 |
| Q: I opened an old works file that contains a macro (virus free), and now all excel files I open or ... A: how are you? I am sorry but I do not know what is going on in your computer. You can, for instance, ... | |
| Multiple currency conversion | 2/15/2007 |
| Q: I only have a very basic understanding of excel :)And i saw you have answered a question before ... A: I hope you are well. Is Adelaide a nice place to live in? The easiest way to do this is the ... | |
| Excel - Replicated data across a row | 2/12/2007 |
| Q: You helped me a year ago, and now I need your help again. I have some experience with Excel 2000 ... A: How are you? I have no idea of what is going on with your btothers'worksheet. I'd check if it ... | |
| Excel Question | 2/10/2007 |
| Q: I have 2 columns that contain information and I would like to take the cell to the left, and move ... A: How are you? The easiest way is to insert a new column C and type in C1 =A1& " "&B1 then Copy this ... | |
| User form - cell reference | 2/7/2007 |
| Q: I'm trying to create an interactive userform on excel. Say one of my cell ranges contains values ... A: How are you? This can be done with a VBA program. Please try the following with a small example of ... | |
| Where cell blank, ditto previous row's cell | 2/5/2007 |
| Q: you were of great help to me last week...I have another, unrelated query that I am hoping you can ... A: How are you? This can be done with a VBA program. Please try the following with a small example of ... | |
| Excel 2000 | 1/30/2007 |
| Q: I am trying to create a macro that will create a temporary named range for the purpose of further ... A: How are you? Please edit your macro and change it accotding to the following VBA procedure Sub ... | |
| my Vb code cannot read path other than c:\ | 1/29/2007 |
| Q: Hallo Adelaide carvalho, I have a Buffer.txt files in my network that i want to open and create ... A: How are you? I am sorry I cannot try your code because at the moment I am not connected to a ... | |
| Function | 1/25/2007 |
| Q: I have an excell spreadsheet to control the projects that we manage at our company. I need to learn ... A: How are you? Please do the following 1. Type in A6 =Now() 2. Type in B6 01/31/07 3. Select B6 4. ... | |
| Delete rows with vb code | 1/13/2007 |
| Q: what is the vb code to search for blank cells in a column in excel sheet and if the cells or cell is ... A: How are you? I know that the following is not the solution for your problem. But if you study this ... | |
| Auto fill cells based on drop down list selection | 1/12/2007 |
| Q: I would like to be able to have Excel auto fill cells based on a specific selection from a drop down ... A: (I wish I were rich too!) How are you? Please try the following: 1. Type the list you want in a ... | |
| Application-defined or object-defined error | 1/11/2007 |
| Q: The following line TypeName(Sh.Cells(1, 1).Validation.Formula1) = "String" rises an error ... A: How are you? Please try one of the following: Sub hhh() Set sh = Sheets(1).Range("a1") On Error ... | |
| Excel "Automatic text" check box | 1/10/2007 |
| Q: I am trying to put data labels on a simple x y scatterplot (one column of data against another). I ... A: I hope you are well. I would do the following: 1. Type X, Y and label in C5:D5 2. Type x values in ... | |
| Formula | 1/9/2007 |
| Q: HELP!! I have a spreadsheet whereby the the first tab records a set of data and the second tab draws ... A: Happy New Year!! I am sorry but I cannot understand well what you mean. But, please try the function ... | |
| identify cells that CONTAIN text from another cell, not MATCH it exactly | 1/6/2007 |
| Q: I have two sheets of data. In sheet 1, column A is a list of id numbers with the rest of the ... A: Happy new year!! Would you like to try the following: 1 Your date with the short Id number is in ... | |
| Formula for Interest | 1/5/2007 |
| Q: Good morning and Happy New Year: Here is the formula i am trying to use: e.g. 54,000.00 x 10% / 365 ... A: Happy new year to you too!!! Please try the following 1. Type 54000 in A1 2. Type 10% un B1 3. Type ... | |
| VB Code | 1/4/2007 |
| Q: I would be very greatful if you could help me. Is there a way of being able to tidy this code up? ... A: How are you? If you intend to produce a list of the worksheets' names, the following procedure is ... | |
| Autosizing of cell | 1/3/2007 |
| Q: I merge three cells horizontally. I set the merged cells to wrap. I align the text top/left. After ... A: I hope you are well. I am sorry but I do not know how to do it. I've even tried to write a vba ... | |
| RE: Fine Macro | 12/28/2006 |
| Q: I'm trying to write something for excel that will enable me to create a hyperlink (in a certain ... A: <how atre you? At the first glancem I can sufggest the following 1st. Define a set of cells names ... | |
| pivot table layout | 12/27/2006 |
| Q: I have trouble getting a proper layout in the pivot table based on the data below: Liability ... A: How are you? An alternative way is to 1.Consider that your original data (liabiliy 50, 1, 5, 9 ....) ... | |
| Inserting data from sourse document | 12/18/2006 |
| Q: Adelaide, I would love a small example to the do while loop. Thank you very, very much! !I am ... A: How are you? The following example copies the accounts of the first customer from Sheet 1 to Sheet3 ... | |
| Inserting data from sourse document | 12/17/2006 |
| Q: I am working for a company that as accounting software which generates an excel spreadsheet (both ... A: Season greetings for you too! A VBA program would read the source worksheet starting on the ist ... | |
| passing lots of values to a sub | 12/16/2006 |
| Q: i have a lot of small subs modules that require lots of values passed to it to function on those ... A: How are you? I do not know what you want to do ... there are so many ways to pass the parameters. ... | |
| excels formula in currency conversion | 12/14/2006 |
| Q: how to make a formula in excel to convert 49.48 php in ... A: I hope you are well What I suggest is 1. Type in the series 1000,500,200, ... 0.01 in A4:A14 2. Type ... | |
| excels formula in currency conversion | 12/8/2006 |
| Q: what is the formula of excel to convert any given amount from USD or U.S DOLLARS into currency. BY ... A: Hope you are well. I do not know what you mean by this ... I am sorry. If you have the amount, for ... | |
| importing database table into excel file | 12/6/2006 |
| Q: I have sucessfully imported a table into an excel file that needs a lot of formatting work. My ... A: I am sorry I have no time to answer your question throughly. This will take me rather long :-( Just ... | |
| Date/ Now | 11/26/2006 |
| Q: I wrote a macro to store tables with data from an Excel file in another file and to replace the ... A: How are you? As I have not read your, please try to see if the following fits on it: A) If you ... | |
| macro / vba | 11/25/2006 |
| Q: I am developing a questionnaire in Excel and want to put two buttons in the worksheet. One is for ... A: How are you? You can inset the buttons directly on the worksheet. Please try the following: 1) ... | |
| Dates | 11/22/2006 |
| Q: I am trying to work out the years and months service an employee has given to my company, I use the ... A: How are you? This is a bit more complicated than one may thought :-) Please do the following 1. ... | |
| zero error? | 11/21/2006 |
| Q: I have written a code in VBA to perform some certain error checks for entered cell values. However, ... A: How are you? Your problem is that you assign to range("a1") oiltempvalue which is always zero. ... | |
| Hidden sheet | 8/11/2006 |
| Q: The first sheet of my workbook is a summary of several worksheets. The values on this summery sheet ... A: How are you? Instead of a hyperlink you can trigger the execution of a macro that hides and unhides ... | |
| Excel Updating | 8/9/2006 |
| Q: Is it possible (and if so how ) in Excel (using VBA or whatever easiest) to have 2 worksheets A and ... A: How are you? Can you please try the following 1. Type Hello in A1 of Sheet1 2. select Sheet2 3. ... | |
| excell formatting | 8/7/2006 |
| Q: Ok, I have a tough one, I think. I need to format one column based on another column. Column B ... A: How are you? I am sorry it has taken me a long time to reply to you but I went to Germany for the ... | |
| Shared Workbook unnecessary files | 8/3/2006 |
| Q: I have an Excel workbook which is found on a network (it resides on the network server). The ... A: How are you? You can for example create a macro and assugn it to a button that deletes all the ... | |
| Excel File option | 7/29/2006 |
| Q: I want to ask you about one Excel file which I received by e-mail, in that Excel file there is one ... A: How are you? This option is Group and outline on menu Data. It will probably be helpful to read the ... | |
| excel formula...? function? | 7/25/2006 |
| Q: I have a question regarding the use of excel. i´m not an expertee in excel, i´m a basic user. i ... A: It sounds good, but you we also have to input also some patterns to be checked. For example, odd or ... | |
| excel formula | 7/23/2006 |
| Q: I wrote a formula that checks a list of text against another group the problem with it is that is it ... A: How are you? I'm not sure if I've understood your question. But please see the functions Countif, ... | |
| macro? | 6/12/2006 |
| Q: A spreadsheet in sheet 3 of an excel document has certain rows shaded. When I import the document ... A: How are you? Where do you import the data from?You may import data and format - it depends on the ... | |
| Stacked column chart | 6/3/2006 |
| Q: I want to make a stacked column chart of 3 segments. The top segment will show my starting weight, ... A: How are you? Please try the following 1. Type data A2:Person1 A3:Person2 B1: Start B2: 80 B3: 100 ... | |
| Moderate color | 5/30/2006 |
| Q: How can i moderate color of cell A: How are you? I am not sure what you mean by moderate the color. Is it to paint the background ... | |
| Dim error | 5/24/2006 |
| Q: Adelaide, I have a spreadsheet that pulls info from an AS400. The information comes from a file ... A: How are you? You have to set a reference to AS400 in your VBA program (project). Please to the ... | |
| Find Last Cell in Excel | 5/23/2006 |
| Q: I particularly like the messagebox. I have however found a problem with this solution. I’m actually ... A: Your code seems fine, but I would define some object variables to make it more readable E.g. Dim Act ... | |
| Find Last Cell in Excel | 5/20/2006 |
| Q: I have a Workbook which produces an order, called "Purchase Order" There can be upto 20 lines on an ... A: How are you? I am sorry I've forgotten this question. Anyway, I can help only with a small piece of ... | |
| counting seconds | 5/15/2006 |
| Q: I have a sheet with the column for time the format should be h:mm:ss, the time begin with 0:00:00 ... A: How are you? Please try the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Visual basic error | 5/11/2006 |
| Q: Greetings from the UK Excel 2003 I have a custom icon linked to a macro that opens an xl file. The ... A: Greetings from the UK too. Portuguese though. Can you please try something like Sub MyIF() On Error ... | |
| Setting Contstant Ranges for Macro Module | 5/8/2006 |
| Q: I am hoping that you would be able to help me out with this question as it has been driving me ... A: How are you? You can parameterise the macros so to have an input parameter that represents the ... | |
| recurring payments in budget | 5/2/2006 |
| Q: I'm fairly new to excel. I am building a budget and I am looking for a way to have excel ... A: How are you? You can start doing very easy things, for example 1. Insert a row above the weekdays, ... | |
| MS Excel Visual basic/macros | 3/28/2006 |
| Q: can you give me the correct syntax, or code to to write a macro for copping a range of cells within ... A: How are you? Please see the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Flagging Data | 3/23/2006 |
| Q: I have a range of people individually numbered in one worksheet (WS1), in another worksheet I have ... A: How are you? What about the following? 1. Tools - Macro - security - security level - low Tools - ... | |
| Conditional Formatting (Comparing Lists) | 3/17/2006 |
| Q: and hope you can help ! I'm using Excel 2002 (10.2614.2625) What I'm attmepting to do is the ... A: How are you? Please see the following. I assumed that the source data is in A1:A10 on sheet1 1. ... | |
| Excel Conditional formatting | 3/15/2006 |
| Q: ... I'm using Excel 2002 (10.6713.6626) SP3 I'm trying to use conditional formats in Column F to ... A: How are you? Please, try 1. type apples in B2 2. type the formula in C2 ... | |
| Problem with Excel VBA | 3/14/2006 |
| Q: it does work ! If possible I would appreciate if you can comment why my code did not work. Thanks a ... A: How are you? This a correct version of your code Sub testa() Windows("second.xls").Activate ... | |
| Thanks Adelaide, a. It gives... | 3/9/2006 |
| Q: a. It gives me Clinton in both cells. Please correct the second cell. b. Can you please explain what ... A: Sorry for the 2 Clintons... Maybe I was also thinking of his wife ... (this is an attempt to joke ... | |
| Summing values between 2 numbers | 3/6/2006 |
| Q: I have two parameters, namely Q and r. I +1 and have to find the sum of all values between r+1 and ... A: How are you? I think that previously to tackle your formula, you may want to study the following 1. ... | |
| no of rows as Range | 3/2/2006 |
| Q: I need to write the macro that calculate a function that should be fill all the rows with particular ... A: What about that? Sub CalculateTime() ' Dim nRows As Long, dest As Range, addr As String nRows = ... | |
| Excel function to substitute a work for a code in a string of comma delimited codes. | 2/26/2006 |
| Q: I'm trying to find a function or VBA routine to take a series of 3 digit alpha-numeric codes that ... A: How are you? I have just compute a formula for the spreadsheet. You can insert it in a VBA program ... | |
| Excel 2000 | 2/24/2006 |
| Q: I am using Excel 2000. I am doing my final project for my ICT course and I would like to know how to ... A: How are you? I can give you only san example. Please try the following: 1. Tools - Macro - ... | |
| Excel question | 2/23/2006 |
| Q: I have an excel worksheet with a lot of data but only four field SysID alphanumerical ... A: How are you? I have just dealt with the 10top SysId that spent more parts ... the other problem is ... | |
| Excel 2003 mulitple worksheets | 2/20/2006 |
| Q: I have a worksheet (page 2)which contains date to calulate students grades. I had to calulate the ... A: How are you? Let's assume that you have - the exams types and weights in Sheet1, range A1:B4 - the ... | |
| ? | 2/19/2006 |
| Q: however one big problem, it came out with TONS of duplicates, can you check your formula to see what ... A: How are you? Every time you run the macro you have to delete the first column. Every time thew ... | |
| ? | 2/18/2006 |
| Q: .. can i please ask you... I have an excel spreadsheet with email addresses scattered all over it, ... A: How are you? If you want to join all the scattered emails of sheet1 into column A of sheet1, please ... | |
| consignment software? | 2/16/2006 |
| Q: I have a consignment shop and wanted to see if you knew of an easy program that I could use to take ... A: How are you? I am sorry but you are too vague in what you need. Perhaps it would be better to have a ... | |
| Excel Tables | 2/10/2006 |
| Q: I have a table of postal codes. There is a column called "Beginning Zip" and one called "Ending ... A: How are you? Please try the following: 1. Tools - Macro - security - security level - low Tools - ... | |
| Excel: Add dates | 2/7/2006 |
| Q: In excel 2000, I have a date (6/29/94) and I have a number of years (3.7. What formula would I use ... A: How are you? You have to convert 3.7 into days and then sum up to your date For example if you want ... | |
| cell formating | 2/2/2006 |
| Q: I'm running Office 2003. In Excel, if someone sends me dates that are formatted in this manner: ... A: How are you? Please try the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Getting Excel to distribute a number across several cells | 1/30/2006 |
| Q: Good Morning, WE have a pricing program that is based in Paradox. We have the ability to publish ... A: How are you? To help you I need to know a) When you paste the data, how is it stored in the ... | |
| Track Changes | 1/26/2006 |
| Q: I use Track changes all of the time in Excel 2002. I am constantly sending it to different people ... A: How are you? I have never used the track changes in Excel but the colours might have to do either ... | |
| Vlookup for multiple 100x100 tables | 1/23/2006 |
| Q: I hope you can help me. MyI have a 100 by 100 table in Excel, (100 ages by 100 durations, each age ... A: How are you? You can write a VBA program to ask the age the user wants to check and highlight the ... | |
| Sampling | 1/20/2006 |
| Q: I'm running Excel 2003. I have a large file of about 2500 records need to run some reports against ... A: How are you? I am sorry but I think this question takes a long time to discuss. But, please see the ... | |
| making chart | 1/17/2006 |
| Q: I have office 12(the newest version) but unfurtunatly I have a problem with my excel.I can't make ... A: How are you? The problem is that I do not have Excel 12 yet. I do not know if it is very different. ... | |
| VBA macro | 1/16/2006 |
| Q: The following program is not working with the cell formatting portion. The program works fine ... A: How are you? Please see below Sub aatestInsert_Hyperlinks() Dim CurrentPositionOfCursor As Range ... | |
| VB | 1/11/2006 |
| Q: What is the data type of the value returned by the Msgbox function? What does the Left function do? ... A: How are you? a)returns an integer indicating which button the user clicked. Eg. Sub ... | |
| Excel Marco | 1/10/2006 |
| Q: I am using Windows XP and Excel 2003. I want to write a Marco for the following function: 1. I go ... A: Hope you are well. Please try the following Sub openFile() Dim F As Range Set F = ... | |
| saving files in excel to multiple locations | 1/5/2006 |
| Q: When saving a file in excel, is it possible for that file to be saved in two locations. For example, ... A: How are you Please try the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Comparing 2 files | 1/4/2006 |
| Q: I'm trying to compare two files to see if any rows are different. If a row is different then it ... A: How are you? Your question takes a long time to answer ... but, please study the following Sub ... | |
| symbol insert | 1/3/2006 |
| Q: Basically, I would like to be able to insert a dash after the 3rd character in a cell for the entire ... A: oops ... I assumed that the part number is in column A You have just to change the letter in 3rd ... | |
| chart transfer frm excel to word | 12/23/2005 |
| Q: I am writing from Russia. I have a P-3 and i am working on my PhD thesis. From my data i have ... A: How are you? I guess that this happens because the charts demand lots of memory. You can try to copy ... | |
| using "if " function | 12/16/2005 |
| Q: In cell B3, a number from 1 to 10 will be entered. That number just stands for how many years. Each ... A: how are you? Please try the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Extracting an entire row | 12/12/2005 |
| Q: I have 50 workbooks, similary named, but each filename contains the last name of an individual. Each ... A: How are you? You have to do a VBA procedure (macro) in a new workbook that repeats for each source ... | |
| Swapping numbers within a column | 12/11/2005 |
| Q: I'm creating a spreadsheet (on Excel 2002, using Windows XP) which ranks 28 sports teams. I have ... A: How are you? Please try the following 1. Tools - Macro - security - security level - low Tools - ... | |
| Excel spread sheet | 12/10/2005 |
| Q: Excel 2000 Hi, I am a first time user of Excel. I am setting up a workbook. There will be ten ... A: How are you? First, maybe it is interesting to try that to sum 2 values of different sheets: 1. in ... | |
| Using Nested Logic Functions | 11/26/2005 |
| Q: I want to compare the value in a cell with the values in the 8 cells to the left, to the right, up ... A: How are you? To nest OR functions, just do, for example: =OR(J12=B12,OR(J12=C12,OR(J12=D12))) But ... | |
| Excel macros | 11/25/2005 |
| Q: I have an excel workbook that I keep monthly Officer statistics on.This transfers all of the totals ... A: Lieutenant Pendleton How are you? I' ve tried a simple solution. Please see 1. Type the names of ... | |
| Page Setup Defaults | 11/23/2005 |
| Q: Excel 2002 in Windows XP Hi Adelaide, Hope you can help. I produce many printed spreads and each ... A: How are you? It seemed that it would be possible to change the page set up in the normal style ... ... | |
| Enter part of the date (Just time) | 11/21/2005 |
| Q: Time Time Hours Machine In out worked How can I calculate the above ... A: How are you? Please do the following 1. Type in A2 =TIME(9,10,0) or simply 09:00:00 2. Type in B2 ... | |
| applying lines in excel | 11/17/2005 |
| Q: i have a very simple question, i want to just apply lines at the bottom of each row, horizontally, ... A: How are you? Please do the following 1. tools - macro - visual basic editor 2. insert module 3. ... | |
| Learning functions | 11/16/2005 |
| Q: I'm trying to figure out how to create a custom function in Excel. My function (found on the web) ... A: How are you? The only thing you have to do is: 1. Tools - macro - visual badsic editor 2. Insert ... | |
| Loss of PATH in footnotes | 11/14/2005 |
| Q: My Excel in Office XP has a PATH variable which can be placed in the footnote along with FILENAME. ... A: How are you? When you do View - header and footer and press custom header or custom footer you can ... | |
| frequency formula with criteria | 11/12/2005 |
| Q: I am struggling to make a frequency formula that gives me the count of unique entries of one column ... A: Hopw are you? The following seems complicated and may be there are simpler ways to do it but, ... | |
| Excel Data | 11/9/2005 |
| Q: ..without using macros or VBA, just formulas - I want to take a range of data, query that range and ... A: How are you? Please do the folowing 1. Type your data in, e.g., A1:C10 2. Sort the data ... | |
| VBA form (Offset ) | 11/7/2005 |
| Q: I have a spread sheet on excel 2003. In this spread sheet I have 5 colums. I decided to put a user ... A: Ola Antonio How are you? Activecell.offset(2,1) means 2 rows down and one col right ... | |
| functions | 11/6/2005 |
| Q: Okay, here is what I am trying to do. I have a bunch of regions in column A and I have percentages ... A: How are you? You can also do it simple and hard working 1. Assuming your data is in A1:B10 2. in ... | |
| how to set up a control button | 10/18/2005 |
| Q: I need help with two things. Firstly, I have a financial worksheet. I have a list of all my ... A: How are you? 1st Question 1. Write positive and negative numbers in A1:A5 2. Type in A11 ... | |
| Excel if then statement | 10/17/2005 |
| Q: I am needing to add two columns of numbers using the second column if a number exists and adding the ... A: How are you? I am sorry I have not understood what you want (how many numbers do you want to sum? ... | |
| Convert Format | 10/16/2005 |
| Q: It works for the first solution (using formula) if the figures are in text format. But I didn't ... A: How are you? Try the following to undersand how the macro works 1. Type negative and positive ... | |
| Convert Format | 10/13/2005 |
| Q: I have long list a figures in column A to sum up as below: 75245 82451CR 21248CR 57474 Numbers ... A: How are you? Check first if those numbers are numbers or text 1. Select 82451CR 2. Format - cells ... | |
| CONVERT function problem | 10/11/2005 |
| Q: hope you can clarify something for me. I am simply trying to convert hours into minutes. I am using ... A: How are you? Please see the following 1) =CONVERT(H2*24,"hr","mn") or 2) type in H2 ... | |
| VBA problem | 10/10/2005 |
| Q: I am using Excel 2003 and writing a macro for multiple users. There are two problems with the macro. ... A: How are you? The second error you can easily overcome by using always the fullname test.xls. It may ... | |
| Graphs | 10/9/2005 |
| Q: I have been working with my grandson on scatter plots. Having only 2 colums X and Y we have no ... A: How are you? It is nice to see grand father and grand son working together. Congratulations 1st ... | |
| replacing formulas | 10/2/2005 |
| Q: I have made an Excel spreadsheet which contains many rows. Each row has cells for data input, then a ... A: How are you? 1. Assuming you have in B1:B20 the formula =VLOOKUP(A1,$J$10:$K$12,2,FALSE) ... | |
| graph plotting | 9/26/2005 |
| Q: Adelade All I want to do is plot No of people (Y axis) versus How many hours they work on a project. ... A: How are you? Please do the following 1 type data for example in A1:B10 2 insert - chart 3 Select ... | |
| Reset | 9/25/2005 |
| Q: How do I reset info from one column to the next. e.g. i have two columns Prior & Current. When I ... A: How are you? How about the following 1. tools - macro - Visual basic editor 2. select ... | |
| Vlookup and array formula | 9/22/2005 |
| Q: Adelaide, I am using the formula Catg05=$A6 in part of a larger array formula. Catg05 is just a ... A: How are you ? I have tried the following and it works within excel 2003 1. Type (table) b12:1 B13:20 ... | |
| Sort problems | 9/19/2005 |
| Q: I have Windows 98 and Excel 97. For some reason, every now and again, Excel doesn't sort as it ... A: How are you, In Excel 2003, the data is sorted well. I have no means to check what happens with ... | |
| Excel spreadsheet | 9/18/2005 |
| Q: I have two prize lists (Series & HiGame) of bowlers. Bowler can win only once, with Series taking ... A: How are you? Please try the following 1. Tools - macro - visual basic editor 2. insert- module 3. ... | |
| Any Idea On the Future of Excel VBA ? | 9/14/2005 |
| Q: I'm using Excel 2003. With Excel 12 and the new Windows system Vista ahead, what is the future of ... A: oops .... I did not realise that you were referring to Office 12 . It is better to look up the new ... | |
| excel 2000 cut and paste...too much tab space | 9/12/2005 |
| Q: "Excel 2000, Dell computer - Hi - I've programmed a spreadsheet to automatically create ... A: How are you? I am sorry I have not understood what you mean Assuming that you have A1: 55% ... | |
| Sorting Data | 9/9/2005 |
| Q: I have a large dataset of monthly solar radiation values, which I need to sort by latitude in Excel ... A: How are you? I think that you have to split the latitute into 4 columns: Direction,Degrees,minutes ... | |
| copy column if cell is shaded | 9/8/2005 |
| Q: Adelaide, On sheet1 if any cell in F7 thru F3000 are shaded then copy that colum A thru G to sheet5 ... A: How are you? Please do the following 1. Tools - macro - visual basic editor 2. insert - module 3. ... | |
| MTD Total | 9/6/2005 |
| Q: Column A is the current total. Column B is the MTD total. How can I keep a running total in Column ... A: How are you? I do not know if i have understood your problem. But if you mean something like ... | |
| Excel 2000 | 8/29/2005 |
| Q: I want to be able to enter a dollar value or a percent value in one column to produce a result in ... A: How are you? Could something like the following do? 1. Tools-Macro-Visual Basic Editor 2. insert ... | |
| delete record | 8/27/2005 |
| Q: I am very new to this. Could you please guide me as to what would be an easy way to delete a ... A: How are you, agan? Please do the following 1. View - toolbars 2. select Forms 3. Draw a button ... | |
| delete record | 8/26/2005 |
| Q: I am very new to this. Could you please guide me as to what would be an easy way to delete a ... A: How are you? Do you want a VBA solution? or just to delete a row from the spreadsheet? if you want ... | |
| spreadsheets | 8/23/2005 |
| Q: i want to know all the basic steps to make a spreadsheet and also different types of spreadsheet.can ... A: How are you? There are lots of material on the Excel in the Internet. Just look it up in the ... | |
| Wrong Results from VBA CountA Function | 8/22/2005 |
| Q: Adelaide. I am using Excel 2003. I have entered the code below, which works fine, except the ... A: How are you? Please try the following Sub hhh() Set cta = Sheets("June").Range("A1:A2") Set dest = ... | |
| 'Ignoring' values in Excel | 8/15/2005 |
| Q: My problem is that in the dataset, '99999' denotes a failed measurement, or an unavailable value. ... A: How are you? I am always leaning towards VBA programming ... this can be easily done in VBA. Just ... | |
| VBA Transfer Range Values from Table | 8/11/2005 |
| Q: I am using Excel 2003. I am wondering if the following scenario is possible. I construct 2 ... A: How are you? I did not understand completely what you are heading to. But the following is possible ... | |
| Excel VBA - If Statement | 8/10/2005 |
| Q: I need to create an IF statement that checks if a condition does not happen. For instance, If ... A: How are you? Yes <> means different, not equal Have a look at this code Sub hhh() Set ws = ... | |
| Names of worksheet tabs | 8/9/2005 |
| Q: I was hoping that you would be able to tell me if there is a way in which I can print out or return ... A: How are you? Please do the following 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT MODULE 3. COPY ... | |
| Excel-linking data from one Sheet to another | 8/4/2005 |
| Q: I have sheet 1 which is a form with drop down lists and personal details cells for entering data. I ... A: How are you? First try the following Type Hello in A1 of Sheet 1 Select Sheet 2 Select B5 Type = ... | |
| Excel External Data | 8/3/2005 |
| Q: Excel 2003 - Windows XP Hello, I'm currently making an excel document which sources data from 2 ... A: How are you? I dis what you have done in 2003 and the source files did not become Read only. Please ... | |
| Currency calculation problem <> $ and £ | 7/13/2005 |
| Q: ' Premises: ' ' Column 5 / Row 3 contains the Starting Budget in US Dollars - The only ... A: How are you? The problem is that the cell in column 4 have to be formated accordingly to the ... | |
| Calculating hours worked | 7/9/2005 |
| Q: I'm using excel 2000 and would like to know how to calculate the hours worked. Below are the fields ... A: How are you? Please do the following: 0. Type the time in B2:B5 as time, eg. 12:45:00 1. ... | |
| Excel 2000, Complicated Lookup formula | 7/7/2005 |
| Q: you have helped me out a couple of times, all of which proved to be very useful, Thank you. My ... A: How are you? What about the following for E3 cell of Concad sheet ... | |
| How to delete a row | 7/4/2005 |
| Q: I'm using Excel 2000 with Windows XP SP2. In my worksheet, I have data in rows 1 to 125 in columns ... A: hOW ARE YOU? You may try to apply the following Sub deleterange4above() Rem Dim A As Range Set R = ... | |
| to Sum a specified range | 6/30/2005 |
| Q: I have table which has columns from Jan to Dec. It also has rows with values for differrent regions. ... A: How are you? It seems easier than it is the data is in A1:G4 1st. determine the region row and ... | |
| OFFSET | 6/29/2005 |
| Q: I am using Excel 2000 Recently I have discovered OFFSET and want to use it to find the MIN or MAX ... A: How are you? =offset(a2,0,1) refers to the cell B2, i.e. the 0 means that we refer to a cell in the ... | |
| Adding Cells in Multiple Worksheets | 6/28/2005 |
| Q: Is there a shortcut to sum the same cell in 20 worksheets within the same workbook? Excel 2000 or ... A: How are you? There is no sortcut for that. You can use =Sum( Sheet1!a1,Sheet2!a1,.....Sheet20!a1) ... | |
| Excel - Pivot Charts | 6/27/2005 |
| Q: Have successfully created Pivot charts for large amount of information. When I reduce the ... A: How are you? Which Excel version are you using? Please check if you used the data filter (the arrow ... | |
| Protecting all sheets in a workbook? | 6/26/2005 |
| Q: Is there a way to protect/unprotect all the pages in a workbook at one time? A: How are you? You may write a VBA program such as the following 1. Tools - Macro - Visual Basic ... | |
| CHaracter Count | 6/20/2005 |
| Q: How do i find out5 how many characters are in a certain field? I have a list of approximatly 3000 ... A: Rob How are you? To find How many characters A1 contain, type in B1 =Len(A1) To find How many ... | |
| Macro | 4/17/2005 |
| Q: I still have the same error message "subcript out of range" despite using the new source code.Thank ... A: How are you? create book11.xls Create a Book12.xls name sheet1 as ProductA and sheet2 as ProductB ... | |
| IF function | 4/16/2005 |
| Q: the if function in excel,i have a queation in the practical exam that says that if in the table ... A: How are you? A question like that require the followinf thought: If country = "japan" then ... | |
| Macro | 4/14/2005 |
| Q: But I am encountering the error message "subcript out of range". Please advise.Dear Adelaide, I ... A: Please try the following You have to have the 2 workbooks open The book11.xls and the book12.xls. ... | |
| Having color change on linked cells | 4/13/2005 |
| Q: When I link the workbooks I set it at all values and I would have thought that would have done it. ... A: How are you? Please try soething like: The following procedure must be saved in Sheet1 of book1 (in ... | |
| Having color change on linked cells | 4/12/2005 |
| Q: I have workbooks that are linked. I have VBA code to change the color of cells: Private Sub ... A: How are you? The problem is that when you do e.g type in A1 10 type in B1 =A1 You just copy the ... | |
| excel opens 2 or more sheets within same window | 4/11/2005 |
| Q: We have excel2k with sp3 on win2k pro with sp4. my problem is when i open 2 excel sheet both appear ... A: How are you? If you mean Workbooks (files), please do the following 1. Open the 2 workbooks 2. In ... | |
| Dear Adelaide, I have named... | 4/9/2005 |
| Q: I have named worksheets 1, 2 and 3 as "Product A", "Product B" and "Product C". How to use a macro ... A: Please study the following You have to have the 2 sheets (yours and a Book1.xls) open Sub ... | |
| I am trying to make a calculator... | 4/8/2005 |
| Q: I am trying to make a calculator out of excel 2000 that is specific for what I do at work. I ... A: How are you? The only thing I can do is to wexplain how goal seek works 1. Type in A1 10 2. Type ... | |
| VBA / Find & copy Area | 4/7/2005 |
| Q: - could you help me out with this one? Column A contains items by name sorted alphabetic (for inst ... A: How are you? What do you think of the following Sub ggg() Dim A As Range, d As Range Set d = ... | |
| Microsoft Excel 2000 | 4/1/2005 |
| Q: Here is my problem: Spreadsheet #1 Employee # Period End Date 1234 ... A: How are you? Please try the following (I assume your date is in column B in both sheets. The last ... | |
| Excel 2000 | 3/31/2005 |
| Q: Is there a limit to the number of cells a spreadsheet can contain? and if so, what is the limit? A: How are you? Yes, apparently the maximum numbwer of cells is maximum number of rows x maximum ... | |
| I am working with Excel 2000.... | 3/28/2005 |
| Q: I am working with Excel 2000. Spreadsheet, I have a basic spreadsheet with 1 formula adding two ... A: How are you? 2nd Question 1.Select A1:A2 2. Format - cells - number - text 3. type 001 in A1 type ... | |
| Macro to automate copy - paste task | 3/17/2005 |
| Q: I have a workbook with 13 sheets. Worksheet1 is the main working sheet, the remaining 12 sheets ... A: How are you? Please try the following - just for the date. For the other calculations you it is ... | |
| Combo Box | 3/14/2005 |
| Q: I'm still working on getting a combo box to open a file in a directory, then when I click on another ... A: How are you? Please see SourcePath = TextBox1.Text ' Either you type the last slash eg. C:\expe ' or ... | |
| excel sort | 3/13/2005 |
| Q: I have a list that when I sort it in descending order it performs correctly but when I sort in ... A: How are you? The problem is that your rows are not empty. They store spaces. If you type in an ... | |
| coloms | 3/11/2005 |
| Q: I have an excelfile that has 3 coloms and 445 rows of data. I want to split this in 18 coloms and ... A: How are you? It is not the entire solution, but you can start from the following 1. Tools - macro - ... | |
| Linking Worksheet/Workbook Cells in Array Formula | 3/10/2005 |
| Q: I'm fine, and I hope you're doing well, too. My apologies for not supplying enough info. Here is ... A: I am glat that you are fine. The easiest way is to save the summmmary data in another Workbook. ... | |
| Linking Worksheet/Workbook Cells in Array Formula | 3/9/2005 |
| Q: I'm working with Excel 2002 and need some help. I have a workbook which contains 5 worksheets. ... A: How are you? As I do not know either data or format you want to summarize, I can give youjust a very ... | |
| Combo Box linking macros | 3/8/2005 |
| Q: I'm still not understanding how to do the combo box. Like I said, I'm not all that great at VBA. ... A: How are you? 1. I will try to explain better the example: You have 2 macros named respectively Ab ... | |
| Counting numbers | 3/7/2005 |
| Q: I am facing problem in counting numeric values in a cell. eg: A1 cell contains 1,4,5 Answer I ... A: How are you? Please do the following 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT MODULE 3. ... | |
| Excel 2000 Macro | 3/6/2005 |
| Q: I created a macro in Excel 2000 to help me do some moving of information. After I was done, I wanted ... A: How are you? Please do the following: Run Excel Open the file where the macro was stored Tools - ... | |
| currency conversion | 3/5/2005 |
| Q: Is there a function or other tool in Excel 2003 that can convert US dollar currency into another ... A: How are you? As far as I know thereis only the convert to Euro addin. But you can write a VBA ... | |
| Combo Box linking macros | 3/4/2005 |
| Q: I have another question. I have all of our customers and their addresses in macros. It's a long ... A: How are you? Yes, it is possible. You can also design a menu of comands or a toolbar. Just draw the ... | |
| Inserting rows in a linked spreadsheet | 3/3/2005 |
| Q: I have been working on a solution for quite some time now, and don't seem to find it. I have a first ... A: How are you? Please try the following 1. Open your master file (aaa.xls) 2. Create a new file ... | |
| Excel - Date and Time - Macro | 2/28/2005 |
| Q: I would like to create a macro with the current date and time, however, I do not want that date and ... A: How are you? Please see the following Procedures: Sub currenttime() t = Time() d = Date MsgBox ... | |
| random selection | 2/24/2005 |
| Q: Setting up a lap scoring spreadsheet for karting, has 13 sheets for each class of racing. The ... A: How are you? I am sorry but I have not understood your problem. To generate numbers between 1 and ... | |
| functions | 2/23/2005 |
| Q: Is there any way to get Excel to look across a a section of row of data organised: ... A: How are you? I do not know any buitl-in function that does that. But you can try the follwing ... | |
| Format a control | 2/22/2005 |
| Q: I am trying to add a combo box control from the control toolbox. Once I insert it in my ... A: How are you? I guess that you are drawing a combo box from the control toolbox and you want to use ... | |
| Linking worksheets | 2/22/2005 |
| Q: We have several worksheets that have some of the same information on each worksheet. I would like ... A: How are you? I wonder how you linked the files. If you open 2 files simultaneously and on A1 of the ... | |
| Excel Workboon Open Event | 2/17/2005 |
| Q: There was an error in my Work Book event which automaticlly closes the work book after certain ... A: How are you? The easiest thing I can suggest is: 1. To set the macro security at medium level ... | |
| numbering rows | 2/16/2005 |
| Q: I would like to be able to list a numbers down column A in my spreadsheet to refer to the details to ... A: How are you? I wonder whether the following is too simplistic, but there it goes: 1. type 1 in A1 2. ... | |
| Filtering data | 2/14/2005 |
| Q: I am using Excel 2000 I want to make a combo box display selected info eg. 670 YSYY 581 YPAD 795 ... A: How are you? Please try the following 1. Type in A1:A5 YSYY YPAD YPAD YMML YMBA 2. View - ... | |
| partial search field | 2/9/2005 |
| Q: I'd like to have a field on a spreadsheet where I can enter a partial peice of data (in this case ... A: How are you? 1. Type the part numbers in A1:A12 (e.g. 141,121,123,140,145,150,148, etc.) 2. Type ... | |
| Excel Dialog Boxes | 2/8/2005 |
| Q: I have Excel 2000. My company sent out a quality survey to our customers and I am responsible for ... A: how are you? Maybe the following can help you: Assuming that in sheet 1 you have the results, ... | |
| Unable to perform Vlookup function | 2/7/2005 |
| Q: I am working in a workbook with two worksheets. The first worksheet contains a column of 'copied' ... A: How are you? I have checked your formula and it is ok. But you can use ... | |
| VBA macro | 1/27/2005 |
| Q: I have a Macro that generates a file. Is there a way to excute the contents of that file in VBA? A: How are you? It depends on the file that is generated by the macro. You can for instance generate ... | |
| Format Button | 1/26/2005 |
| Q: I have a wierd problem. When i try to add those two buttons Sheet right to Left and Sheet left to ... A: How are you? I tried and had no problem. Did you do the following: 1. TOOLS - CUSTOMIZE TAB ... | |
| How to split an excell field | 1/25/2005 |
| Q: The excel practitioner in our company was supposed to enter the data in two different fields. But he ... A: How are you? Please try the following example Suppose you have the following data in A1:A4 Tony ... | |
| What is Excel? | 1/24/2005 |
| Q: What is Excel and What is is used for{the usefulness/advantages}I have been trying to do an homework ... A: Excel is a powerful calculator that allow to compute complex calculations by resorting to built in ... | |
| Transferring data | 1/21/2005 |
| Q: I am well thank you how are you? When I past over the top of the last procedure I go to try it out ... A: Please replce the line dsheet = TARGET.Cells(1, 1).Value by dsheet = TARGET.Cells(1,0).Value The ... | |
| Transferring data | 1/20/2005 |
| Q: It is nice meeting you too. Thankyou for your quick response to my question. Sorry I did not reply ... A: How are you? Please copy the following over the last procedure I sent to you Private Sub ... | |
| Transferring data | 1/19/2005 |
| Q: I still consider myself as a newbie of Excel as I do not do a lot of work with it. As I am starting ... A: How are you? Please do the following TOOLS - MACRO - VISUAL BASIC EDITOR VIEW-PROJECT EXPLORER ... | |
| Can Arrays do Column A - B = Column C? | 1/17/2005 |
| Q: I am using Open Office 1.1.4. My understanding is that it functions in the same way the Excel does ... A: How are you? Please try the following 1. Type the selling price in A1:A10 2. Type the dealer ... | |
| Excel Date | 12/15/2004 |
| Q: When I enter 1/20 in a cell, it automatically adds the year 2004 instead of 2005. I have changed the ... A: How are you? This has to do with your system date. The current year is 2004, so if youdo not ... | |
| Fill up a triangle in Macros | 12/14/2004 |
| Q: I need to fill up a triangle made with 3 lines. I did a triangle with 3 lines, i unit that lines and ... A: How are you? The easier way is to use the freeform lines of Autoshape in the Drawing toolbar. You ... | |
| Microsoft Exce | 12/10/2004 |
| Q: what two types of ranges can be used in microsoft excel? Please list the structure of a function. A: How are you? Please see the following example 1. tools- macro - vbe 2. Insert- module 3. copy ... | |
| Left and right | 11/30/2004 |
| Q: I have a number of columns of data in excel in the format of A1-C6 how can I write one formula that ... A: How are you? Do you want to swap the lines with the columns? If this the case use 1. select E1:J3 ... | |
| Changing font to all caps | 11/23/2004 |
| Q: Is there a way to make text in Excel all caps without doing a formula in a different cell or ... A: How are you? Please do the following 1. tools - macro - visual basic editor 2. insert - module 3. ... | |
| list files | 11/19/2004 |
| Q: I use a local net with lots of files of different type and I would like to be list the files going ... A: How are you? 1. Tools-macro-visual basic editor 2. insert-module 3. copy Sub AllFilenames() Rem ... | |
| Excel VBA | 11/18/2004 |
| Q: Good evening ADELAIDE CARVALHO, I am recording macro as a beginer level but I am encountering ... A: How are you? Please try the following: 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT5-MODULE 3. ... | |
| Excel AutoFilter | 11/10/2004 |
| Q: I am using MS Office XP Profesional on Windows 98(SE). In a Worksheet in Excel, a field contains ... A: How are you? Yes,there is something wrong with Autofilter.It does not work with numbers but it ... | |
| office 97 and windows xp | 11/7/2004 |
| Q: I have developed a file in excel 97 with lots of macros, buttons eccetera and I've moved to office ... A: How are you? The only thing I can think of is that your file is Read only So you have to select ... | |
| Sum for a date range | 11/3/2004 |
| Q: I need the total sales for product 1 for the given date range (2-Jan to 10-Jan). I need a formula ... A: How are you? The best way to sum up the data by product and date is to use the data - pivot tables ... | |
| consecutive days, months etc.. | 11/1/2004 |
| Q: If I want to create a list of consecutive numbers in a row of fields I only need to copy the number ... A: How are you? there as=re several ways to do that. The easiest one is selecting Edit - Fill - Series ... | |
| Lastrow command | 10/27/2004 |
| Q: Adelaide - thanks for your rapid answer! I'm still having some problems - the following is the code ... A: How Are you? Please try the following: Sub ggg() Dim a As Range Set a = Range("A65536") ' find ... | |
| Error trapping | 10/22/2004 |
| Q: When loading a large amount of data into excel using vba code, I sometimes get an out of memory ... A: How are you? Do you think you can use the following to find a solution to your error: Sub gg() On ... | |
| excel text formatting | 10/15/2004 |
| Q: One of my columns has the following text: 00011111234 These are text, not numbers. They represent a ... A: again You can also do: 1. E.g. Your parts numbers are in A2:A10 2. Convert A2:A10 to numbers ... | |
| Leading zeros in a column in Excel spreadsheet | 10/13/2004 |
| Q: I need to insert a leading zero in front of a nine character text field for an entire column. ... A: How are you? Please do the following: 1. Tools - macro - visual basic editor 2. insert - module 3. ... | |
| Excel Copy Data | 10/6/2004 |
| Q: Followup To Question - Hi, I would like to know what the easiest methods can copy mass data ... A: How are you? By pressing the 3 keys (ctrl +Shift+Enter) you indicate that the function Transpose ... | |
| Excel Copy Data | 10/5/2004 |
| Q: I would like to know what the easiest methods can copy mass data listing in horizontally to listing ... A: How are you? Ctrl+Shift+ Enter means that you have to hold down the keys Control (ctrl) and Shift ... | |
| Excel Copy Data | 10/4/2004 |
| Q: I would like to know what the easiest methods can copy mass data listing in horizontally to listing ... A: How are you? Please try the following: 1. Select the data 2. Edit - copy 3. Select the first cell ... | |
| Excel features | 9/30/2004 |
| Q: What I want to ask about is that, how to use features about goal seek, scenario, form, subtotal in ... A: How are you? There are various applications of these features. 1st Goal Seek a1: 10000 pounds ... | |
| FIFO accounting for security trade data | 9/28/2004 |
| Q: I am wondering if you can help. Please be aware that I am NOT an Accountant. I need to calculate ... A: I wondered if I got it right. 1. A1:A1000 Date B1:B1000 purchases C1:C1000 sales D1:D1000 ... | |
| Hiding Formulae | 9/27/2004 |
| Q: I'm trying to put together a quiz using excel for my staff. Someone has shown me a basic formula to ... A: How are you? Please do the following: 1. A1:A10 Questions B1:B10 Range for the user to answer D1:D10 ... | |
| Printing with Excel | 9/25/2004 |
| Q: I am using Excel 2000 and 97 At the moment I am moving selected small Spreadsheets of the same row ... A: How are you? Please try the following: Sub PreviewingAll() Application.ScreenUpdating = False ... | |
| Excel | 9/24/2004 |
| Q: How to use "OFFSET" & "DPRODUCT" function in Excel Explain with one example A: How are you? I think that the best thing you have to do is to look up these functions in trhe Excel ... | |
| Excel question | 9/16/2004 |
| Q: yesterday i sent one mail to you regarding "pivot table in Excel, i have received your mail and i ... A: How are you? Sover is used for maximising or minimising a function subject to some contraints. E.G. ... | |
| How to use "pivot table" report... | 9/15/2004 |
| Q: How to use "pivot table" report in Excel with one Example A: How are you ? Pivot tables are useful for grouping data. E.g. Data about the monthly sales. A1: ... | |
| excel function | 9/11/2004 |
| Q: i would like to know how i can take a row of numbers find the maximum number, and then post a ... A: How are you? The following is simply but not entirely what you like: 1. Your data ia in A4:E5 2. In ... | |
| command button | 9/8/2004 |
| Q: I have had good success in creating command buttons and writing syntax for them, but I would like to ... A: How are you? Intersting question!! Please assigned to your button the following procedure: Sub ... | |
| Microsoft Excel 97 VBA | 9/7/2004 |
| Q: I have developed a VBA Form that collects information from the user. When the user has input all ... A: How are you? I have tried the following 1. Allocated the name Texto to A1 2. Draw a userform with a ... | |
| User search using InputBox method | 9/1/2004 |
| Q: I am trying to develop an InputBox which users can enter a value (in this case a course code)into - ... A: How are you? Please do the following 1. view - toolbars - control box 2. Select Edit mode 3. Click ... | |
| User search using InputBox method | 8/31/2004 |
| Q: I am trying to develop an InputBox which users can enter a value (in this case a course code)into - ... A: How are you? Please try the following 1. view - toolbars activate controlbox 2. Draw a command ... | |
| SUMIF & IF | 8/29/2004 |
| Q: I am trying to create a work book that checks 2 ranges before doing sumif calculation. I am using ... A: How are you? Please think about the following a) Use the simplest formula ... | |
| Excel | 8/27/2004 |
| Q: Here is my problem. In column A, I have a list of task (452 in all) In column B, I have another list ... A: How are you? Please try the following 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT - MODULE ... | |
| Linking Workbooks | 8/26/2004 |
| Q: I am looking for a way to remove links from another workbook.I have several links in each workbook, ... A: How are you? Please do the following in Excel 2002 or Excel 2003 1. Open the workbook 2. Edit - ... | |
| tab direction through a worksheet | 8/25/2004 |
| Q: i've got a relatively basic excel worksheet i'm working on. The problem i'm having is that the ... A: How are you? It is easy to move the cursor to the cell below when you press Enter: 1.tools-options ... | |
| Excel | 8/20/2004 |
| Q: This is my question which I have already come to a point (as I hope). If I have the number 15 in a ... A: How are you? I know that this is not what you want, but maybe you can work out the solution from ... | |
| excel vba | 8/17/2004 |
| Q: Pls check what's wrong with the VBA below. It doesnt work - to be exact, it works partially and has ... A: How are you? Please see the following Sub Delete_row() Dim A As Range Set A = Range("a6:P40") r = ... | |
| 32000 data points in Excel | 8/14/2004 |
| Q: How do I create a chart which contains more than 32000 data points in 2D. The error in Excel states ... A: How are you? I have tried to draw a chart with source-data located in A1:B32000 and there is no ... | |
| Excel | 8/13/2004 |
| Q: I would like to do an average from an array with few criteria. Column A: Date Column B: numbers ... A: How are you? Please try the following 1st TOOLS - MACRO - VISUAL BASIC EDITOR 2nd insert-module ... | |
| returning values | 8/12/2004 |
| Q: i I'm writing this program using VBA I've got a list box that when you select an item it asks you ... A: How are you, The best way to solve your problem is saqve the length of the materials in a range of ... | |
| Looking at columns and linking them using VBA | 8/11/2004 |
| Q: Looking at columns and linking them using VBA Hi I'm having problems working out how to write in ... A: I am sorry I did not read your question properly After choosing the item in the list box you get ... | |
| Excel Worksheets | 8/10/2004 |
| Q: Is there a function I can use in Excel VBA that returns true if a sheet name exists in a workbook ... A: How are you? Please try the following: 1. Write the name you are looking forward in, e.g., A1 of ... | |
| List Boxes | 8/10/2004 |
| Q: Is there a way to change the font size and type within form list boxes within Excel 2000? I've ... A: How are you? There is sure;ly a better way to do it but it seems that the esiest way is to use a ... | |
| Conditional operations | 7/28/2004 |
| Q: How can an Excel operation be made to depend upon the condition found in one of its cells (i.e.: how ... A: How are you? Please try the following: 1. Type London in A1 2. Type in B1 =IF(A1="London", ... | |
| Need macro to print sheet with multiple repetitions | 7/26/2004 |
| Q: I have an excel-based sales report with charts, etc. The territory number in cell A1 determines the ... A: How are you? I am sure it does not solve your problem, but it may help to start 1 TOOLS - MACRO - ... | |
| Cell color | 7/24/2004 |
| Q: Is there a way to know whether the cell is colored or white and to give the result as a number (o or ... A: How are you? Please try the following 1. Tools - macro - visual basic editor 2. insert - module 3. ... | |
| Rounding in Excel. | 7/22/2004 |
| Q: Actually I needed to put #0.0 because if I used #.0 numbers like 0.7 were converted to .7 from ... A: How are you? Your site is very interesting. Congratulations and keeping Excelling If you want to ... | |
| transferring date formating | 7/20/2004 |
| Q: I'm using the following code to transfer info from column A of a log file to the end of column A in ... A: How are you? Please, try the following: (basically I copy first the formats of sourcerange to dest ... | |
| Rounding in Excel. | 7/19/2004 |
| Q: I am trying to round numbers in Excel to one decimal and I want a decimal to be included even with ... A: How are you? a) To round the numbers to a decimal place, please do the following 1. Select Range 2. ... | |
| excel | 7/17/2004 |
| Q: I have two quetions. one is can I encrypt my spreadsheet so noone can make changes to it. and the ... A: How are you? Q1: You can protect the Spreadsheet against unauthorised changing. Please See Tools - ... | |
| Transposing Data into Subgroups | 7/16/2004 |
| Q: I'm using Excel 2000 in Windows 98. I have collected a large population of test result values ... A: How are you? Please try the following: 1 TOOLS - MACRO - VISUAL BASIC EDITOR 2 INSERT - MODULE 3 ... | |
| Find the right most number in a row | 7/14/2004 |
| Q: Sorry for the delay. AllExperts kept telling me your address was “Maxed Out” and I had no alternate ... A: How are you? Please try the following: Sub righmost() Dim sourc, dest Set sourc = Range("e1:ai1") ... | |
| count repeated items | 7/10/2004 |
| Q: I have this list that gets populated from another source automatically. When i get this list I need ... A: How are you? Please try the following 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT - MODULE 3. ... | |
| Excel - Auto fill function | 7/8/2004 |
| Q: Adelaide, I have a column of data within my Excel 2000 spreadsheet that has many blank fields ... A: How are you today? Please try the following program in VBA 1. TOOLS - MACRO - VISUAL BASIC EDITOR ... | |
| VBA timed event | 7/5/2004 |
| Q: I am using Excel 2000, running on XP Home. I am trying to create a macro that runs on time ... A: How are you? Please try the following: 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. SELECT THISWORKBOOK ... | |
| RE: Macro and importing text file into excel. | 7/4/2004 |
| Q: I would like to import text file into excel and have macro copy the imported text in two different ... A: How are you? I am sorry but you have to tell me more details about what you want. For starting ... | |
| Pivot Table problems | 7/2/2004 |
| Q: I am having problems creating my pivot table. No matter how I manipulate the fields, I cant seem to ... A: I think it is better to try to explain it with a small example. E.g. Database A1: type the heading ... | |
| VBA and remote file references | 7/1/2004 |
| Q: Excel 2002. I am trying to write a converter that takes an input file moves some of the columns ... A: I hope you are well. Will the following helps you? Sub ggg() Dim A As Workbook, mystr As Range Set ... | |
| selecting cells on different sheets | 6/30/2004 |
| Q: i.e. I'm in B13 on sheet1, how do I go to B13 on sheet2 with VBA? Any help is appreciated. A: How are you? Please, run the following code 1 TOOLS - MACRO - VbISUAL BASIC EDITOR 2 INSERT - ... | |
| Multiplication / sum on parts of a number | 6/24/2004 |
| Q: - I wonder if you can help me out with a better way of solving this question... Column A = bank ... A: How are you? Please do the following: 1: Type tthe balance amounts in a1:A10 2: Type 0 in D3, 1000 ... | |
| Calculating Weekending Date | 6/21/2004 |
| Q: Adelaide, I have excel2K and am entering a lot of data that is placed on a daily basis. I need to ... A: How are you? The only thing I can think of now is that you add to each record the date of the last ... | |
| commands | 6/20/2004 |
| Q: I would like to have the following commands on my toolbar, but I can not seem to get them there. ... A: How are you? To add buttons in toobars, please do the following 1: TOOLS- CUSTOMIZE 2: TAB ... | |
| Check Digits? | 6/19/2004 |
| Q: In order to use California Employment Development Department (EDD) Electronic Funds Transfer (EFT) I ... A: How are you? Please try the following: 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT - MODULE 3. ... | |
| Scheduled Printing | 6/18/2004 |
| Q: Jan, I need auto print a selection of excel worksheets and charts at 09:30am every Monday. My ... A: I asm sorry but I cannot help you much ... I am a bit busy but I will give you this hint to start ... | |
| VBA for Excel problem | 6/16/2004 |
| Q: I want to calculate a tax like this example: First 1150 kilos, tax = 34.00 per kilo Next ... A: How are you? The logic could not be entirely correct as I did not pay proper attention but the ... | |
| combine cols from 2 w'books | 6/15/2004 |
| Q: Office 2000- I need to take say col D from sheet1 and cut/paste to sheet2 col D. But sheet2 col D ... A: How are you? There is certainly better ways to synchronise your work with your coleague. Yet, the ... | |
| Macro | 6/11/2004 |
| Q: How do you delete a macro from your toolbar? The macro no longer exists but the toolbar still has ... A: How are you? Please do the following: 1. Tools - customise 2. Drag the button you want to delete ... | |
| Excel error when changing tab name | 6/8/2004 |
| Q: My colleagues and I are getting an Excel error message I've never seen before. After changing a ... A: How are you? Can you re-type the sheet name? I am using Excel 2003, and Program is a valid name ... | |
| Excel vab 'Next' statement | 6/7/2004 |
| Q: You helped me successfully last year so I am hoping that you can do the same again. I'm desperate ... A: How are you? Just delete it the end if statement and everything will be fine. Sub Button1_Click() ... | |
| macros | 6/6/2004 |
| Q: If I may, I'd like to ask a two-part question. Firstly, to execute some of my macros I use contol-a ... A: How are you? Please try the following: 1. TOOLS-MACRO-VISUAL BASIC EDITOR 2. INSERT - MODULE 3. ... | |
| macros | 6/4/2004 |
| Q: i do not know alot about exel but i know how to use it to a certain extend. i have imported some ... A: How are you? What about the following: Sub periods() Dim A As Range Set A = Range("a1:A20") ' ... | |
| Excel | 6/3/2004 |
| Q: I have an assignment to create a task which I did on salary proposal. I am to do a "what if" ... A: How are you? Tpo perform a what-if analysis you can: use TOOLS - SCENARIOS (for analysing ... | |
| Excel database | 5/31/2004 |
| Q: I need help with a procedure I wish to perform in Excel 2002. It involves a search procedure. What I ... A: How are you? Please try the following 1. Write yor records in A1:F15 2. Tools-macro-VBE 3. Insert ... | |
| Matrix in Excel | 5/25/2004 |
| Q: I have a five x five matrix in Excel (B2:F6), with header descriptions in row 1 and column A.[Excel ... A: How are you? Please try the following function: =index(B2:F6,2,2) B2:F6 is the matrice, A3 refers ... | |
| Rounding problem in Excel | 5/20/2004 |
| Q: I am currently working on a sheet with many interest baring numbers and am rounding up to the ... A: How are you? The easiest way is to use temporary Column A1: 125.3358404 A2: 33.91638312 B1: = ... | |
| Filenames from Windows Explorer to Excel | 5/14/2004 |
| Q: I have a folder on my PC hard-drive that contains hundred of folders named by a series of numbers. ... A: How are you? Please do the following 1. Tools-macro-visual basic editor 2. insert-module 3. copy ... | |
| Average Formula | 5/14/2004 |
| Q: I am using Excel 2000 9.0.6926 SP-3 and am trying to write a formula that will average the 8 latest ... A: How are you? The simplest i can suggest you is the following Assuming you have in A1:A9 1,2,3, ... | |
| excell worksheet | 5/13/2004 |
| Q: I have various work books with an extremely large number of worksheets To open one now I go to the ... A: How are you today? You can run the macro by selecting TOOLS-MACRO-MACRO Or as I purposed you can ... | |
| excell worksheet | 5/12/2004 |
| Q: I have various work books with an extremely large number of worksheets To open one now I go to the ... A: How are you? You can do the following: 1. TOOLS-MACRO-VISUAL BASIC EDITOR 2. INSERT-MODULE 3. COPY ... | |
| compare columns | 5/11/2004 |
| Q: I have 4 different excel sheets with names on them. I have to compare these 4 sheets with one ... A: How are you? Please truy the following Assuming that the names in sheet2, sheet3, ... are in A1:A3 ... | |
| vba | 5/10/2004 |
| Q: I use the VBE Module coding below to automatically change the value of an Excel speadsheet cell at a ... A: lock How are you? I wonder if the following suits you, but it can at least be a starting point for ... | |
| Forms | 4/17/2004 |
| Q: I am totally new to Excel forms. I need to make a form that loads automaically and its main purpose ... A: How are you? Please try the following 0th Type the list of optins in F1:F6 1st TOOLS-MACRO-VBE 2nd ... | |
| Time change on certain dates | 4/13/2004 |
| Q: Adelaide Using Excel 2000 I live in Adelaide in South Australia. In summer we have a system where we ... A: How are you? I am sure that one day I will visit "My City". when people do not understand my ... | |
| VB using find | 4/7/2004 |
| Q: box = Text4.Text prompt$ = " enter the BTS" searchstr$ = InputBox(prompt$, "bts") test = searchstr$ ... A: How are you? I cannot answer your question because I cannot access the external database you ... | |
| VLOOKUP won't work within SUMPRODUCT | 4/5/2004 |
| Q: Desired goal: To sum the sales by PRODUCT by REGION. The source data worksheet has 3 columns: ... A: How are you? I think that the best way to do it is to: 1st Insert an additional column between ... | |
| Formula to Sort a list | 3/17/2004 |
| Q: First of all thanks for your time and help and I'll try and make this as painless as I can for you ... A: How are you? Please think about the following: Assuming your data is in A1:A8 1st. Type in B1 ... | |
| Opening My Excel Files | 3/15/2004 |
| Q: I have a problem when opening a couple of my MS Excel Files. The files are password protected and ... A: How are you? The only reason for your problem I can think of is that the file you are trying to open ... | |
| Copy a range | 3/12/2004 |
| Q: Adekaide, Excel 2000 on XP I have done a lot with macros but this is stumping me. Your help is ... A: How are you? Does the following helps you? 1st I named the range A1:D3 of Data.xls as Porto 2nd I ... | |
| Editing Excel 2000 | 3/11/2004 |
| Q: My questions is pretty simple. I want to change part of a column of numbers (i.e from $.70 to $.75) ... A: How are you? Oops ... I think that I did not understand your question. If you want to sum 5 to, ... | |
| Option Button | 3/10/2004 |
| Q: I have used option buttons in the more complete VB programs in the past and understand that when I ... A: How are you? The first you are missing is that you have to insert each group of option button in a ... | |
| repacing value by a macro | 3/7/2004 |
| Q: I just want to know one thing more. I've defined 3 regions in the excel sheet. All the 3 have equal ... A: How are you? Qith a few alterations the following will do: 1st. Region 1 -> a1:B3 Region 2 -> ... | |
| How to lock a cell so you can't even click in it | 3/6/2004 |
| Q: I know how to lock a cell so that the user can't even click that cell in Office XP, but I can;t ... A: How are you? I do not have Excel 2000 installed but what I can remember is the following: 1st Format ... | |
| Combining 2 or more cells into 1 | 3/5/2004 |
| Q: I pasted to a worksheet a list of folks with Name Address date and remarks. PROBLEM name is in A1 ... A: How are you? The easiest way, not the most efficient, is: 1st Type in B2 =A2&" "&A3 2nd Delete A3 ... | |
| Excel as an Inventory management tool | 3/4/2004 |
| Q: I have recently been given the job of maintaining our offices inventory of contracts, catalogs, ... A: How are you? Yes, it is possible to set up a worksheet for controlling your inventory. Maybe, you ... | |
| excel 97 combo box | 2/29/2004 |
| Q: Sorry if this is a simple question but I am fairly new. I made a combo box in excel and it works ... A: How are you? I have Excel 97 no more but it must be pretty the same as Excel XP in that case. Please ... | |
| Command Button display | 2/25/2004 |
| Q: I have a follow-upI did what you said and I was able to set up the command button on the screen. ... A: How are you? You can instead use the command button of the controls' toobar. Yet, the procedure is ... | |
| Command Button display | 2/24/2004 |
| Q: When I first open my workbook from the Excel menu bar, but before any macros are invoked, I'd like a ... A: How are you? I think that you can start simply: 1st. Change the style that applies to your ... | |
| hyperlink | 2/23/2004 |
| Q: I have copied a list of companies from a website. Each company's name has a hyperlink to its own ... A: How are you? I am sorry but I could not find the proper solution. But please, play around with the ... | |
| locating a matching value | 2/19/2004 |
| Q: I have a word written in a cell. I'm trying add a sequence to a macro that will identify the single ... A: How are you? Please have a look at that one Sub searchingword() Dim A As Range, B As Range Set A = ... | |
| Hlookup and N/A | 2/17/2004 |
| Q: I have a routine that identifies a range on another worksheet and assigns variables to it. A ... A: How are you? I have tried the following function ( it does really not matter the involvement of 2 ... | |
| Function to calculate age | 2/14/2004 |
| Q: What function can I use to calculate the current age of someone? I would like to age to update as ... A: How are you? If you want to compute the age in years: A5: birth date e.g. 15/03/1970 B5: =today() ... | |
| fornulas | 2/12/2004 |
| Q: I am a Chemical Applicator and i need to keep records of the application I do. I need to set up a ... A: How are you? I would do the following A1: Mix rate (100) B1: Water for the Mix rate (1.5) C1: Mix ... | |
| Activate Spell Check Button | 2/11/2004 |
| Q: Is there a way to activate the spell check button, using Excel 2000, if you have protected the ... A: How are you? I am afraid that you cannot activate the spell checker in a protected sheet. The spell ... | |
| Re-assign Del/Dot Key | 2/9/2004 |
| Q: My question is - How do I re-assign (or just null, even) the Dot/Del key on the numeric keypad? ... A: How are you? I did not know that we could found the name Adelaide in the USA. My name is a family's ... | |
| Time Tracking | 2/6/2004 |
| Q: I need to figure out the following: Employee 1: Day 1 Clock In: 8:00 AM Clock Out 5:00 PM Day 2 ... A: How are you? Please, try the following: 1. Type the start time and end time just like hh:00 PM or ... | |
| formula so you can get the answer matching 2 different citeria from different columns within a spreadsheet | 2/4/2004 |
| Q: excel both 97 & 2000 from the table below I am trying to get the individual totals of the named ... A: I hope you are well. The easiest way to do this is by using pivot tables. 0th Let's assume that your ... | |
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Adelaide carvalho
Top Expert on this page
Expertise
I will be able to answer any question on Excel and Visual Basic for Applications - class modules, recursive procedures and functions are my favourite
Experience
Past/Present Clients
Several readers of my Books think they are useful.
©2012 About.com, a part of The New York Times Company. All rights reserved.