| Subject | Date Asked |
|
| 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 ...
|
