excel spreadsheet, excel 5, zeros: Hi Jimmy1 How are you? Please do the following: 1. Tools - macro - visual basic editor 2. insert - module 3. copy Sub leadingZero() Dim A As Range ad = InputBox( Type the range that requires a leading zero ) Set A = Range(ad) For Each c In A ...

Excel: Learning Excel, learning excel, wopr

learning excel, wopr, allexperts: (a) use the online help - this is helpful as long as you can use it (b) www.wopr.com is the site I use for discussions about Excel - possibly too involved for learning though (c) use me when you get stuck - doing is the best way of learning in Excel - either...

Excel: Learning functions, cell b2, excel 5

cell b2, excel 5, 3 words: Hi Marina How are you? The only thing you have to do is: 1. Tools - macro - visual badsic editor 2. Insert module 3. Copy the code to the Window that opens when you do insert module 4. File - close and retun to Excel 5. type in a1 I am Portuguese...

Excel: Len query, ms excel 2000, conditional formatting

ms excel 2000, conditional formatting, colums: Suppose the range is A1:M23. It d be easy to find the longest cell by conditional formatting: 1: Select the range (A1:M23) 2: Format/Conditional Formatting... 3: Change Cell Value Is to Formula Is 4: assuming A1 is the active cell, enter this formula:...

Excel: FOR THE LIFE OF ME I CANNOT..., hp 7760 printer, unwanted backgrounds

hp 7760 printer, unwanted backgrounds, office apps: Hi Barb, You have posted this question in the Excel newsgroup and there isn t an Excel question here. However, with regards to my experience with my digital camera, I would use the software that came with the camera. This type of software has more picture...

Excel: LINKING, xls

xls: A number? Sounds like you d want [23.XLS]Sheet1!$A$8. Is that right? In any case, I think you re looking for the INDIRECT function: =INDIRECT( [ & B12 & .XLS]SHEET1!$A$8 ) would take whatever is in B12 and replace filename in your example. The hitch...

Excel: LINKS, master spreadsheet, private question

master spreadsheet, private question, e numbers: Hi Chris, I don t recall that you can do sorting with both sheets highlighted. On the second sheet, it does maintain the links to the first one. With my #1 suggestion, you should be able to do formatting with both tabs highlighted. You can try e-mailing...

Excel: Likert (1-5) scales in Excell, option boxes, check boxes

option boxes, check boxes, percentage mark: you can t link option buttons to different values -- you link to a cell. A series of option buttons all link to the same cell unless they re inside a group box. It d be easier to show you what you need to do it you could send a sample workbook to me at bobumlas@yahoo.com...

Excel: Limit of 255 characters in a cell...when copying, rejection notice, fondest dreams

rejection notice, fondest dreams, ioline: I d suggest that you copy those individual cells AFTER you do the entire sheet copy. The number of cells should be relatively small and therefore the EXTRA copying should not slow down the process. I have had to do this in the past and there is no performance...

Excel: Limit of 255 characters in a cell when copying, rejection notice, fondest dreams

rejection notice, fondest dreams, ioline: Steve, Sorry for the delay in giving you the answer. I just spent several hours helping another person from AllExperts and developing your code and testing it has taken a while. Copying a sheet has the problem you describe. You can add a sheet and...

Excel: Limit Page Rows on Worksheet, aesthetic purposes, gridlines

aesthetic purposes, gridlines, thanks a bunch: The simplest way is to just Format Column Hide everything to the right of col F, and Format Row Hide everything below 100. For aesthetics, you might also look at the Tools Options View menu, which allows you to not show gridlines, or row/column headers,...

Excel: Limitations for SubDirectories ?, distinct names, group2

distinct names, group2, group1: I see no problem with this, ALTHOUGH it s really a system question - I think you are remembering the nested subdirectories problem, which relates to the length of the path - I m not aware of any problem with subdirectories coming from one directory as each...

Excel: Limited budget automate 2500 cut/paste/format entries from internet to EXCEL worksheet., credit application form, real estat

credit application form, real estat, worksheet cells: Wesley, I have to say that you are in a bit of a handicapped position. Let me explain. Because the county built the web site in an interactive way, it isn t possible for you to simply access web pages from Excel - you probably knew that. Anyway, what that...

Excel: Limiting Access to an Excel File, excel vba, excel sheet

excel vba, excel sheet, stupid questions: Hi Ankit It is possible to attemp to prevent file opening via excel once it it open and a user has logged into that sheet. One candisable the menu options etc. Unfortunately all any one has to do is to open a second instance of Excel or simplely use...

Excel: Limiting drop-down menu choices based on previous choices, independent choices, data validation

independent choices, data validation, menu choices: Excel has a problem with using data validation lists and non-continuous ranges. This means, for example, you cannot directly have a list of 11 items and tell the data validation drop-down box to only select item 1, 5, and 8. It is simply a limitation of...

Excel: Limiting spreadsheet size, spreadsheet program, z100

spreadsheet program, z100, school teacher: How about hiding the extra rows and columns, Luke? Try this: 1) Press F5. The Go To box appears. 2) In the Reference field, enter: 101:65536 All the rows from 101 down are selected. 3) Right-click inside of the selected area and choose Hide....

Excel: Limiting spreadsheet size, spreadsheet program, school teacher

spreadsheet program, school teacher, cells: You are on the right track with HIDING but it s not sheets you want to hide, it s rows and columns - select the columns to the right of the area you want to use and format the columns as hidden - do the same with the rows below your area - you will now have...

Excel: Link Two Drop Down Lists, currency field, valid selections

currency field, valid selections, mexico peso: The Input Range should be filled in with the list of valid selections. For drop-down box one that would be $A$1:$A$10 and drop-down box two that would be $B$1:$B$10. Cell link will need to be some unused cell such as $C$1. This value stores the contents...

Excel: Link Image, link image, debora

link image, debora: Debora Sorry i thought I answered this question several days ago. Actually I thought I didn t answer it, because I don t know how it can be done, although I m pretty sure it can. I suggest you reask the question of another allexperts person and perhaps...

Excel: Link mysteriously changed, dear sirs, utter surprise

dear sirs, utter surprise, excel spreadsheet: Hi Chonoh, Here s what happened: July65 was open and linked to June65. When you saved June65 as Aug65, the live links in July65 automatically changed from June65 to Aug65. (This is a feature, not a bug.) Here s the key point: if July65 had been closed...

Excel: Link to other excel sheet, douglas m smith, text cells

douglas m smith, text cells, sheet cells: Hi Gregg, Yes, this is possible using the INDIRECT function. It converts text into a reference. Start with this basic formula to assemble the reference: =INDIRECT(A1&A2&A3) You May need to fiddle with the syntax a bit to construct a proper reference...

Excel: Link TOC item to specific cell on a sheet, insert hyperlink, processing time

insert hyperlink, processing time, missing something: You re welcome. I suspect that I can help you give your client a MUCH better product but I doubt I could do it for free over this site. I develop programs in EXCEL and the other MS Office products for a living and have done so for about ten years or so....

Excel: Link Between Word and Excel, vba code, word document

vba code, word document, folders: Hello Martin, There are several things in your question that are not completely clear to me. You mention diagrams , but I am not sure what you mean by that term, and how these diagrams are linked to Excel. Are these diagrams in fact embedded Excel Chart...

Excel: Link Workbooks, string fname, code option

string fname, code option, format date: You say current date, but you deduct one from the system date in your newfile name - which implies that you are actually saving it with yesterdays date - that aside, this method gives you the clue you need to fix your query - deduct 2 and you will get the...

Excel: Link worries ..., destination data, destination files

destination data, destination files, finance job: Hi, Scott, I ve looked around but I can t find any one place with a list of rules relating to links. But, let me tell you what I can without knowing which version of Excel you re using. As for opening workbooks: They do not have to both be open. If your...

Excel: Link worries ..., destination files, finance job

destination files, finance job, new finance: Links will prompt you for an update usually. Links to workbooks will change IF both the source and destination files are open and the file is renamed from Excel. Other than that, it s a little bit of trial and error as I haven t found any documentation on...

Excel: Link worries ..., finance job, new finance

finance job, new finance, new location: Scott Books should be opened when you move data around, i.e. adding rows and lolumns, etc. then the links will automatically update. Also if you move files to a new directory, the links will be lost unless you update them. Hope this helps richar...

Excel: Linked cell references, cell references, sheet1

cell references, sheet1, spreadsheets: Just type it as if it exists -- type = Other Sheet1 !A1 (or whatever it ll be called); you ll get a dialog box to try to locate the file. When you click Cancel, you ll have your #REF error. When the sheet exists, you can use edit/replace to replace = with...

Excel: Linked cells in excel problem, format cells, ogilvy

format cells, ogilvy, culprit: Hello Joyce. This usually happens if either of the cells is formatted as Text. I suspect the cell that you are linking to is the culprit. Go that cell and format as General (format= Cells= Number tab, select general or something besides Text). You...

Excel: Linked Drop Down Boxes in a Form, drop down boxes, africa europe

drop down boxes, africa europe, box2: Hello Debbie, I will assume by form you mean you have set up an Excel worksheet to look like a paper form. In that case look at http://www.contextures.com/xlDataVal02.html and possibly http://www.contextures.com/xlDataVal13.html on Debra Dalgleish...

Excel: Linked Drop Down List, data validation, budget category

data validation, budget category, drop down list: Here s an example you can expand on. Enter Rent,Utilities,Phone, Cell phone, etc in a column, say Z1:Z10 (somewhere out of view) Define this as Housing (important step). Similarly, define a range named Debt in say AA1:AA10, and a range named Transportation...

Excel: Linked datasheets, ms office 2000, sheet stock

ms office 2000, sheet stock, stock management: Fotos You can only update one way otherwise it causes a circular reference which causes excel all sorts of problems. The problem you will run into is that if you update the main file which is linked to all the other files, when you save the other files...

Excel: Linked datasheets, ms office 2000, cell a1

ms office 2000, cell a1, sheet stock: Hi Fotos, Unfortunately, you cannot link formats, just values. To link a value from another sheet..you just need to reference the sheet name in the formula. For example, if you want cell A1 in Sheet 1 to appear in cell A1 in Sheet 2, then in Sheet 2,...

Excel: Linked datasheets, ms office 2000, sheet stock

ms office 2000, sheet stock, stock management: This sounds like you re using Excel as a true database (like Access) which it is not. In order to do what I think you want to do, there either needs to be ONLY ONE SOURCE of the data and everything else is a link to that data, OR, you d need a VBA solution...

Excel: Linked datasheets, ms office 2000, sheet stock

ms office 2000, sheet stock, stock management: Fotos, the majority of these entries could probably be links. So you have a file with data you want to also have in another workbook. You decide which file will have the original, and which file(s) will have the linked data. With both files open, just enter...

Excel: Linking, excel spreadsheet, spread sheet

excel spreadsheet, spread sheet, thought process: Quatro Pro is essentially like EXCEL and as a result there is no automatic way to link the two files based on just data in a field/cell. Two files can be linked together by writing a formula and that formula can contain an IF statement but that is about...

Excel: Linking, cell addresses, excel spreadsheet

cell addresses, excel spreadsheet, spread sheet: If, by notes, you mean comments, then no, there s no merge comments ability. You d need to use a fairly involved VBA macro to bring in the old comments & keep the current ones. Maybe instead of using comments you can use a separate worksheet which contains...

Excel: Linking across sheets in Excel, douglas m smith, functions in excel

douglas m smith, functions in excel, detail sheet: Hi Mailan, Not all functions in Excel can work with 3D references. Here s an unofficial list of the functions that do work (are 3D enabled): AVERAGE, AVERAGEA, COUNT, COUNTA, MAX, MAXA, MIN, MINA, PRODUCT, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA,...

Excel: Linking Buttons to Cells, mike mclean, change selection

mike mclean, change selection, relative cell: Look at your vba code. It probably has lines like this: With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With The word Selection makes the color change apply to the cell that s selected. If, for instance, you wanted to always change...

Excel: Linking Buttons to Cells, mike mclean, relative cell

mike mclean, relative cell, illiterate person: Hi there, If you did not modify the code other than setting ColumnOffset to 0, it should color the cell right underneath the commandbutton (if your command button fits in a cell). The address of the button is tied to the TopLeftCell the button resides...

Excel: Linking Buttons to Cells, false assumption, mike mclean

false assumption, mike mclean, relative cell: Can you have two buttons that are called by the same name and do exactly the same job? No. They each have to have different names, but you can write a macro that any number of buttons can use. Say you have a macro called MyMacro then in the Click event...

Excel: Linking Cells, arrow keys, cell reference

arrow keys, cell reference, c15: Shannon This is just simple referencing in Excel. If you want a formula to reflect changes in a different cell, you simply reference that cell. So let s say in D1 you want to show the value in A1. You would simply use the formula =A1 in cell D1. So whatever...

Excel: Linking Cells, microsoft excel 2000, douglas m smith

microsoft excel 2000, douglas m smith, absolute and relative references: Hi Lynda, My guess is you are referring to absolute and relative references, $A$1 versus A1. $A$1 will stay locked on cell A1 when it is copied, but A1 will change relatively. Unfortunately, sorting the cells will not alter formulas outside the sort...

Excel: Linking Combo Boxes in Excel, data validation in microsoft excel, combo boxes

data validation in microsoft excel, combo boxes, combo box: Hi, Rachel. Who says you have to use a combo box? Why not a dropdown? See: http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm Then, you simply link to the cell that contains the dropdown. Also, I think in the...

Excel: Linking cell ranges from different worksheets, array formula, numeric data

array formula, numeric data, jane doe: Hi, Kim, thanks for the nice compliment. :-) If all the worksheets have the same column headings, you should be able to do a simple consolidation onto a new summary sheet. I suggest you go into Help and read up on data consolidation. It will take data...

Excel: Linking cells between worksheets from Word., word template, error messages

word template, error messages, avail: Donna I m not much help with this one, I seldom use linked excel sheets in word so I have very little experience with it. I suggest you reask the question of another allexperts person and I m sure you can find one who can give you a great answer. Sorry...

Excel: Linking to a closed excel file, syntaxis, dynamic link

syntaxis, dynamic link, xls: That is not possible with the standard functions, but there is a function called INDIRECT.EXT, that does what you need, in a free extension package. You can check the syntaxis of the function here: http://xcell05.free.fr/english/morefunc/indirect.ext.htm...

Excel: Linking closed workbooks with DSUM formula, countif, sumif

countif, sumif, ogilvy: Christopher, Unfortunately, the Dfunctions do not work with a closed workbook. Apparently when a workbook is closed, the return value from the workbook is an array rather than a range (as it is when the workbook is open), and these functions (as well as...

Excel: Linking data in rows from columns, cell b2, cell b1

cell b2, cell b1, paste values: Chris, This is multi step process. First, you need to place this equation in cell A2: =Sheet1!$B1 Next, you need to drag that formula down as many rows as is needed. Finally, you can select cells A3 to the bottom, copy that, then select cell B2,...

Excel: Linking data from one worksheet to another, linking data, value error

linking data, value error, b20: Right. You cannot return multiple values in multiple cells using a formula in ONE cells. You CAN put something like this, though: =if($g$5= super combo , data facts !A20, ) Assuming you put the formula above in (for instance) B20 of Type Rope, then...

Excel: Linking a drop down box to a chart title, mouse pointer, drop down list

mouse pointer, drop down list, assets: Hi Perry, Select the Chart title object on your chart, then insert your mouse pointer into the formula bar and type the equal sign = and then point to the cell containing the drop down list of different assets then press Enter now change the chart title...

Excel: Linking Excel Spreadsheets for Presentation, excel spreadsheets, homepage thanks

excel spreadsheets, homepage thanks, brainbench: Tyler, Homepages or Switchboards as they are often referred to in Excel are actually pretty easy to create. Insert a new worksheet (usually before any other sheets). To create links to the other worksheets just click Hyperlink from the Insert menu. Then...

Excel: Linking Excel Spreadsheets, excel spreadsheets, prowess

excel spreadsheets, prowess, new job: Hi, you either need to use VBA coding (macro) or simply use Insert Hyperlinks (on menu) in the new worksheet. Those hyperlinks can point to other worksheets in the workbook and can take you to them as you click on them (kinda like a webpage). Gyul...

Excel: Linking in Excel, cell a1, book1

cell a1, book1, wrong answer: NOTE - I have uploaded a video of how to do this to the following location: http://home.swbell.net/nate-sus/excel/excel.avi If Book2.xls does not appear, then you did one of these three things: Possibility 1 - You skipped step #1) Open Book2.xls ...

Excel: Linking Files, cell b1, apple banana

cell b1, apple banana, cell a2: As I m in the UK, a phone conversation is quite expensive!! The function you need is INDIRECT which will translate text into a reference - HOWEVER, I think you will find that it will ONLY work if the file you are referencing is actually open! Which probably...

Excel: Linking Files, cell b1, apple banana

cell b1, apple banana, cell a2: Sorry, no phone calls. Imagine how many calls I would be asked to make. Remember I volunteer my FREE time to answer questions. EXCEL will not work exaclty the way 1-2-3 did in this case. You need to use the INDIRECT function (it is like the @@ function...

Excel: Linking Files, cell b1, apple banana

cell b1, apple banana, cell a2: You need the INDIRECT function, Greg. INDIRECT converts text into a reference. Let s say that A2 returns Banana . The following creates a reference in text format: = C:actual[ &A2& .xls]Sheet1 !B1 This formula returns the text string: C:actual[Banana.xls]Sheet1...

Excel: Linking to files with a relative path, hierarchical file systems, directory setup

hierarchical file systems, directory setup, relative link: As far as I can tell this cannot be done. (well, at least easily). as per Harlan Grove: Along these same lines, is there any way to do a relative link or reference, similar to what you would do with a web page, whereby, you would basically tell Excel...

Excel: Linking a Linkbox result to spreadsheet formulas, dropdown list box, spreadsheet formulas

dropdown list box, spreadsheet formulas, model scenarios: In range A1:A3, enter the choices for the dropdown, base , down , and up . In cell B1, put the dropdown itself, using Data, Validation, Settings, Allow: List, Source: =A1:A3. Then in any cell, put the formula: =CHOOSE(MATCH(B1,A1:A3,0),4%,3%,5%...

Excel: Linking multiple excel spreadsheets into a weekly summary spreadsheet, excel spreadsheets, book2

excel spreadsheets, book2, spreadsheet: Soraya You can create a linked summary spreadsheet by setting up your summary sheet with links like =Sheet2!C6 if it is in the same workbook or =[Book2]Sheet1!$A$1 if it is in another workbook. if it is in another workbook it wont update unless that workbook...

Excel: Linking multiple spreadsheets to a master, master spreadsheet, explicit instructions

master spreadsheet, explicit instructions, change directory: Meg, I can help you with this to a point. You do need to use VBA code to make it work, but since I have little info on how this needs to work, I can t really make the processing code for you. I can give you the code that gets it started and loops through...

Excel: Linking multiple workbooks to one master, commodity contract, blank rows

commodity contract, blank rows, access query: I think an Access query would be more akin to Excel VBA code rather than a formula -- you want it to perform a certain action only when requested (the query), not all the time. You can either use VBA to accomplish this (and I don t have enough information...

Excel: Linking to other excel sheets, pivot tables, pivot table

pivot tables, pivot table, ogilvy: Tracey, Based on the minimal information provided, I would suggest using a pivot table found under the data menu. You can get a lot of information on Pivot Tables at this site: Debra Dalgleish http://www.contextures.com/tiptech.html -- Regards,...

Excel: Linking A Range of Cells, destination cells, book2

destination cells, book2, relative references: If the range has no gaps, you can create the first formula and then copy it to all the destination cells. For example, to link all the cells in the range A1:C50 from book1 to the same range of book2 you can do the following: - Link the cell A1 to book2 using...

Excel: Linking a range of cells to a different worksheet, array formula, empty cells

array formula, empty cells, numeric data: Kim Let me suggest the following: First link the summary sheet to the individual sheets. If you have an idea what the total rows that you want to use are, for example 100 rows, you can use the first 100 rows for sheet 1 the second 100 for sheet 2,...

Excel: Linking Spread sheets, conditional formatting, vlookup

conditional formatting, vlookup, spread sheets: You use the VLOOKUP fumnction. The syntax is as follows VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) In your case the lookup value is a random number in sheet #1. table_array is found in sheet #2. So you have to make sure that you have...

Excel: Linking If/then Statements, number ranges, variables

number ranges, variables: Kiran You can use a nested if statement like the one following. I am assuming that the variables are in column A and the number ranges are in column B. The formula would look something like this =IF(A2 501,501,IF(A2 200,201,IF(A2 50,51,IF(A2 =50,50,)))...

Excel: Linking in same sheet to a dynamica cell with an specific text, column letter, exact text

column letter, exact text, xyz: There is almost always a way...lets try this: http://home.swbell.net/nate-sus/excel/filename.xls The above is a link to a sample spreadsheet so that you can see how it all works; however, there are some limitations, and I will go over those as follows:...

Excel: Linking one sheet to another, array formulas, incorrect result

array formulas, incorrect result, offsets: Joe: If I interpreted your question correctly, then what you are requesting is slightly complicated but doable. I have uploaded a sample spreadsheet here: http://www.snapdrive.net/files/487599/lists-names.xls NOTE - The Group sheet2 uses mostly array...

Excel: Linking sheets, excel spreadsheet, days of the week

excel spreadsheet, days of the week: Tod You can link each page with the previous days figures if that is what you mean, if you want to type in specific figures in each sheet, select all the sheets and then type in the text of figures and it will go on every sheet. Dont forget to deselect...

Excel: Linking sheets in Excel, master spreadsheet, cell c5

master spreadsheet, cell c5, example purposes: Linking in Excel is fairly user friendly and can be done with the following steps: 1) Open your master spreadsheet. 2) Open one of the other sheets. Figure out what cell in this sheet you want linked to the master sheet. For example purposes I...

Excel: Linking sheets problem, data validation, business sectors

data validation, business sectors, finance sector: Kseniya Normally I would suggest that you use data validation in accessing your lists for the drop edown menus, but I don t believe you can use a different sheet reference with the data validation feature. Therefore short of suggesting that you create...

Excel: Linking sheets, paul standish, history sheet

paul standish, history sheet, allexperts: Paul First off I would suggest having a look at Access to create your (what is basically a database) sheets as you can have an unlimited (well almost) number of columns. You can have two sheets and run the information from one to the other but you may...

Excel: Linking spreadsheets, spreadsheets, spreadsheet

spreadsheets, spreadsheet, daily basis: Hi, Lora, I can t answer this message with specific steps, since I don t know how your spreadsheet is laid out. But I suggest you look into the Excel feature called consolidation. There is a way to consolidate several sheets of data onto one sheet, and...

Excel: Linking spreadsheets, file xls, true case

file xls, true case, backup file: Melissa, this needs to be accomplished through VBA code. I would recommend that you use the Before_Close event, so that the file will be saved as the second workbook just prior to the file closing, with you having to do almost nothing. So, with the main...

Excel: Linking, transposing and merging, company unions, source sheet

company unions, source sheet, filter function: Emily: I took no offense with your question and knew that you did not know that a solution would involve a macro. Answering questions about macros people have already written and writing them for people whose asnwers/solutions involve them are TWO separate...

Excel: Linking Workbooks, spreedsheet, excel 2002

spreedsheet, excel 2002, excel 2000: Hi Ken How are you? Please do the following in Excel 2002 or Excel 2003 1. Open the workbook 2. Edit - Links 3. Select the link to be deleted 4. Press Break Link Excel 2002 1. Open the workbook (e.g. Book1.xls) 2. Edit - Links 3. Select the...

Excel: Linking Workbooks and the Rules, rules of thumb, ogilvy

rules of thumb, ogilvy, new location: Scott, I don t know where a definitive list is. Rules of thumb are that if you want to change anything and you want to have it reflected in the workbook linking to th e workbook where the change is being made, you need to have both workbooks open. If...

Excel: Linking Workbooks, spreedsheet, change source

spreedsheet, change source, source button: Hi Ken, Excel 2002 has a break link button. It has this because it was always confusing on how to break links or missing links. But here s how in Excel 2000. Before you start. Obviously this will break any links that your workbook depends on, just...

Excel: Linking Worksheet/Workbook Cells in Array Formula, array formula, jane doe 1

array formula, jane doe 1, column headings: Hi Kim, I am glat that you are fine. The easiest way is to save the summmmary data in another Workbook. 1. Open both workbooks (summary.xls and data.xls) 2. Disp[lay them vertically (Window - arrange - vertical) 3. On the Summary.xls, select A1...

Excel: Linking Worksheets, book2, daa

book2, daa, cells: keonne Yes you can link the worksheets or cells in a worksheet by using a formula such as this: =Sheet2!A1 This formula says bring over the data from (the same workbook) Sheet2, cell A1. So as you type in daa in cell A1, sheet 2, it will also be...

Excel: Linking web address to excel, google maps, type directions

google maps, type directions, large time: Browse to the specific page where the map is. Copy the URL from the address bar in IE. Right click the cell in EXCEL where you want the link to this web page to be. Left click Hyperlink. In the Text to display: text box type Directions to Client s...

Excel: Linking workbooks, precision structures, vlookup function

precision structures, vlookup function, contractor name: Adele Without knowing exactly what your data looks like its kinda hard to be very specific, but a couple of suggestions may work for you. 1 remember you can copy the original data to another worksheet or another part of the same worksheet and manipulate...

Excel: Linking workbooks, report parameters, spreadsheets

report parameters, spreadsheets, offshoot: Lori It would be much simpler and safer in the long run to only allow queries to be run from the main sheet as opposed to letting information possibly become corrupt due to too many users. YOu can create the report parameters in Macros and then save each...

Excel: Linking workbooks, wb1, wb3

wb1, wb3, wb2: Hi Linda, Can you send me an example of the three workbooks? I am not quite sure what you need? If you have all three workbooks open it is simply a matter of typing = and then click on the other workbook that you want to draw data from. But it would be...

Excel: Linking worksheets, cathy thomas, tool number

cathy thomas, tool number, tool shop: Hi Cathy, How are you? I wonder how you linked the files. If you open 2 files simultaneously and on A1 of the 2nd file you type = and then chosse a cell of the 1st file, they are linked automatically. You can apply this process to any file . the...

Excel: Linking, ogilvy, pros and cons

ogilvy, pros and cons: TJ Having them in the same workbook would be faster. If you aren t going to move the workbook(s) around, size shouldn t be a big issue. I understand you don t have problems with workbooks until they get to be around 80 MB - hopefully it should be...

Excel: Links, cell addresses, range names

cell addresses, range names, long long time: Hello, Hannah, I haven t seen the spreadsheets, of course, but it sounds like you may benefit from using range names instead of cell addresses. That way, if rows are added or deleted from the named range, you won t have to update links referring to that...

Excel: Links, long long time, summary document

long long time, summary document, excercise: Hannah These are the types of questions that would be far simpler to answer if I could see what you were doing. Since I can t, I will attempt a few speculations. If you need to link to specific summary data on the workbooks, it may be simplest to name...

Excel: Links that generate, analysis toolpak, currency tools

analysis toolpak, currency tools, internet assistant: A file with links actually stores the values from the links in the workbook, so that s why I m saying it s not the link that is the problem - it also wouldn t be because it s a protected sheet - you could try tools, options, view and click the formulas button...

Excel: Links that generate "#NAME?" output, analysis toolpak, colleague

analysis toolpak, colleague, cells: The problem isnt with the links, but with the formula behind the #Name error - for example, if using YEARFRAC, the Analysis toolpak must be installed from the tools, add-ins menu - my guess is it s PROBABLY this toolpak, but if you can tell me the formula...

Excel: Links to Other Files, window options, options section

window options, options section, excel 97: Go to Edit- Links and write down the name of the linked files. if there aren t any there then you have no links active. Then go to Tools- Options and click on the View tab. In the Window Options section put a check mark beside formulas and all the formulas...

Excel: Links problem, excel spreadsheets, necessary directories

excel spreadsheets, necessary directories, cell references: Not sure I fully understand your situation but you can avoid the Update remote references message with this line of code: Application.DisplayAlerts = False I have not tested this with this specific situation but this line prevents those type of messages...

Excel: Links problem, excel spreadsheets, necessary directories

excel spreadsheets, necessary directories, cell references: My own method would be to send them the files as a self extracting zip file - this would ensure that the paths were created as necessary, and would also reduce the size of the files being mailed about. Alternatively, I would try to have the workbook increased...

Excel: Links problem, excel spreadsheets, necessary directories

excel spreadsheets, necessary directories, cell references: Assume all users are on xl2003. Then on your machine, go into Edit= Links and in the lower right, there is button or setting you can select to not have the links updated. This was introduced in xl2002 I believe, but it might not have been until xl2003 -...

Excel: Links and references to data in other excel sheet, cell location, excel sheet

cell location, excel sheet, shorter path: Why not also always open the file it s linked to? If the full path is so long, it must be nested deeply in other folders. Why not move the linked-to file to a directoy more easily accessible (and therefore shorter path)? You shouldn t have to update links...

Excel: Links in Spreedsheet and Macros(VBA), john walkenbach, macros vba

john walkenbach, macros vba, spreedsheet: Amita, Sorry to get back so late, the weekend came and I forgot to tell Allexperts I was off. Anyway, if you have Excel 2003, you can just go to Edit/Links and Break the Source of the link you don t want. Otherwise, you need to do a search with Ctrl...

Excel: Links, long long time, shot in the dark

long long time, shot in the dark, excel 2000: Hannah There is an option that will allow you to update all the links at one time in a document when you open that linked document, it should do it automatically, however if you are linking to specific sections of your spreadsheet and not to totals that...

Excel: List Box, target cells, target value

target cells, target value, target address: Here is the code to do that, I have substituted the space delimiter with the chr(10), that is a line feed, and added a part to remove the trailing line feed, that I suppose you won t need. Dim grngCell As String Private Sub Worksheet_SelectionChange(ByVal...

Excel: List Box, quick responce, data validation

quick responce, data validation, control toolbox: Projects probably refers to a range name and it should show =Projects if it does refer to a range name. If there is no range names Projects then you should not get an error - the drop down will not drop down since it will not know where the get the data to...

Excel: List Box and animation, input boxes, sheet tab

input boxes, sheet tab, password code: I didn t keep a copy of what I sent to you, so I can t tell why you keep getting prompted for a password. I assume you placed it in the Workbook_Open event, yes? I don t know what you mean by a userbox. there s userform, button, textbox...please be more clear...

Excel: List Box VB, douglas m smith, control toolbox

douglas m smith, control toolbox, vba programming: Hi DarReNz, This can only be accomplished using a List Box control (on the Control Toolbox toolbar) and it involves some VBA programming. You will need to set up the the parameters (like RowSource to define where the list of things is) of the list box...

Excel: List Box, roy cox, header row

roy cox, header row, commandbutton: Assuming you have a sheet named master with the data starting in A1, Row 1 being a header row. In the form sheet you have a Commandbutton and a Listbox or ComboBox, both from the Controls Toolbar, place this code in the button_click event. The master code...

Excel: List Boxes, customer service department, excel 2000

customer service department, excel 2000, cheers: Hi Greg How are you? There is sure;ly a better way to do it but it seems that the esiest way is to use a coontrolbox listbox intead odf a forms list box. 1.view-toolbars-controlbox 2. draw the listbox 3. right-click mouse 4. properties-Font Cheers...

Excel: List box or combo box allowing user to select fill color., target audience, cell b2

target audience, cell b2, color cells: Here is what I came up with: http://home.swbell.net/nate-sus/excel/colors.xls NOTE - Excel does have conditional formatting that would work in this situation, but it is limited to 4 potential options. If you want to limit your color selection to only...

Excel: List issue, data validation, cells

data validation, cells: Hi Mike, Create a named range for the cells - Insert - Name - Define you can then use the named range across sheets. Is more elegant as you can now change the data in the named range - maybe add an option or two and the drop downs get automatically...

Excel: List numbers, cell b1, cell a1

cell b1, cell a1, istop: To make a list using formulas, put your starting value in cell A1, put the formula =A1+1 in cell B1, and copy that formula down as far as necessary. If you know how to use vba code, look at the code below to create a numbered list. If you don t know...

Excel: List numbers, cell a1, max count

cell a1, max count, automatization: I don t know exactly what you mean with put numbers automatically, what is the logic behind that automatization? The functions to use will depend on that logic, and may range from a single addition (=A1+1) to visual basic code, or maybe the ROW, MAX, COUNT...

Excel: List numbers, cell a1, separate lists

cell a1, separate lists, bottom right corner: I don t know a way to do this automatically to separate lists. All I know is that you can fill in the first few numbers in each list, hightlight them, and then double click on the bottom right corner of the selected cells to fill in the rest of the numbers...

Excel: List numbers, cell a1, formula 1

cell a1, formula 1, remainder: The easiest way to generate list numbers in Excel is to put the starting number into the first cell and then make the remainder a formula: 1) For example, place 150 into cell A1. 2) In the next cell, A2, place the formula =A1+1. This should cause 151...

Excel: List numbers, menu tools, resnik

menu tools, resnik, visual basic for applications: It starts by choosing from the main Excel menu Tools, Macro, Visual Basic Editor. But working with VBA is a complicated matter. It s necessary for you to find a book or online information on the basics of Visual Basic for Applications before trying to work...

Excel: List numbers, cell a1, ows

cell a1, ows, sheet index: I m not exactly clear what you have When you say a number of lists, up to 250, are they in one workbook? If they are maybe some VBA could do it. Both codes should be placed in a Standard Module. The first simply loops through each worksheet, checks if there...

Excel: List Search, custom dictionary, matchentry property

custom dictionary, matchentry property, control toolbox: This would require some programming I think. I will assume you are comfortable with VBA. See this page on Debra Dalgleish s site. http://www.contextures.com/xlDataVal10.html She shows how to code a Combobox from the control toolbox toolbar....

Excel: ListBox Control in Excel from the Toolbar, data validation, message tab

data validation, message tab, input message: Hello, Candice, I would advise against using a ListBox control in this situation. A much better choice is to use Data Validation. 1) Select the cell where you want to choose a month from a list. 2) On the menu bar, go to Data/Validation. 3) Start...

Excel: ListBox Control in Excel, excel 2002

excel 2002: You didn t say WHICH list box control, so I will assume we are talking about the control toolbar version of the listbox control - if so, use the LINKED CELL item in properties to store the selected value - you would also need code to ensure that the worksheet...

Excel: ListBox in VBA, excel spreadsheet, excel sheet

excel spreadsheet, excel sheet, vba: On your UserForm, say you have ListBox1, which gets it s values (its rowsource ) from a range on your Excel sheet named range1 . You ve also got on your Excel sheet similar named ranges range2 and range3 . Attach this code to your listbox1 Private...

Excel: Listbox in Userform -> doubleclick ? in XLS97, drop down boxes, double clicks

drop down boxes, double clicks, excel 97: Dear Markus I think you have the answer yourself already! Open your userform in the visual basic window and press F7. You will see all the code for the form, including for the listbox. There are 2 drop down boxes at the top of the window. Click the one...

Excel: Listing numbers in excel, bottom right corner, mouse button

bottom right corner, mouse button, vba: Junilla There are a couple of ways to do this that don t involve using VBA (of which I am not that competent with). One way is type 1 in a1 and 2 in a2, then highlight both lines and in the bottom right corner of cell at you will see a little black square,...

Excel: Listing Spreadsheet Functions/formula/macros, spreadsheet functions, spread sheet

spreadsheet functions, spread sheet, b52: Ian You can display the formulas in each cell by selecting the formulas option in the view tab--go to Toolbar/tools/options In the view tab check the formulas box The display will then show the formulas in each cell and not the values calculated...

Excel: Lists, microsoft office 2000, different types of jobs

microsoft office 2000, different types of jobs, cell a1: Samuel Yes it is possible to automatically put in the account code. There are several ways to do it, the use of which would depend on what your data looks like, etc. A sugestion would be: If you are selecting in one cell the type of job, you can make...

Excel: Lists - Conditional Formatting, data validation, range names

data validation, range names, cell a1: Isabelle, I think the best way to do this is to keep using OR for the different test values. Example: We want Cell A1 s value of Strawberries and Peaches to come up true (for the format setting to change). Condition 1 Formula is [=IF(OR(A1=...

Excel: Lists, vegetable list, combo boxes

vegetable list, combo boxes, data validation: ZoRo, I use combo boxes from the Forms menu - they are more flexible than the validation lists. To access, click View Toolbars and select Forms. Insert two combo boxes from the Forms menu and format them by right clicking on them and selecting Format...

Excel: Literal Formula, cell d2, cell d1

cell d2, cell d1, correct syntax: Hi Marc, Yes, this is possible with normal Excel functions. The formula for your example would be: =AVERAGE(INDIRECT(B8)) INDIRECT translates a literal string into a reference. This also works for defined range names too. Example: You have a defined...

Excel: Little indicators SLOW DOWN everything, exclamation mark, quicksand

exclamation mark, quicksand, spreadsheet: It s probably more that the sheet has lots of data which is slowing things up, but to explain the green indicators - these indicate possible errors on the formula etc - clicking on a cell would give an exclamation mark to the side of it which you could click...

Excel: Little VBA knowledge, Big VBA problem, inventory balance, extreme lack

inventory balance, extreme lack, correct numbers: Sub AddColumnD() Set rng = Range(Cells(1, 2), Cells(1, 2).End(xlDown)) For Each cell In rng If cell.Row = 1 Then Cells(cell.Row, 4) = Range( C1 ) - Range( A1 ) ElseIf cell cell.Offset(-1, 0) Then Cells(cell.Row, 4) = Cells(cell.Row,...

Excel: Live Links to spreadsheets, array formula, arrow keys

array formula, arrow keys, refernces: No, I don t write code for people who post questions to this site. If I did then that is all I would be doing. However the approach I will suggest is to use the selection change event of Sheet1 - Private Sub Worksheet_SelectionChange(ByVal Target As...

Excel: LOOKING FOR DATA, cell c5, cell b5

cell c5, cell b5, column number: This still makes no sense. You say Type 10100(B2+C1) in cell B4. DO I type 10100 or =B2+C1 (which would give 2300) You say ...we get 2000(C2) in cell C4 HUH? If you type in cell B4, how do you get anything in C4? Similarly with the rest. This is...

Excel: LOOKING FOR DATA, douglas m smith, array formula

douglas m smith, array formula, brainbench: Hi Hidajadi, If you put 1100 in cell B7, the formula to return 2347 would be: =INDEX($B$2:$D$4,MATCH(FLOOR(B7,1000),$A2:$A4,0),MATCH(B7-FLOOR(B7,1000),$B1:$D1,0)) The FLOOR function rounds the value down to the next lower thousands value. If you...

Excel: LOOKUP command, computer crash, index function

computer crash, index function, good answer: Mace Sorry I ve had a computer crash and haven t been able to get back to you. I like to work out the answers before sending them and I won t be able to because of the crash, but try using the offset function along with the lookup function and maybe the...

Excel: IF & LOOKUP formula question, drop down list, wb

drop down list, wb, cheers: Use instead: =IF(D11= ,0,INDEX(INFOR!$G$2:$G$68,MATCH(D11,INFOR!$I$2:$I$68,0),1)) This means that whatever s in cell D11, if it matches exactly an entry in the Col I range on INFOR, your formula will return the corresponding value in the Col G range...

Excel: LOOKUP function, employee numbers, answer check

employee numbers, answer check, column c: Hi, Jeff. I hope you got your solution by now, and I m really sorry I m so late in responding. I moved, and forgot to put myself on vacation... Anyway, in case you didn t get your answer, check out my vlookup article: http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm...

Excel: Loan Account, principle balance, period times

principle balance, period times, loan account: Jatin You don t really need a macro, what you need is a series of formulas to calculate each step in the process. I suggest you work out each procedure and see if you can t solve your problem in that manner. I.E. The loan balance is the result of...

Excel: Locating records in excel and inserting into a form to amend, target value, contextures

target value, contextures, visual basic for applications: Hello Daniel, Turn on the macro recorder and select a single cell, then do Edit= Find then turn off the macro recorder when it finds the Target value you supply. This will give you the basic code you need to find the value. to populate the...

Excel: Lock Cell color for row, visual basic solution, imageshack

visual basic solution, imageshack, dark orange: You didn t tell me what my previous answer was, or the question ID - but if you want more than 4 colours (which you do) then you cannot use conditional formatting, so you need to move to a visual basic solution - you would need to determine the order in which...

Excel: Locked Cells Protection Individually., format cells, worksheet tools

format cells, worksheet tools, ontime: The default setting in Excel is that all the cells are locked. This means that when you protect the worksheet, the cells cannot be edited. To make select cells editable: 1) Select the cells you want to be able to edit. 2) On the main toolbar, select...

Excel: "Locked for editing", shift key, excel 2000

shift key, excel 2000, windows explorer: In windows explorer, right-click the file and check properties to see if it s read only. If not, try opening it with the shift key held down & see if that makes a difference. If not, then open it and save it as another name and see if you can save it AGAIN...

Excel: Locking Cells, format cells, a3

format cells, a3: All cells by default are locked when you protect the worksheet. First you have to unlock the protection status of each cell that you DO NOT want to lock. Select the cell to unlock and choose: Format|Cells|Protection| remove checkmark in Locked box ...

Excel: Locking Cells in Excel, password range, target

password range, target, code question: David, I don t know what the cells look like in terms of what value they hold when all this starts, but in your change event, you make a decision for each cell no matter what cell triggered the change event. You need to structure your code so only one action...

Excel: Locking Cells, excel worksheet, marketing information

excel worksheet, marketing information, excel 2002: The simple answer is - with difficulty - I presume you want the users to SEE the first 50 rows, so hiding them isn t an option. Protecting the sheet is no good because that would stop them inserting and deleting rows. You are therefore going to have to EITHER...

Excel: Locking Columns or Rows in Excel Spreadsheets, microsoft excel 2002, excel spreadsheets

microsoft excel 2002, excel spreadsheets, column references: Yes. right-click the sheet tab, select View Code, paste this in (change the column references to fit your needs): Private Sub Worksheet_SelectionChange(ByVal Target As Range) select case target.column case 2,6,8 Columns B,F,H - don t want user...

Excel: Locking cells on a password protected worksheet, target cells, relevant cells

target cells, relevant cells, target address: This will work with your button, change the password to match yours. It will rely on the user clicking the button.Either assign the macro to a Forms button, or call it with a Controls Toolbox button. Option Explicit Sub protectAll() change the...

Excel: Locking sheets / deleting graphs, current sheet, excel sheet

current sheet, excel sheet, command buttons: 1. vba code to delete all graphs on the current sheet: Dim cht As ChartObject For Each cht In ActiveSheet.ChartObjects cht.Delete Next cht 2. In the Visual Basic Editor, in the Project Window, right-click on the VBAProject, choose...

Excel: Locking specific cells in a worksheet, d12, ogilvy

d12, ogilvy, cells: Brendan, Merged cells are the bain of everyones existence in VBA. This worked for me: Sub ABC() With ActiveSheet .Unprotect Password:= 123 .Cells.Locked = False For Each cell In .Range( D10,D12,D14 ) cell.MergeArea.Locked = True Next...

Excel: Log in system, bite size pieces, password cracking software

bite size pieces, password cracking software, dialog sheet: Hi Mark, This entire question is a bit more than I can answer in this AllExperts forum, but I can offer some advice regarding your problem. First, you mention using a Dialog sheet and dialob box. I recommend using a Userform instead unless you are using...

Excel: Logic function, logic function, fourth column

logic function, fourth column, hi lee: Hi, Lee! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) I hope that you have gotten an answer by now, but just in case... YES, it s possible. :) Something like: =IF(and(E4= yes ,E5= yes ,E6 H1),E3, Other...

Excel: Logic, format button, conditional formatting

format button, conditional formatting, h15: What you need is Condituinl Formatting. Select the cell in which you want the condition,from the Format Menu select Conditional Formatting In the Condition 1, the drop down on the left should read Formula is . In the right hand drop down type =$H$15...

Excel: Logical Test Function, cell b2, cell a2

cell b2, cell a2, conditional formatting: I don t understand what you are saying. If you follow the solution I provide then B2 s format will change based on what is A1. I suspect that the formatting you applied was a font color ONLY and not a background color. IF you have no text in B2 AND...

Excel: Login Password and dont prompt a questions to enable macros, vba procedure, macro security

vba procedure, macro security, click tools: Hi Jon How are you? How about saving the file with a password ? Please try Open the file File - Save As Click Tools General Options ..... Or you can write a VBA procedure to ask for a password (read help file on Password property) Cheers Adelaid...

Excel: Look at 2 columns, column c, pivot table

column c, pivot table, aidan: The words don t make it clear what you want to do - to summarize, you could use Data Pivot Table to give you a summary - but it doesn t sound like that is what you want - the lookup function sounds like it SHOULD work, but you didn t say which function you...

Excel: Look-up, formatting, vlookup, time hope

vlookup, time hope, 33333: You re right, can t be done directly. You would need VBA to do that - on the worksheet_Calculate event or worksheet_Change Event you d have to check the result of the VLOOKUP, find the cell the Vlookup is getting its answer from, copy & paste special the format....

Excel: Look-Up formula, example spreadsheet, vlookup

example spreadsheet, vlookup, f 65: Darren: VLOOKUP sounds like the perfect solution to your question. I have uploaded an example spreadsheet here: http://home.swbell.net/nate-sus/excel/vlookupexample.xls I placed the group list of numbers you provided on a sheet labeled Groups ....

Excel: Look up a specified value/text in a list, then return the result : YES or NO, cell b2, search portion

cell b2, search portion, cell c2: Hi Phong, Here is your formula (to be placed in cell C2) assuming AAA_Lan is in cell B2: =IF(ISNUMBER(SEARCH( lan ,b2)), YES , NO ) The search portion is not case sensitive and will find LAN, lan, Lan, LAn, lAN etc. Hope that helps, -Crai...

Excel: Looking for Best Formula, logical option, c degree

logical option, c degree, column c: I have uploaded a new spreadsheet here: http://home.swbell.net/nate-sus/excel/stars.xls The concepts are still the same - just the formulas are getting longer. I have added in a new logical option; OR. Unlike AND, where all must be correct to obtain...

Excel: Looking for Best Formula, intermediate data, proper style

intermediate data, proper style, g style: Okay.....building lists like this is going to take some formula mumbo-jumbo . Since I cannot program in Visual Basic, I ll have to create columns with intermediate data in order to work my way towards a final result. Here is the revised spreadsheet...the...

Excel: Looking for Best Formula, hh mm ss, yyyy

hh mm ss, yyyy, date time: A appologize for taking an extra day to reply...I had intended to send you a response last night. The reason the spreadsheet didn t work when you went to minutes is because a single minute is a pretty small fraction of a day. As such, Excel starts running...

Excel: Looking for Best Formula, ss format, mm ss

ss format, mm ss, hidden columns: 1) You are correct, it will say Refresh Data . 2) I cannot explain why the data is not updating for you. Are you using Microsoft Excel for Windows? The Refresh Data icon should have a red exclamation point on it. Did you happen to alter the spreadsheet...

Excel: Looking for Best Formula, math question, c degree

math question, c degree, sun moon: Please refer to the example here: http://home.swbell.net/nate-sus/excel/stars.xls I placed a formula in columns F through H to determine the answers to your first three questions. The use logical AND to figure out if both conditions are met. I placed...

Excel: Looking up the last cell within a column that has a value, hlookup, vlookup

hlookup, vlookup, specific solution: Helen, I m having trouble visulizing your sheets to be able to give a specific solution. But I ll try to give some thoughts and hopefully you can use someideas. If you need more assistance, you can send your sheet to me at greg@gsquaredtech. As far...

Excel: Looking at columns and linking them using VBA, vlookup, fred george

vlookup, fred george, d11: Hi Annie, I am sorry I did not read your question properly After choosing the item in the list box you get 1,2 or 3 So the data in 2nd sheet have to start with the common search key 1 5 Geography 2 7 History ... Then you in sheet 1 you can use...

Excel: Looking for good formula, vlookup, column c

vlookup, column c, column number: I am making the following assumptions: 1) In Column A (Date) in Column B (Sale of that Date) Column C (Expense of that Date) 2) You will type the LOOKUP date in cell E2. Place this formula in cell F2: =VLOOKUP(E2,A:C,2,FALSE) Place this formula in...

Excel: Looking for macro developer, guees, excel macro

guees, excel macro, business plan: I don t know, I have never looked for one. My first guess would be the internet. I am a developer and can more than likely develop what you need. My guees would be that most all good developers are not cheap though. However I do not know what your definition...

Excel: Looking up multiple records, cell a2, multiple records

cell a2, multiple records, sequence numbers: My earlier answer assumed that the names in Col A were sorted so that each name was grouped together (as in your original example). Here s a different solution to use if the names aren t always in consecutive cells, as in this 2nd example. We re still assuming...

Excel: Looking up the last occurrence of data in a column, company hundreds, column c

company hundreds, column c, filter option: Shannon You can do it with an index and match formula but it would require you to change the name for every look up. There could be a VBA solution but I am not well versed in VBA. One option would be to use the Data Filter option and filter out all but...

Excel: Looking up the last occurrence of data in a column, company hundreds, column c

company hundreds, column c, occurence: You can select the column E (or C) enter the Find command as you normally do, then before clicking on the FInd Next button, hold the shift key down. This will find PREVIOUS. When done from the top (row 1), it will wrap around & find the last one. (Tip #10...

Excel: Looking up an value but find 2 of the same, array formula, curly brackets

array formula, curly brackets, ogilvy: Joseph, I have sent the workbook back to you with a formula to do what you ask. Note that it is an array formula and must be entered with Ctrl+Shift+enter rather than just hitting the enter key alone (as you normally would). After you enter it correctly,...

Excel: Looking up values., douglas m smith, array formula

douglas m smith, array formula, cell c3: Hi John, Here s the formula: =DATE(INDEX($C$2:$E$2,1,SUM(IF($C$3:$E$14=LARGE($C$3:$E$14,G3),COLUMN($C$3:$E$14)-2,0))),SUM(IF($C$3:$E$14=LARGE($C$3:$E$14,G3),ROW($C$3:$E$14)-2,0)),1) This example assumes the data is in cells C3:E14. DATE assembles...

Excel: Lookong for Good Formula, cell a1, cell a2

cell a1, cell a2, sheet1: Note, you said: If B1=A1, That means c1 = 1, If B1=A1+1, then c1=2, If B1=A1+2, then c1=3 If B1=A1+3, c1=4 If B1=A1+4, c1=5 If B1=A1+5, c1=6 If B1=A1+6, c1=7 If B1=A1+7, c1=8 If B1=A1+8, c1=9 If B1=A1+9, c1=10 If B1=A1+10, c1=11 If B1=A1+11, c1=12...

Excel: Lookup?, array formula, a500

array formula, a500, different numbers: Had a typo in the original: I can tell you how to find the last entry in a column =CountA(Sheet1!A1:A500) If you want the last entry for a specific value =Large(if(Sheet1!A1:A500= ABC ,Row(A1:A500)),1) This would be entered as an array formula...

Excel: Lookup, spreedsheet, city state zip

spreedsheet, city state zip, customer name: VLOOKUP will not work they way you want this work since it only returns ONE customer (thus my question earlier of HOW MANY) As I said before, I think the easiest and quickest way is to use Data, Filter, AutoFilter. Choose the date field for the criteria...

Excel: Lookup, vlookup function, range names

vlookup function, range names, excel help: You ll want to use the VLOOKUP function - look it up in Excel s help. You also might want to understand RANGE names - it s helpful to name the table that you re looking information up in. If you get stuck, email back with more details, but the Excel help...

Excel: Lookup, array formula, decriptor

array formula, decriptor, precious advice: Good morning Barry! The cause of this error is because I used the ROW() function in my formula. ROW() returns the row number where the answer is found...and then I subsequently use INDEX() to grab the letter. Essentially the formula works like this...

Excel: Lookup?, third time lucky, array formula

third time lucky, array formula, text options: I did get all three questions - sorry about my response time, but I m in the UK and have a young daughter, so these two combined mean that sometimes it s hard to get the time to answer the question. I THINK that what you need for this is something along the...

Excel: Lookup colum information, douglas m smith, cell c1

douglas m smith, cell c1, excell 2000: Hi Michael, Sorry about the delay but your question snuck in after I had gone on vacation on the board. If you use MATCH instead of LOOKUP, it will return the nth item number in the list instead of the cell value. Example: the date matching TODAY()...

Excel: Lookup combo type box, conditional formatting, option excel

conditional formatting, option excel, distinct conditions: Jahan, This is a two step process. First to get the combo list, type in your values somewhere on the spreadsheet. For illustration, I put Apple, Pear, and Orange in cells A1:A3. Next, select the cell where you want the dropdown to appear, like C2. Click...

Excel: Lookup two criteria in unfiltered data, ms excel 2000, virus issues

ms excel 2000, virus issues, unfiltered data: Again, because you will have 9/2 repeated, no formula will then find a specific record of the ten records you may have for 9/2, for example, and THEN find a specific employee from within those ten records. You either need to restructure your data and/or...

Excel: Lookup cross reference formula help needed..., array formula, comma delimited

array formula, comma delimited, excel spreadsheet: You need a user-defined function. Use Alt/F11, use Insert/Module, enter this code: Function where(y As String, sh As String) As String Application.Volatile True With Sheets(sh) For i = 1 To 65536 If .Cells(i, 1).Value = ...

Excel: Lookup data in column A and B, then output all values in Column B for matching values in column A, array formula, array formulas

array formula, array formulas, vlookup: Lisa: I have uploaded a sample solution here: http://home.swbell.net/nate-sus/excel/products.xls What you are requesting is very useful, but not something easily obtained with Excel; as such, I ll have to do a bit of explaining and then I ll also suggest...

Excel: Lookup Function with Dates, arrays, d2

arrays, d2, segment: Graham: I ve never been a big fan of the LOOKUP formula - it never really does what I want it too - that and it tends to require your arrays to be sorted (which isn t always the case). Might I suggest VLOOKUP instead? Give this formula a shot and let...

Excel: Lookup Function, lookup functions, arrays

lookup functions, arrays, spreadsheet: Yes that can be done. What i have to know is how many to the right of this cell you need to rtain. Depending on what you are trying to achieve, you canretain it as individual values or as an array. Do you know about LOOKUP functions? There are all kinds,...

Excel: Lookup formula, vlookup formula, numerical code

vlookup formula, numerical code, column number: Jason: Yes, a lookup is definitely the way to go and I suggest the VLOOKUP formula. I have uploaded a sample spreadsheet here: http://www.snapdrive.net/files/487599/lookupjason.xls The VLOOKUPS will be found in cells G2 and H2. They take the value...

Excel: Lookup formula needed, category names, ogilvy

category names, ogilvy, category name: I assume it is like Cat1(bold) item1 20 item2 30 item3 5 item4 25 Total 80 Are the number of Itemized expenses constant? Does total contain the name of the Category? ex: Cat1 Total: If you could send a sample...

Excel: Lookup formula for purchased items with same invoice number, cell b2, invoice numbers

cell b2, invoice numbers, invoice number: It s not a lookup formula, that much is certain - I would personally PROBABLY use a pivot table to get the data that you want, but it is not totally clear what you do want - if you want to return for each invoice number just a list of items that invoice contained...

Excel: Lookup function using ranges within conditional format, array formula, going in the right direction

array formula, going in the right direction, different color: Jim: This formula should give you a start: =MATCH(A1&B1,$C$1:$C$100&$D$1:$D$100,FALSE) This is an array formula. It must be entered by pressing CTRL-SHIFT-ENTER, and if entered correctly, your formula will have braces, {}, surrounding it. In my...

Excel: Lookup help, blank cells, array formula

blank cells, array formula, column c: It is not totally clear what is happening here - are you simply filling the values in column C with the missing dates if the value is blank, and if so, is there only ONE value in B - if this is the case, then this array formula would do it - example given...

Excel: Lookup list, cell b1, vlookup formula

cell b1, vlookup formula, vlookup function: Hi Anthony, It appears that you should be using the vlookup function. Lookup_value A1 Table_Array $D$1:$E$100 Column_Index_Number 2 Range_Lookup False This would be useful in cell B1, where you look at cell A1 and try to match in in the...

Excel: Lookup and Match two lots of data, vlookup, tushar

vlookup, tushar, thanks in advance: Dear Rich, 1. I suggest you create a new column at both places by concatenating two columns to get Hardware-Software kind of list. 2. Use formula ISNA(VLOOKUP(C:C,Sheet2!C:C,1,FALSE)) in column next to bigger list 3. All those showing FALSE are in both...

Excel: Lookup/match across several sheets, table wizard, max score

table wizard, max score, result table: Mike, There isn t any single function that will do this for you. The easiest might be to create a master sheet that reproduces the scores using a linking formula and then build you summaries from that. If you don t have to have formulas, you can do this...

Excel: Lookup with multiple conditions, radio station name, grey hairs

radio station name, grey hairs, index formula: This may be a little too much, but using the same formula inside an INDEX one, that may do the trick: =INDEX(Sheet2!$C$2:$C$5,(SUMPRODUCT(--(A4=Sheet2!$A$2:$A$5),--(B4+3/(60*24) =Sheet2!$B$2:$B$5),--(B4-5/(60*24) =Sheet2!$B$2:$B$5),ROW($C$2:$C$5)))-1) I...

Excel: Lookup problem, douglas m smith, control toolbox

douglas m smith, control toolbox, data validation: Hi David, This is doable, but I m not sure which kind of dropdown box you are using. Is it embedded in a cell using the data validation dropdown box option or is it a floating control object (and if so, which kind, Forms or Control Toolbox?)? If my...

Excel: Lookup problem, column c, sinc

column c, sinc, 28 april: Chester I m having a hard time reading the data and the results that you want. Question is the data in columns as follows: looking at row 2 column A=2 column B=1-4 column C=360 column D= ??? or maybe blank column E= 11160 Under your results...

Excel: Lookup Question, seperate sheet, column c

seperate sheet, column c, quanity: I think that you will need to use a macro. The following one can give you some ideas, it will search the value on the selected cell and will return the values from column C and E if there is a match on any of the sheets. It will search only on the column...

Excel: Lookup within a range, test b1, decriptor

test b1, decriptor, vlookup: SUMPRODUCT is originally designed as a means to SUM the product of a load of multiplications - so for example, a1:a10 contain quantities, B1:B10 contain prices, so sumproduct will give you the value of a1*b1 +a2*b2 etc. The extension I used is to get it to...

Excel: Lookup returns wrong value, sinc, 28 april

sinc, 28 april, excel 2000: Hi Chester, Can you send me a sample of what you are trying to do. It is difficult to understand in the email that I get from allexperts.com You can send a sample spreadsheet to Cloverken@yahoo.com Also just a short sentence about what you want the formula...

Excel: Lookup a Sum of Numbers, vlookup, jan feb mar

vlookup, jan feb mar, d18: Hi Rou How are you? If you want I can write a vba program to do this, but the easiest way is to use an intermediate column for suming the data for each month: 1. Insert a column to the right of the items names A,B,C e.g. range B18:B20 2. type =Sum(C18:...

Excel: Lookup tab name in cell code from another cell, macros, free time

macros, free time, budget: Sorry, typically I do not write macros for people on this site who seem to think I am expected to do so, who need me to do so, and/or who ask me to do so. 99% of all macros requests are more involved than you first think and therefore take longer to write...

Excel: Lookup value in Column and return value of another column, cell c5, column c

cell c5, column c, merry christmas: Put this formula in a cell in the first row on Sheet1 and copy down the column as far as you need. =IF(Sheet2!C1= X ,Sheet2!A1, ) If an X appears in cell C5 on Sheet2, then the name in cell A5 on Sheet2 will appear in row 5 of whatever column you chose...

Excel: Lookup, green pear, apple1

green pear, apple1, blue apple: No, you confused me even more. However, from your original question ...tell me how many Red A s, Red B s, Green A s etc. ... then you can use the Conditional Sum tool to accomplish this. Click Tools, Wizard, Conditional Sum. If this menu choice is not...

Excel: Lookups across multiple sheets, vlookup, excel sheet

vlookup, excel sheet, hth: if JULY is in D3, for example, use a formula something like this: =VLOOKUP(A1,INDIRECT(D3& !A1:F100 ),6,FALSE) where A1 is the value you re looking up and A1:F100 are the cells in JULY where the table lies. INDIRECT converts text to a reference, so in...

Excel: Followup: Loop to check selected cells for input box character, alpha numeric, occurrance

alpha numeric, occurrance, input box: Katie, Oh, each character in the cell. Yes you are right, with or without the Val my routine would not work. Try this and let me know what you think. XF Sub myFind2() Count = 0 InputValue = InputBox( Enter Input Value ) For Each cell...

Excel: Loop a macro x times based on user input box, macro x, input box

macro x, input box, ogilvy: Sub RunABunch() Dim ans As Variant, i As Long ans = Application.InputBox( Enter a Number of loops , Type:=1) If Not IsNumeric(ans) Then user hit cancel, so exit sub Exit Sub End If For i = 1 To CLng(ans) do your work here Next i End Sub...

Excel: Loop please, iloop, many thanks

iloop, many thanks: Again, you are not clear enough but here is what I think you want For iloop = 1 To ListBox1.ListCount If ListBox1.Selected(iloop - 1) = True Then Call Print_this_Instead Sheets( sheet1 ).Range( A20 )=ListBox1.Selected(iloop - 1) ListBox1.Selected(iloop...

Excel: Loop through range and find on condition, n23, loop through

n23, loop through, many thanks: why not say that in your profile and save us all some time? [I have tried but it would not allow me to do so.] I would not asked if you had made it clear - your profile gives you the opportunity to do so. [I understand but it seems the site would...

Excel: Loop, blank cell, stepper

blank cell, stepper, aidan: I can re-do this for a do while loop, but a for next loop seems more logical - not sure why it s overwhelming as I d more or less written it for you!! Suggest you mail me a sample file (aidan.heritage@virgin.net) and I ll put the macro in place for yo...

Excel: Looping through Cells, excel97, excel 97

excel97, excel 97, thanks john: john, I could offer some code, but it would waste time for both of us. If you want to send a sample workbook with your data and indicate what action you want to take and what results you want to see. Example: Working in Excel 97, When I enter Roger...

Excel: Looping IF logical tests, open parenthesis, logical tests

open parenthesis, logical tests, logical test: Hi Dan, When you link multiple IF s Excel calls it nesting IF s. With Excel 2003 and previous versions you can only nest 7 If s. With Excel 2007 you can nest up to 64 IF s. The one thing you have to keep in mind is that the multiple IF s will be evaluated...

Excel: Looping, target cells, target value

target cells, target value, cell c3: Dear Mohit, I am going to make certain assumptions here- (1)You canmodify the VB code as required. (2) Cell A2 = Total Calls Taken (3) Cell B2 = Calls Transferred (4) Cell A1 = Target Value Presently 29.995% (5) Cell A3 = Original Value for Total...

Excel: Loops and Dim in VBA, sheet names, rcl

sheet names, rcl: Try this, you will need to change range references & sheet names to suit Option Explicit Sub test() Dim rCl As Range Dim rRng As Range Dim i As Integer i = 3 number to find Set rRng = Worksheets( Sheet1 ).Range( a2 , Range( a65536 ).End(xlUp))...

Excel: Loss of PATH in footnotes, custom header, excel 2000

custom header, excel 2000, footnote: Hi jhopkin How are you? When you do View - header and footer and press custom header or custom footer you can choose Path and filename from a set of buttons. if there are no such buttons, just write &[Path]&[File] on the header s section you want....

Excel: Lost custom toolbar, custom toolbar, standard toolbars

custom toolbar, standard toolbars, last thought: Toolbar customizations are stored in a *.xlb file. You can search your computer for this file and see if it has been deleted or moved. It is located in different places for different versions of Excel. If you find it, you can try opening it like a workbook...

Excel: Lost Excel Worksheet, all files and folders, excel worksheet

all files and folders, excel worksheet, backup system: Hi Cindy, I was wondering if this was two separate workbooks? You mentioned that it was two separate worksheets, which can be within the same workbook. Either way, here is a couple things you may try. 1. Did the IT guys try restoring the file from a...

Excel: Lost your e mail, e mail address, marvin gardens

e mail address, marvin gardens, funny joke: You found me! bobumlas@yahoo.com Sure -- give me Marvin Garden s phone # - but the last time I called him (a few years ago) he was quite clear he didn t like me any more - go figure! I upset him about something 847 years ago, so I can t remember what it...

Excel: label in excel, wsd, wsl

wsd, wsl, city state zip: Alan, I would suggest that it would be best to get the widths and heights of the columns and rows about right, then set it to print to fit to 1 page wide and whatever long - you can make this about any number, then alter the page breaks in Page Break Preview....

Excel: labelling, cell b2, header row

cell b2, header row, window menu: The freezing happens all at once. Use the Unfreeze command under the Window menu to Unfreeze the screen. If you re trying to freeze row 1 and column A, you need to select cell B2, and then Freeze the panes. Basicly, you need to select the first cell you...

Excel: labels from an excel database, laura howland, mailing labels

laura howland, mailing labels, must be a way: Laura Its easiest to print your mailing labels in Microsoft Word you can merge your list into Word and print the labels from there. Check out the help under mailing lists in Microsoft Word. I d explain it more myself however they do a better job than...

Excel: how to make labels from a list, e mail address, mr mrs ms

e mail address, mr mrs ms, word mail: Perry The answers go through allexperts, and we don t even see your e-mail address unless you include it in the body of your question. However answers will go back to your e-mail address via allexperts. To mass print labels from your list I believe...

Excel: labels in xl, wsd, wsl

wsd, wsl, address data: Alan, why reinvent the wheel. Avery Labels has an addin that works with Word. Word can use excel as a source for data when doing its mailmerge funtion, so I am sure you can print your labels by using the Avery Addin with the word mailmerge feature and excel...

Excel: over lapping times, schedual, e4

schedual, e4, 5pm: In order to answer your question on overlapping times on different locations, I would need to know what is the layout of your data. If you can post an example on how you organize the worksheet, I can try to figure out a formula than fit your case. Regarding...

Excel: large spreadsheets, douglas m smith, loading files

douglas m smith, loading files, brainbench: Hi again, Probably not, unless you only have a small amount now and all your other processes (including non-Excel stuff) are sluggish too. If you ve got 256MB or more, I doubt you would see a difference. I d recommend asking other experts too. ...

Excel: How to learn excel and evaluate my skill?, excel test, learning excel

excel test, learning excel, expertrating: Hi Myra, I too have taught myself in Excel. I ALWAYS use the help files provided and I am constantly searching the internet for answers. However, here are some good sites to review for new material you would like to learn: http://www.baycongroup.com/el0.htm...

Excel: limit of 255 characters in a cell, rejection notice, fondest dreams

rejection notice, fondest dreams, ioline: You can modify this code -- I included your question as the initial string to test with: Sub CountText() Dim text(1 To 50) n = 1 strg = My application is now up and running in the factory here at Ioline but as is the usual case we found a glitch....

Excel: limiting spreadsheet size, spreadsheet program, robust solution

spreadsheet program, robust solution, ogilvy: Each worksheet has a scrollarea property - however, the setting is not retained if you close the workbook and reopen it. If you know how to code macros, you can use the workbook_Open event macro to set the property on the appropriate sheets, however, as with...

Excel: line chart, axis labels, data labels

axis labels, data labels, triangle square: Amanda: By default, when using dates for an Axis, Excel likes to plot a smoother timeline. Thus, your data is in there on the respective dates, but the timeline itself is spread out over the entire date range (which is what you are seeing now). Here...

Excel: linging cells by the row, days of the month, months of the year

days of the month, months of the year, headings: No problem - the formula (if the summary was on the SAME workbook) would be something like =SUM(Sheet1:Sheet3!A3) where sheet1 is the first worksheet and sheet3 is the last It would change to something like =SUM([Book11.xls]Sheet1:Sheet3!A3...

Excel: how to link user input box on user form to macro, text input boxes, speedy reply

text input boxes, speedy reply, request answer: ADDENDUM: Great Steve. If you come back with more questions, make sure you use one of the OTHER experts that CAN speak and write clearly. Have a great day. -- Regards, Tom Ogilvy frmPersonal.iColMerge.Value msgbox iColMerge isn t what...

Excel: link userforms together, excel vba, ken hope

excel vba, ken hope, text boxes: Ken, Hope you are doing well. It is a bit difficult to visualize what you are trying to do. Where is the data entry occurring? In userforms1-3? Do you want the appropriate row number to be highlighted when someone enters data in one row? Also, when...

Excel: link, cell a2, word macro

cell a2, word macro, exit function: Hello mehrdad, I do not believe that what you ask is possible. I believe links must be hard-wired. However, if I am allowed to interpret the word macro very narrowly such that it is okay to use a user-defined function (UDF) rather than a macro, then...

Excel: linked columns/shared workbook, conflict resolution, excel 97

conflict resolution, excel 97, pentium4: It is feasable, and it COULD result in a conflict if users access the same (wrong) rows & try to save the document. If there is a conflict, you ll get a conflict resolution dialog in which choices can be made about who wins . If there are no cell conflicts,...

Excel: linked objects and images, vba script, different colors

vba script, different colors, actual image: Roger I found this vba script awhile ago and think it will work for you very well. You ll need to change the path to the images and also change the range of cells where they input the product names (which is named Products ). I also recommend changing...

Excel: linked workbooks, external references, ledgers

external references, ledgers, response time: Hello, Alan, I m not sure what problems with linking workbooks you re referring to. But in any case, I d recommend staying within a single workbook as it s much more efficient. Remote references (links to an outside workbook) may possibly take a little...

Excel: linkin a button, question thanks, sheet1

question thanks, sheet1, confidential data: Hi JOhn I think I can write code to do everything you want, it should not be hard really. What would be best if I could work withe actual sheet or a similar sheet with any private or confidential data taken out. If you can email the sheet to ; ...

Excel: linking a button to a sheet, control toolbox, button icon

control toolbox, button icon, command button: From main Excel menu, choose: View, Toolbars, Control Toolbox. The Control Toolbox will pop up; on it, click on the Command Button icon. Your cursor will turn to a cross; use it to click on your worksheet, hold and drag to create the button. You can then dbl-click...

Excel: linking cell data to drawing, target value, cell b2

target value, cell b2, art layout: You only need the code I sent you, do not put any title : Right click on the worksheet tab where you have the rectangle 1. Go View Code. Paste ONLY the code below. Do not add title! **********************start of code Private Sub Worksheet_Change(ByVal...

Excel: linking cells, counta, work sheets

counta, work sheets, cells: I would not duplicate a table, simply refer to it in the calculations - there isn t a feature that will extend a table if you increase it in another workbook/worksheet, but you could use formulas (such as counta and offset) to create a reference to the table...

Excel: linking cells, indirect address, sheet1

indirect address, sheet1, work sheets: You would probably need to use the Indirect function to create your links. Then when you insert a row, that formula won t adjust - if it pointed to row 5 before you inserted a new row 4, it will still point to row 5 even though row 5 now holds the old row4....

Excel: linking cells, work sheets, database functions

work sheets, database functions, autofilter: I don t think there is such a feature unless you have columns of formulas which wouldn t be efficient. It s not really necessary or efficient to duplicate data in a workbook anyway. Excel has a wealth of features such as PivotTables, AutoFilter and Database...

Excel: linking cells from other work books, cell switches, stroke of midnight

cell switches, stroke of midnight, base source: Micah Try something along the lines of this: =Offset([Otherbook.xls]Sheet1!$a$1,Day(today())-1,0) Day(today()) will give you the day of the month I use this to offset from a base source address. In this case, in the Workbook named Otherbooks.xls...

Excel: linking cells by the row, detail sheet, days of the month

detail sheet, days of the month, documents and settings: Assuming the January total is in cell A40 of sheet January06, then this formula, filled right should do the trick (I m assuming the detail sheet is called Detail.xls for this example; change the name and path...) =SUM( D:Documents and Settingslena[Detail.xls]jannuary06:december06...

Excel: linking cells i think?, left hand column, vlookup function

left hand column, vlookup function, cell a1: Your data should be in the form of a table with the left hand column containing the names in the Validation List, in fact you can use this column for your validation. So ColmnA would be Name, ColumnB would be DOB and so on. Then it is simply a case of...

Excel: linking cells, imac 450, spreedsheets

imac 450, spreedsheets, sheet tab: Hi, Ron, I really don t know what pulldown link you re talking about. I ve been using Excel for over 20 years, and I m not sure what you mean. But it doesn t matter, because linking from one sheet to the other is already enormously simple: 1) Enter...

Excel: linking checkboxes, suitable solution, premises

suitable solution, premises, cells: I am not sure on what you mean by activating or deactivating the cells, so I am supposing that cell is locked, and the sheet is protected, and you want the cell to be editable when the check box is selected. Also, I am supposing that the check box that you...

Excel: linking comboboxes to each other, data validation, combo boxes

data validation, combo boxes, worksheet functions: From the same site, here is a good tutorial on how to fill a combo box from the control toolbox: http://contextures.com/xlDataVal10.html The part of filling the data is on the code in the example, but you can also do it on the properties windows. In fact,...

Excel: linking a drop-down list, cell h4, paste link

cell h4, paste link, drop down list: The reference should work fine, the thing to care about is that if the name of the sheet has spaces on it, it was to be quoted. For example: = Sheet 1 !H3 If this doesn t work, I may need to see the workbook, as it will be the only way to determine what...

Excel: linking Excel worksheets, c drive, help section

c drive, help section: Jay I never use this feature, so can t be of much direct help. I suggest you reask the question of another allexperts person. Also suggest you ck out the help section and go to linked objects from programs not on computer This may give you enough...

Excel: linking excel files, douglas m smith, backup path

douglas m smith, backup path, backup version: Hi Jay, This operation is going to require a macro. Something like: Sub SaveBackup() BackupDir = C:YourDirectoryPath MainDir = ActiveWorkbook.Path Filename = ActiveWorkbook.Name ActiveWorkbook.Save ChDir BackupDir On Error Resume Next Application.DisplayAlerts...

Excel: linking excel intake form to database, empty column, sequential number

empty column, sequential number, line space: Hi Russell, This sounds like a job for VBA programming language. You could probably get some complicated formulas to perform this process, however your worksheet will run faster and will actually be easier to build with some VBA programming. However I am...

Excel: linking files for automatic updating, level knowledge, programming knowledge

level knowledge, programming knowledge, reagents: if the files are known files with known names that don t change, but the values do get updated, then yes you can link to as many sheets as you want - if you are talking about creating new files from templates then this will be a serious problem to try to manage...

Excel: linking formulas between separate workbooks, microsoft excel 2002, cell a1

microsoft excel 2002, cell a1, trivial task: linking is to values only, just as entering =A1 won t pick up cell A1 s formula. To get the formula, you d have to use VBA code and would then need to know the paths to all the workbooks and sheets and cells -- basically, the answer you re going to get is...

Excel: linking horizontal data, vertically, formula index, sum formula

formula index, sum formula, index function: Here s a little exercise to give you the tools needed to change horizontal results to vertical results. Create a blank workbook. On Sheet2, range A10:E10, put some numbers representing your horizontal results. Then name that range results . (Select the...

Excel: linking multiple sheets using VBA, parent database, database concept

parent database, database concept, vlookup: Hello Anne, Sorry to disappoint this time, but Excel doesn t support that concept. I believe you are describing referential integrity which is a relational database concept - but excel isn t a database engine and doesn t support relational databases. ...

Excel: linking several spreadsheets, master spreadsheet, slave files

master spreadsheet, slave files, kamps: stefano You cannot have a link to a Password protected workbook. However, when Excel recalculates any one of the formulas refrencing the Protected workbook you will be prompted for the Password. This would undermine the use of the passwords. I am not...

Excel: linking sheets for continual updating, level knowledge, reagents

level knowledge, reagents, multiple files: You can link to another (closed) workbook with a formula like = C:My Folder[MyData.xls]Sheet1 !A1 then when you open the workbook containing the formula, it will ask if you wish to update links (or it will do it without prompt depending on your settings)....

Excel: linking sheets on spreadsheets, vba procedure, information thanks

vba procedure, information thanks, spreadsheets: You need formulas in B which point to A, something like this in File B: =[FileA.xls]Sheet1!A1 Then whenever A1 changes in FileA, the change will be seen in FileB (with calculation on). If you want to have EVERY change in FileA be seen on FileB, you either...

Excel: linking spreadsheets to master sheet, skid steer loaders, mainframe area

skid steer loaders, mainframe area, running into trouble: Miranda, It seems to me that the simplest way to do this would be to create the Master with columns that indicate which common area the part is used in. So if a part is used in 3 areas, it would need 3 columns to indicate that. Then, to split them up,...

Excel: linking workbooks, ledgers, dilema

ledgers, dilema, pitfalls: Hello, I understand your dilema. Each solutino presents its own problem - that of maintaining link locations or that of file sized becoming too large. The single large file would be limited by the amount of memory in the machine trying to access / use...

Excel: linking worksheets, cell a2, sheet1

cell a2, sheet1, numerical data: Hi Patrick, I would say your best bet is to use conditional formatting. Highlight all of sheet2(or at least the linked area) and choose Format/Conditional Formatting. Choose Cell Value/Is Equal to/ 0 Under the format, choose a font color of white. If...

Excel: linking worksheets, column headings, mail

column headings, mail, ctrl key: How would I link the various worksheets to the master sheet or table? Is this the best way to go? Probably not. This is the ideal situation for you to get your data into a database. Also, since the monthly data runs consecutively for the whole year,...

Excel: links between informations, cell a1, customer change

cell a1, customer change, information moves: Based on your new description of the problem: =HYPERLINK( [Book1]Sheet1!A &MATCH( Garner Store ,A10:A100,0)+9, Abbot Store ) Assumes a new workbook (change Book1 to the name of your workbook such as MyBook.xls) with information on sheet1 -- Regards,...

Excel: how make a list, paul hutchins, bill kaufman

paul hutchins, bill kaufman, frank eaton: You can use the text to columns feature to help you here. Step by step it would be: 1. Paste the addresses in cell A1 2. Go to menu Data- Text to Columns, choose Delimited in the first step, check Comma on the second and click Finish. This will spread...

Excel: list box from FORMS toolbox, macro in excel, listboxes

macro in excel, listboxes, listbox control: Sudarshan, I copied the code from your posting and pasted it into a general module (insert= Module in the VBE). I then made the Forms toolbox visible and selected the Listbox control, rubberbanded it on the active worksheet. Assigned the Listbox1_Change...

Excel: list box in work sheet, matchentry property, data validation

matchentry property, data validation, control toolbox: The Excel validation cannot be used in the way that you want. There are some ways of making a list show different values depending on the value of other list, but not to restrict the list as the same time you are typing. In this link there is information...

Excel: list box, data validation, combobox

data validation, combobox, drop down list: You could use the ControlBox toolbar and put a combobox on the sheet. Set the ListFillRange property of the combobox to a range on the sheet containing your a1,a2,a3,...etc. When you type an a into this box, it will prompt you with the first item on the...

Excel: list / cell specify, car electricity, dropdown arrow

car electricity, dropdown arrow, speedy reply: Sorry, based on my understanding of what you want to do, Excel doesn t provide any functionality that would support that. You can t store two different types of information in a cell or associated with a cell and work with that information just using formulas....

Excel: A list of combinations of two numbers with a specific, vba script, unique records

vba script, unique records, number combination: I think I will be able to come up with a solution, but I just need it clear in my head what would happen in an EVEN number situation (as I see it, any odd number situation can produce a starting set of combinations with no problem (eg 7 would be 1 2 3...

Excel: How can i take this list and put the email in column a and the name in column b in excel?, paul hutchins, bill kaufman

paul hutchins, bill kaufman, tom ewing: Here is what I would do... 1. Copy all. 2. Paste to Word 3. Hit Ctrl+H a. In Find What, put ), b. In Replace With, put ^p c. Hit Replace All d. In Find What, put a space and a ( e. In Replace With, put ^t f. Hit Replace All 4....

Excel: list files, excel vba, folder path

excel vba, folder path, cheers: Hi Rachel, How are you? 1. Tools-macro-visual basic editor 2. insert-module 3. copy Sub AllFilenames() Rem Change D: to your folder path D = D: Cells(1, 1) = Filenames r = 2 f = Dir(D, 7) Do While f Cells(r, 1) = f r = r...

Excel: list the words in a cell

What do you mean list the words in a cell ?. The words are already listed if they are in a cell. And is there more than one word in the cell? And what do you want to do with the words found that meet this criteria? Please remember I can not see what...

Excel: listbox, database area, excel workbook

database area, excel workbook, combo box: It looks like you re using a listbox that you ve placed on the sheet using the Forms toolbar. You ought to look into using the Control Toolbox instead. However, since you re using the Forms, your macro is correct, if your listbox is named: List Box 1 ...

Excel: listbox, control toolbox, listindex

control toolbox, listindex, cell addresses: Ken, VBA doesn t have an event for when a listbox is scrolled. The closest that you can do is use the Change event. When one item is selected in the first listbox the corresponding item can automatically be selected in the second listbox. To do that, open...

Excel: listbox, userform initialize, additem

userform initialize, additem, hey dave: Hey Dave, Try this code: Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer With Me.ListBox1 .Clear ListItems = Range( yourRangeName ).Value ListItems = Application.WorksheetFunction.Transpose(ListItems)...

Excel: listing by date/total, column headings, pivot table

column headings, pivot table, business lines: This would be easiest by setting up a simple pivot table. Set up your columns to be DATE and LINE # and even TIME if you wanted more detail. Highlight all your data, including the column headings and go to data/pivot table and chart click next, next,...

Excel: lists, validation criteria, data validation

validation criteria, data validation, column entry: Ty this method instead of sorting Sometimes you may want to prevent users from entering duplicate values in a range of Excel cells. For example, you are entering price data for a number of items, and you want to make sure all item numbers entered in range...

Excel: little job, sumif, microsoft excel

sumif, microsoft excel, felicia: Hi, Felicia. Email your workbook to anne at office articles dot com and I ll take a look. You could also check out my article on SUMIF with multiple criteria at: http://www.officearticles.com/excel/sumif_using_multiple_criteria_in_microsoft_excel.htm Perhaps...

Excel: down loads for excel, windows 2000 xp, xp home edition

windows 2000 xp, xp home edition, windows 2000: Bunny What type of downloads are you looking for. Office Excel would be the same Excel you have on your system which is Windows xp by the sounds of it. If you go to www.microsoft.com/downloads it will list all the excel downloads you will need. Richar...

Excel: locating a matching value, target cell, word name

target cell, word name, click tools: Open your workbook. Click Tools, Macro, Visual Basic Editor. Double-click on ThisWorkbook. Copy and paste the code below into ThisWorkbook. Option Explicit Public Sub FindMatch() Dim strMatch As String Dim strAddress As String Dim...

Excel: locating a matching value, expert listings, excel expert

expert listings, excel expert, macro code: Mark, what is the reason that you don t use Edit/Find manually? I m not sure what you re trying to do, but I ll assume that for some reason, you need a macro to make the cursor jump to the matching cell. As you may already know, worksheet functions (such...

Excel: locating a matching value, b cells, excel 2000

b cells, excel 2000, cheers: Hi Mark! How are you? Please have a look at that one Sub searchingword() Dim A As Range, B As Range Set A = Range( A1 ) Set B = Range( B1:D16 ) ad = For i = 1 To B.Rows.Count For j = 1 To B.Columns.Count If B.Cells(i, j) = A.Value Then...

Excel: locating toolbar, cell b6, column headings

cell b6, column headings, cursor location: Commandbars have a top and left property. You can play with those, but it s not easy to position them exactly where you want, because it depends on how many other doolbars you have showing, whether you re displaying row & column headings, the size of the Excel...

Excel: How to lock a cell so you can't even click in it, format cells, office 2000

format cells, office 2000, excel 2000: Hi Adam, How are you? I do not have Excel 2000 installed but what I can remember is the following: 1st Format -cells -protection and unlock all the cells 2nd Format -cells -protection Lock the cells you want to prtoect 3rd TOOLS -PROTECTION SHEET Protect...

Excel: lock format of unlocked cell, format cells, format columns

format cells, format columns, excel 2002: Without resorting to vba coding... I don t think this is possible. It may be in Excel 2002 or later. If you re using one of these later versions, you could try: Go to the Tools menu, choose Protection, Protect Sheet, and put a check next to Format Cells,...

Excel: lock a name definition, cell references, string arguments

cell references, string arguments, tricky question: Sverker The way to lock it would be to use Indirect =OFFSET(Indirect( rådata!$A$1 );0;0;COUNTA(Indirect( rådata!$A:$A ));COUNTA(Indirect( rådata!$1:$1 ))) Now your cell references are string arguments which get converted to cell references by indirect....

Excel: locking out cells in rows, excel worksheet, msgbox

excel worksheet, msgbox, xls: in the macro - you see the formula If Trim(xls.Cells(row_num, 2)) Then ct = ct + 1 If Trim(xls.Cells(row_num, 3)) Then ct = ct + 1 If Trim(xls.Cells(row_num, 4)) Then ct = ct + 1 that assumes that the values are entered in columns...

Excel: locking pictures, best guess, exact method

best guess, exact method, access database: I hesitate to say that something cannot be done, as there are often workarounds, but I m not aware of one in Excel here - which as I say, just means I don t know one, not that there isn t! My own suggestions would be to EITHER export the information to...

Excel: lockout, shared drive, security model

shared drive, security model, excel 2002: Michael, If you have excel 2002 or later, this should be supported in the normal sheet protection features. I don t see a macro having any play here because the user could just disable macros when he opens the workbook. My opinion is that if you allow...

Excel: logical ?, email attachments, expertise thanks

email attachments, expertise thanks, data validation: Sounds interesting - but possibly difficult! item three I think I would handle by letting them choose first! I cannot instantly think of any other way of doing it. For one and two, I would PROBABLY build a list of the people on one sheet of a workbook...

Excel: login time and logout time, logout time, cell b1

logout time, cell b1, cell a1: Yes, I understood your idea and the only way is with a macro as the first sentence of the second part of my answer stated. A formula will not work because it will not be a static date as I suggested it might not knowing everything about your scenario. ...

Excel: look up formula, check stats, f50

check stats, f50, f7: Does this formula work for you? =VLOOKUP( CHECK STATS !B7, FINAL AMOSS !A7:F50,6,FALSE) It takes the value in cell B7 of Check Stats and looks for it in the range of Final Amoss A7 through A50. If it finds the value then it returns the corresponding...

Excel: A look up Macro?, dropdown list, j6

dropdown list, j6, max size: No formula will do that. Formulas are designed to always recalculate based on something changing, like a cell referenced in the formula, or a date. Thus the use and intent of a formula. The only ways to do this are either manually typing the date as a...

Excel: look up question, vlookup formula, combo boxes

vlookup formula, combo boxes, customer names: Tim Sorry I think I answered your question yesterday but didn t hit he send button and lost the answwer. to bad, cause it was a long answer. Here in shor form is what I said--I don t compoletely understand the problem-but it sounds as though you want...

Excel: look up question, cell b2, absolute and relative references

cell b2, absolute and relative references, combo boxes: You can use a combination of INDEX and MATCH, that can look both on rows and columns of a table, something like: =INDEX(Sheet2!$B$2:$DP$201,MATCH($A2,Sheet2!$A$2:$A$201,0),MATCH(B$1,Sheet2!$B$1:$DP$1,0)) Enter this formula in cell B2 of sheet1, and it will...

Excel: look ups??, combo boxes, customer names

combo boxes, customer names, customer name: Assume on Sheet1, the customers will be in B1, C1, D1 and E1 in B2 put in the formula =if(B$1= , ,index(Sheet2!$A$1:$DP$201,row(),Match(B$1,Sheet2!$A$1:$DP$1,0)) Now select B2 and drag fill to the right to E2 now select B2:E2 and drag fill down...

Excel: lookup, false argument, optional argument

false argument, optional argument, pick 3: Well, like I said also, what is your question? All you give me is information about what the function will not do and do not ask a question. Regardless, you may want to use VLOOKUP, a much more commonly used function than LOOKUP. VLOOKUP provides a forth...

Excel: Can you do a lookup with 2 values and return 1 value?, dget, c7

dget, c7, c4: Joseph: This can be done with the SUMPRODUCT function. I have uploaded an example here: http://home.swbell.net/nate-sus/excel/nodes.xls The formula in cell C7 is what you are looking for: =SUMPRODUCT((A7=A2:A4)*(B7=B2:B4)*(C2:C4)) It takes the...

Excel: If/lookup?, douglas m smith, cell a1

douglas m smith, cell a1, vlookup: Hi Shellie, A look up function (like VLOOKUP) is meant to return a value and further, may return a result even in an exact match is not found. However, if you use MATCH, this will solve your problem. MATCH will return a number representing the location...

Excel: lookup, index sheet, b1000

index sheet, b1000, column c: if the combination of A1&B1 is found in columns A & B of Sheet B, and you re trying to pick up column C from sheet B: ctrl/shift/enter this formula on sheet A: =INDEX( sheet B !$C:$C,MATCH(A1&B1, Sheet B !A1:A1000& Sheet B !B1:B1000,0)) If I misunderstood...

Excel: lookup?, mailer daemon, exact input

mailer daemon, exact input, email domains: Glad to hear that :). You should be able to copy and paste the final result into Word directly from Excel. Word will probably put it into tables , and if you don t want that to happen, then do the following: In Excel, copy the emails. In Word, click...

Excel: lookup, sumproduct, sequential numbers

sumproduct, sequential numbers, column c: Mike, Best I can offer is to set it up for you if you send me the worksheets and an explanation of what you want to do. The formula I provided works under the conditions I described I did notice a typo in the formula. The B2 should have been B1. ...

Excel: lookup formula problem, personal pet peeve, vlookup function

personal pet peeve, vlookup function, option argument: Assume you have data in A1:B5. A1 has the first well, with a name of 1-4 . Next to that well name in B1 is its volume. A2 has the next well name of 2-4 and in B2 is its volume, etc. Assume further that you type a well name of 1-4 in D1 and in...

Excel: lookup formula problem, vlookup formula, index column

vlookup formula, index column, sinc: If you sort your data on Column B, since it is text, you will see that you don t have it in order. If you sort your data on column B (ascending), then the formula will work (lookup expects a sorted index column or row). If you don t want to sort your data,...

Excel: If/lookup formula, mass merchant, true condition

mass merchant, true condition, a7: There are two ways of doing this. You need to use an IF statement and the IF statement will either have two lookups in it or will have one lookup and two separate ranges for the lookup to look in =VLOOKUP(A7,IF(A7=1,A1:B3,D1:E3),2,FALSE) The first one...

Excel: =lookup function, lookup functions, excel 2002

lookup functions, excel 2002, e mail: Shaun I think the best thing would be for you to send me the spreadsheet and I can then better understand whats gong on. When you send the spreadhseet tell me what data your trying to reference, etc. The lookup functions can be tricky to get correct,...

Excel: lookup functions, capex, lookup functions

capex, lookup functions, fourth column: Mike, If capex is unique to the fourth column, you can simply use a vlookup statment like this: =vlookup( capex ,D1:E5,2) - assumes the 15471 starts in A1. I do not feel like this is the case, though. The most efficient way to do this is to make a table...

Excel: lookup on horiz and vert criteria, escalation factors, price escalation

escalation factors, price escalation, formula index: Hi Mark: I would like to answer this question with a link to a sample spreadsheet, but I m out of town at the moment. As such, I ll just provide an example in this email...if you need a physical Excel file as a further example, please let me know and I...

Excel: lookup/macro/VBA which also copies (or looks up) the cells formatting, blank boxes, officer names

blank boxes, officer names, vlookup: After you have found whatever you are looking for then just a simple copy and paste will transfer the format of what is being coped as well. And code for copying and pasting will do that and can be recorded. If you are using formulas to look up or find...

Excel: lookup, match and index functions, hlookup, cell location

hlookup, cell location, vlookup: If your table/array/database is in A1:F100 where the labels are in B1:F1 and A2:A100, then if the column list reference is in cell K1, for example, and the row list reference is in K2, for example, this formula will do it: =INDEX(A1:F100,MATCH(K1,A1:F1,0),MATCH(K2,A1:A100,0)...

Excel: can I 'lookup' a named range, formula index, c10

formula index, c10, ogilvy: In C12 put in the formula =INDEX(INDIRECT($C$10),ROW(A1),COLUMN(A1)) then drag fill right to G12. Then select C12:G12 and drag fill down for 21 rows. the formula in the lower right corner will end up being: =INDEX(INDIRECT($C$10),ROW(E21),COLUMN(E21))...

Excel: lookup question, bbank, abank

bbank, abank, c5: If the first John is in cell A2, then you can use this formula: =SUMPRODUCT(--(A2:A5= john ),--(B2:B5= bbank ),C2:C5) or, you can place name in a cell (say E1) amd bank in a cell (say E2), then use this: =SUMPRODUCT(--(A2:A5=E1),--(B2:B5=E2),C2:C5) Of...

Excel: lookup reference, lookup reference, reference column

lookup reference, reference column, cell b1: Example: In cell A1, you have the Column Header Client and below it, in range A2:A10 you have various client numbers. In cell B1, you have the Column Header Data , and in B2:B10 you have some type of Data associated with each of these clients. You want...

Excel: lookup reference in excel, indirect address, lookup reference

indirect address, lookup reference, doozey: If the sheet is named California and the user enters California in cell B9 of the sheet with the formula =Indirect(Address(5,3,1,true,B9)) the Address function creates a reference like California!C5 The indirect turns that into an actual cell reference...

Excel: lookup by selection of two or more fields, e mail address, vlookup formula

e mail address, vlookup formula, data validation: Samir You can use data validation and drop down lists to make your selection of city and rate, then you can use a vlookup formula that looks up the rate based on the selected city/rate type. If you like, I can send you an excel file with an example of...

Excel: lookup and if statements, douglas m smith, brainbench

douglas m smith, brainbench, mvp: Hi Tracy, Your situation has 28 (7 ratings x 4 ranges) so a standalone formula is going to be a problem. Your best option is to set up a table and lookup the result based on the rating and range. It will be difficult to explain what to do in this format,...

Excel: lookup type question, vlookup, type question

vlookup, type question, high note: Hello Matt Assume 1 to below 300 is low 300 and less than 600 is Medium greater = 600 is High =IF(AND(ISNUMBER(A1),A1 0),IF(A1 300, Low ,IF(A1 600, Medium , High )), ) Note that you can not nest more than 7 levels deep in xl2003 and...

Excel: lookup value between columns, sheet1, vlookup

sheet1, vlookup, column c: I must be misunderstanding the question here as it sounds as if you have resolved the problem yourself by using vlookup? The only issue (presumably) is that the value may be on EITHER sheet1 OR sheet2, so I would EITHER use an IF formula with iserror, or...

Excel: lookup, checkbook register, occurance

checkbook register, occurance: If your values are in col A, for example, and the categories (gas) in Columb B, then this formula will add up all the gas: =SUMIF(B1:B1000, gas ,A1:A1000) Adjust the columns (and the last row#) as you see fit. That is, maybe the formula is =SUMIF(C1:C50,...

Excel: lookups, match, index, quality score, index quality

quality score, index quality, location column: On your quality sheet, I understand that cell A2 is 75.0, A3 is 75.1, etc, which cell B1 is California , C1 is Oregon , etc. I ll assume for example that this entire table is in the range A1:G20. To return a result on this table for a Quality of 75.2...

Excel: for loop on 2 data sets, dear bill, a12345

dear bill, a12345, dataset: Yes. Regardless of the number of records the filter will display data for just the state or states and ID or ID s you choose. So, I don t understand why you think the number of records prevents you from doing it this way. Perhaps I don t understand what...

Excel: loop until a key is pressed, vba code, xls

vba code, xls, message board: Hi Lucas, Sorry I do not know enough VBA to help. You can download and example workbook at www.squish.com/cloverleaf/loopexample.xls I understand this is not what you are looking for. You can try www.mrexcel.com message board there are several VBA experts...

Excel: loop please, iloop, many thanks

iloop, many thanks: I don t understand the question. I m assuming this is NOT what you re looking for: For iloop = 1 To ListBox1.ListCount If ListBox1.Selected(iloop - 1) = True Then Print_With_Amends ListBox1.List(iloop - 1) ListBox1.Selected(iloop - 1) = False...

Excel: loop to run until a key is pressed, expert listings, excel expert

expert listings, excel expert, easy job: Hello, Lucas, I guess you didn t notice where I say that I m not familiar with VBA. (I mention it in two places: both in my expert listing and on the question page.) I am a programmer, but I use the old macro language that came out with an earlier version...

Excel: loop through textboxes in a userform, array visual basic, control array

array visual basic, control array, visual basic for applications: Hi Kristof, What you need is a control array. Visual Basic allows this, unfortunately Microsoft did not transfer that capability into Visual Basic for Applications. The best I ve been able to do when I need something like this is to loop through the controls...

Excel: looping, excel solver, qdot

excel solver, qdot, gyula: Look into the Excel Solver. That can easily do this using VBA or even without VBA. For examples see: http://www.vertex42.com/ExcelArticles/excel-solver-examples.html http://www.solver.com/suppstdvba.htm http://support.microsoft.com/kb/843304 ...

Excel: loosing my formula, face value, aidan

face value, aidan, email: At face value, it would APPEAR that a macro is getting involved somewhere along the line, but it is puzzling if the sheet is protected - you do say that the cell is hidden, which means that you cannot see the formula in the formula bar, but I guess this isn...

Excel: lost file, recycling bin, uneccesary

recycling bin, uneccesary, dos program: Katie It may still be on your floppy if you haven t placed anything else onto it or it could be retrieved from your harddrive. However the programs to do this are reasonably expensive. The best one is http://www.r-undelete.com/ which if you file is under...

Excel: lost file, douglas m smith, recycling bin

douglas m smith, recycling bin, uneccesary: Hi Katie, This is a disk issue, not an Excel issue. You will need a disk recovery program (Norton, Symantec, etc.) and some luck to recover your file. When a file is deleted, only the file name is actually deleted so the file contents still might be there...

Excel: lost file, recycling bin, uneccesary

recycling bin, uneccesary, tmp files: It sounds as though you may have deleted the file in error, but you haven t said how you are looking for the file - if using explorer, it should be visible if it s there. Only suggestion if it HAS been deleted (and files from a floppy don t go to the recycle...

Excel: lost file, free unerase software, recycling bin

free unerase software, recycling bin, google: First, I would be very careful with the floppy. If you changed floppies while a file was open, this can cause the floppy to get corrupted. If that is the case, you might be out of luck. If you think you accidentally erased the file (files erased from...

Excel: lost file, google search, recycling bin

google search, recycling bin, uneccesary: Katie, Sorry to hear that you lost your work. This isn t a problem with Excel, so I m not really what would be the best method to recover it. I did a google search on file recovery and found some sites that may be relevant: http://snipurl.com/5x10 You...

Excel: lost menus, worksheet menu bar, level menus

worksheet menu bar, level menus, search capabilities: Eric, I assume you did this using macros? In any event, do Alt+F11 to get to the VBE (VBA editor). In the menus do Insert= Modules in the resulting module put in code like this Sub RestoreMenuBar() Application.CommandBars( _ Worksheet Menu...

Excel: NOT A MACRO, cell a2, sarcastic remarks

cell a2, sarcastic remarks, cell a1: Odd, I never panic concerning macros. I seem to recall that you were unhappy with a response I had given you and you said some less than complimentary, immature, and sarcastic remarks concerning that repsonse. Therefore I wonder why you still ask me questions....

Excel: MACRO for copying online cvs to Excel spreadsheet, keyboard shortcut, share range

keyboard shortcut, share range, spread sheet: I assume that the workbook that runs the code when yo get the error is not named and is not in Getting URL into spread sheet.xls but it was when you first recorded the macro. If this is the case then, as I said, assign the workbook the code is in to...

Excel: MACRO QUESTION, error checker, fww

error checker, fww, questio: First of all, ...with a dot ( example 34.23 ), which is unknown number format for EXCEL... 34.23 IS a valid format. Try typing 12.34 in a cell and you will see. You must have ommitted something in your question. Secondly, I do not give my email address,...

Excel: IS THERE A MACRO, r2 r3, delma

r2 r3, delma, ubound: Yes, VLOOKUP wants data in columns, but HLOOKUP wants it in rows. However, the data should be in separate cells, not separated by commas as you have it. This macro will do what you want (assumes the active cell is on the part# (123 in this example)) Sub...

Excel: MACROS, daily basis, vbe

daily basis, vbe, double click: Use the Workbook_Open event. In the VBE (where macros live) double click ThisWorkbook. In the code window click the drop down that says General and click Workbook and the Workbook_Open event/macro will appear. Put any code here that you want to run when...

Excel: MAKING LABELS, file folders, excel spreadsheet

file folders, excel spreadsheet, spread sheet: Hi, Pamela, You don t need to copy and paste into Word. Word will handle it all for you. Start out in Word, and go to Tools/Letters-and-Mailings/Envelopes-and-Labels. (If you re using a different version of Word and don t see that command, look under...

Excel: MATH IN MILITARY TIME IN EXCEL WITH A DATE CHANGE, military time, flowrate

military time, flowrate, interval: Jerry I haven t used military time so am not sure of the answer, but I will look into it some more and try and get a finite answer for you. One option may be to use the format cell time and try the one that says 37:30:55 which should allow you to add the...

Excel: IF+ AND + MAX, sorry jeff, exact formula

sorry jeff, exact formula, negative result: Moshe, good to hear you got it figured out. I admit I did leave off the parenthesis - oops. Anyway, the (E1-F1) G1 just tests to make sure the output of E1 minus F1 is less than the value in G1. Then E1-F1 of course is the result if all of the conditions...

Excel: IF+ AND + MAX, exact formula, g1

exact formula, g1, moshe: Moshe I noted that in the ratings you gave me an 8 for clarity. I m sorry, I did not know you wanted a full explanation of the formula, but merely the the exact formula as you stated. I ll be happy to explain the portion that you don t understand....

Excel: MAX, array formulas, array formula

array formulas, array formula, number index: I am not sure what you are doing with that formula. A1 to B2 is 4 cells in a square and B4:B34 is 31 cells in a single column. Usually with sumproduct, you use areas of equal size and shape. Also, I don t know what that formula has to do with you question....

Excel: the MAX function, mymax, max function

mymax, max function, task selection: Hi Irene As my profile says I tend to focus on writing macros. In realtion to your problem I have put together the following code which does what you require using a macro Sub MAXFIND() Range( A1 ).Select Range(Selection, Selection.End(xlDown)).Select...

Excel: IF and MAX Statements, highest score, maximum number

highest score, maximum number, a1: Rob Lets assume that column A has the figures then the formula would be =if(a1=Max($A$1:$A$15),5, ) will give you 5 points in each cell that has the maximum number. This will automatically change if a cell within the range gets a larger value. Richar...

Excel: IF+ AND + MAX, g1 tests, douglas m smith

g1 tests, douglas m smith, max hi: Hi Moshe, The formula would be: =IF(AND(A1 D1,B1 C1),MIN(E1-F1,G1),???) You didn t specify what the result of the formula would be either of the test fail. Replace ??? with the result you want. (0, G1, Tests failed , etc.) The AND function evaluates...

Excel: Macro, formating, excel 2000

formating, excel 2000, formatting: You set it up by writing it. Either have the specific paths and workbook names in a separate workbook for the files whose contents you want to clear and then have the code open each one, clear the each one s contents, and then save each one and close each...

Excel: Macro?, booking sheet, cell a1

booking sheet, cell a1, excel 2002: Simon I may not be understanding the question, but it sounds like you need a simple link from one worksheet (the booking sheet ) to the invoice sheet. For example +Booking!A1 This formula in the invoice sheet 1 will copy data from cell A1 in the booking...

Excel: Macro, seperate sheet, auto run

seperate sheet, auto run, ogilvie: Royston As far as I know it isn t possible to run a macro from a cell, however you could run one from an event ie date change but if my memory serves me correctly you would need to create a visual basic script to run this. I am not well versed in vb so...

Excel: Macro, x cells, lotus 1 2 3

x cells, lotus 1 2 3, x loop: Try this. I did not use the colon method of putting two lines on one as you did. I find it confusing and it is rarely used. Therefore, I split the lines into two lines. Dim Original As Variant Dim TickMark As String Dim r As Long TickMark = Chr(39)...

Excel: Macro, excel spreadsheet

excel spreadsheet: Pawan Depending on the criteria for selecting what columns to delete it is possible to select them and then delete, via macro, or otherwise. I can t tell specifically what needs to be done since I don t know more about the criteria or the specific problem....

Excel: Macro, column names, resumes

column names, resumes, parameters: Pawan Sorry I have absolutely no experience with mapping so I won t be of much help. It appears as though you have asked this question of several allexperts people, If not then I suggest you reask the question and check the resumes for someone who is expert...

Excel: Can this be done by a Macro?, hello bill, blank cell

hello bill, blank cell, zero values: For [1] and [2], if you want to delete lines (rows, I am assuming, but just the cells themselves with 0 s could also be deleted) then you will need a macro to do that. If you want just a blank cell to be wherever you have a 0 in a cell then you could use...

Excel: Macro, xlstart directory, excel spreadsheets

xlstart directory, excel spreadsheets, unwanted files: sounds like the file is either located in your xlstart directory, or was made part of personal.xls. Check the xlstart directory for unwanted files (should most likely ONLY be personal.xls in there). OR, after cancelling to the prompts, use tools/options/General...

Excel: Macro, dear bill, column c

dear bill, column c, macros: If you are asking me to write this macro for you (I was not sure based on the way you worded this) then sorry I don t write macros for people on this site who either ask me to, soemhow seem to expect me to, and /or tell me to. Since I answer questions (not...

Excel: Macro, excel spreadsheet

excel spreadsheet: Something like this will do it fo ryou Range( A1 ).Offset(Range( b1 ).Value, 0).activate this will offset from A1 the number of rows that are shown in B1 - set this up to be part of the OPEN event of the workbook - if you have multiple sheets and won...

Excel: Macro, sheet1, macros

sheet1, macros, c100: Well that all depends on EXACTLY what you want to do and how much data (number of columns) you have stored for each person. A macro will work but you will have to write it and if you know little ot nothing about macros then you will have to get someone to...

Excel: Macro, financial spreadsheet, aidan

financial spreadsheet, aidan: More than one ! (1) Your macro probably says something like sheets( fin01 ).select instead of this have dim SheetName as string SheetName=inputbox( Which sheet name? ) sheets(sheetname).select (2) IF you can rely on them to always have...

Excel: Macro, speedy reply, format button

speedy reply, format button, hi bob: If the cell is A1, for example, use Format/Conditional Format, change cell value is to formula is , enter: =DAY(A1) 16 then click format button & choose your format. When you re back to this same screen, click Add, change cell value is to formula...

Excel: Macro, macro name, column c

macro name, column c, shortcut key: SAM You can create the macro by simpoly recording the keystrokes necessary to do all of the processes that you mentioned. Go to toolbar/tools/macro/record new macro name the macro, put in a shortcut key that will run the macro. Then proceed to...

Excel: Macro, export features, excel spreadsheet

export features, excel spreadsheet, tn5250: I am confused. It seems you answered your own question. IF, as you say, ...I don t think Mocha has any import export features... then how would it be able to ... input data from my spreadsheet to a program called Mocha... ? It has no import export...

Excel: Macro, excel tips tricks, unique records

excel tips tricks, unique records, capital construction: You can still do it via filtering. Filter on the owner description field only (Select that column before you filter, and if it asks you to expand the selection, say no). You may also have to select the visible cells only once the filter has been applied (shortcut:...

Excel: Macro, stamp method, time macro

stamp method, time macro, paste operation: Hi Rich, Your problem statement left me a bit uncertain about what you want to accomplish. I ended up assuming you simply want a macro that will copy to row 6 and successive rows each time it is run. I assumed this because you said that the macro would...

Excel: Macro, ogilvy, cells

ogilvy, cells: Sub addnumbers() Dim r As Long, i As Long r = 500000 i = 2 Range( B1 ).Value = r Do While Cells(i, 1) If Cells(i, 1) _ Cells(i - 1, 1) Then r = r + 1 End If Cells(i, 2) = r i = i + 1 Loop ...

Excel: Macro, wizard dialog, cell a1

wizard dialog, cell a1, outlook data: Keith Assuming your names are in column A, Select columns B:G and do Insert= Column no Select Column A and do Data= Text to Columns. Select Delimited. in the next wizard dialog, select Space as the delimiter. No Finish. If all you names are...

Excel: Macro, excel spreadsheet, dde

excel spreadsheet, dde: Hi Manish, What you describe sounds fairly straightforward, but I have a few questions whose answers would enable me to provide a solution to meet your need. If you could follow up with this additional information, that would be most helpful. 1. How...

Excel: Macro, grey background, background color

grey background, background color, formatting: You will have to write a macro to do this. But, if you can live with a slight variation of having every third row, for example, having a background color then do this. Select the entire range. Then, with the same cells selected, select Format, Conditonal...

Excel: Macro, false selection, paste application

false selection, paste application, copy windows: Unless I mistyped then If Sheets( ( Sheet1 ).Range( L3 ) 0 _ And Sheets( ( Sheet2 ).Range( L3 ) 0 _ And Sheets( ( Sheet3 ).Range( L3 ) 0 Then should be If Sheets( Sheet1 ).Range( L3 ) 0 _ And Sheets( Sheet2 ).Range( L3 ) 0 _ ...

Excel: Macro, txt files, notepad

txt files, notepad: Hi Gaurav, Recording alone will not help. You will need to write a macro. For instance, you may write for i = 1 to n (n=number of files you need to import) myFile = Scan_ & i & .TXT ---- Command to open the text file-- next i Also, when you...

Excel: Macro, cell a1, macros

cell a1, macros, free time: For your second question, yes, it is possible. And, sorry, as politely as possible, I don t write macros for people on this site who need one, want one, and/or seem to think I am expected to do so unless they are very short, quick, and simple. Perhaps...

Excel: Macro?, reference number, aidan

reference number, aidan, spreadsheet: Yes it would be possible, but I wonder why you need to do this - having a COUNTIF function against each employee would return a 1 for the names that DO exist on the right side and a 0 for the ones that don t - so you can get your list that way? A macro would...

Excel: Macro, a15, cells

a15, cells, cf: Well, it is simple enough to set up the CF for a number of cells. SImply select those cells and then select Format, conditional format and set tings up as if you are only doing it for the cell that is currently white in the selection (probably the first one)...

Excel: Macro, vlookup function, invoice number

vlookup function, invoice number, data columns: A formula will still work. Assuming the AR acct number data file is named Book2.xls, the data in that file is in A1:B10, and A1 has the data you will lookup in the other file,like cust # or cust name. Column A in the second file should have the data...

Excel: Macro, explorer pane, macro name

explorer pane, macro name, pwd: Royston, You can protect the VB code with a password as well. That way no one can see the code without knowing the password. To protect it, open the visual basic editor again. On the left side there should be a project explorer pane. Find the project...

Excel: Macro, target application, sheet changes

target application, sheet changes, excel 97: You are asking for a macro to start running and THEN CONTINUALLY run thereafter to check for these conversions and an opening macro can not really do that. What you need, as one solution, is an event driven macro - one that runs itself upon an action or event...

Excel: Macro, customise, dialog box

customise, dialog box, cheers: Hi Melissa! How are you? Please do the following: 1. Tools - customise 2. Drag the button you want to delete to the interior of the dialog box. (just drag the button to the tools-customise dialog box) It is easier to do than to say! Cheers...

Excel: Macro, commandbutton, command button

commandbutton, command button, dear bill: Not sure I understand what you want based on the way you phraed your question. It seems that you want to press ENTER at anytime during the entering of text in your textbox and have EXCEL push the commandbutton for you. If this is the case, then there is...

Excel: Macro, irow, blank row

irow, blank row, header row: Phyllis, I checked at home and found no record of having sent you an email. In addition, the comment about your problem that you posted to jog my memory didn t. I m wondering if I am suffering from Alzheimer s, or if perhaps you asked the question of someone...

Excel: Macro for Autofilter, cell a2, row header

cell a2, row header, r700: What you re asking for isn t called autofilter. It s called advanced filter. Your list, including headers, is in range B5:R700. You want to enter single letters in some of the cells in B4:R4 (leaving the others blank), then filter the database to show...

Excel: Macro to access other worksheets, customer range, control toolbox

customer range, control toolbox, command button: Can you create a macro attached to a button, that when you press it, it takes you to the sheet Customer? Yes Private Sub CommandButton1_Click() worksheets( Customer ).Select or Application.Goto Worksheets( Customer ) _ .Range( A1 ), True end...

Excel: Macro for accountant, copy windows, close application

copy windows, close application, spread sheet: Why are you copying data from the PERSONAL.XLS workbook? Typically, you would never store data in that workbook since its primary use is to store utility macros that can be run against ANY open workbook. Though it is OK to do so it is not typica...

Excel: Macro to automate copy - paste task, ms excel 2000, cell a1

ms excel 2000, cell a1, mm yy: Hi Hans, How are you? Please try the following - just for the date. For the other calculations you it is pretty the same. 1. TOOLS-MACRO-VISUAL BASIC EDITOR 2. INSERT - MODULE 3. COPY Sub Auto_open() Set orig = Sheets(1).Range( a1 ) orig.Cells(1,...

Excel: Macro, Make Chart Object Free from Cell Ref., douglas m smith, time consumming

douglas m smith, time consumming, link feature: Hi Ken, If all you want to do is to convert the chart data ranges to a data array, there s a quick way to do that. Click on a data line on the chart. In the Formula Bar, the SERIES function which defines the line will appear. If you highlight a reference...

Excel: Macro Code - Copy Function, paste cells, macro code

paste cells, macro code, copy button: I d do it like this: Sub Quick_CopyPaste() Dim OrdSht As Object On Error Resume Next Set OrdSht = Sheets( Order ) If OrdSht Is Nothing Then Set sht = Sheets.Add(After:=Worksheets(Worksheets.Count)) sht.Name = Order...

Excel: Macro Codes, working in hawaii, assumtion

working in hawaii, assumtion, blink of an eye: Jim, Sorry, I missed the xlPasteValues command in your code. That will make a difference. The Operation, SkipBlanks and Transpose options, however, do not pertain to your situation as I can see, so I did not include them. This code should work for you...

Excel: Macro from Command button (Run time error '1004' ), run time error, run time error 1004

run time error, run time error 1004, paste application: 1. When i open the other file(the file which i opened from the current file), it is showing Enable macro , Disable Macro window when i tried to open. Will it come like this? or Can we avoid appearing this Window..? That is a setting of EXCEL. Select Tools,...

Excel: Macro That Controls Word Save As Filename, cell b3, word application

cell b3, word application, open word: Sorry, I don t just write macros for people on this site who need one, want one, and/or seem to think I am expected to do so. 99% of all macros are more involved than what you think and rarely am I provided with enough specific and complete details. This...

Excel: Macro To Copy Defined Excel Ranges Into Word, e1 e2 e3, word application

e1 e2 e3, word application, element 10: Dim appwd As Object On Error GoTo notloaded Set appwd = GetObject(, Word.Application ) notloaded: If Err.Number = 429 Then Set appwd = CreateObject( Word.Application ) End If appwd.Visible = True...

Excel: Macro to Copy and Find Information, cap rock, relative references

cap rock, relative references, stubborn person: Joyce, the code isn t too tough. You just need to set a variable to the current cell value. It should look like this: CurCell = ActiveCell.Value Cells.Find(What:=CurCell, After:=ActiveCell, LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows,...

Excel: Macro for categorizing data, macros, poultry

macros, poultry, spreadsheet: One way is to use a loop that would loop thru each cell in the range whose data needs to be categorized. As the loop stops on or looks at each cell then use a series of IF statements that determines what category that cell s value needs to be and write...

Excel: Macro to change x-axis range on a chart, macros, axis

macros, axis, free time: ...and have a macro that changes the date range on the chart. ... Sorry, as politely as possible, I don t write macros for people on this site who need one, want one, and/or seem to think I am expected to write one UNLESS they are very short, quick,...

Excel: Macro check of 2 numbers, conditional formatting, format button

conditional formatting, format button, counterpart: Conditional formatting is MUCH easier - it s built just for things like this. Select All of column A, use conditional formatting, change cell value is to formula is , then enter this formula: =A1 B1 then click the format button & choose your highlighting...

Excel: Macro code - Copy button function, paste cells, copy button

paste cells, copy button, macro code: try this Sub NewSheet_And_CopyRange_Macro() Dim ShCount As Byte On Error GoTo CopyError Sheets.Add ShCount = Sheets.Count Sheets(ShCount).Name = Order Sheets( Main ).Range( A2:J49 ).Copy _ Destination:=Sheets( Order ).Range( A2 ) CopyError:...

Excel: Macro code - "Copy Function", paste cells, macro code

paste cells, macro code, copy button: Jack, The code for what you want to do should look something like this: Sub Macro1() Sheets( Main ).Select Range( B2:J19 ).Select Selection.Copy Sheets.Add ActiveSheet.Name = Order Range( B2 ).Select ActiveSheet.Paste...

Excel: Macro code - copy button function, paste cells, copy button

paste cells, copy button, macro code: The following code will do what you want Set existsheet = ActiveSheet Set NewSheet = Worksheets.Add NewSheet.Name = Order NewSheet.Range( A2:J49 ).Value = existsheet.Range( A2:J49 ).Value NOTE - (1) this macro will fall over if a worksheet...

Excel: Macro code for next row, false selection, blank row

false selection, blank row, macro code: Hi, Ganesh. I believe this will do what you need, though I removed some extra things like your selections and scrolls, which you shouldn t need. Sub test() On Error Resume Next last = Worksheets( Data Dump ).Cells.Find(What:= * , _ After:=[A1],...

Excel: Macro coding to prompt for user input, code references, vba code

code references, vba code, reformatting: Move all the macros to a new workbook which will NOT be one of the workbooks needing reformatting. This workbook should probably also be hidden (Window/hide) so it doesn t clutter up the environment. THen you can run the macro (Alt/F8) on the active workbook....

Excel: Macro conflict., conflict problems, test taker

conflict problems, test taker, work sheets: If the shared workbook is causing problems, I d suggest having 2 separate workbooks. One would be the test, and each test taker would open their own separate copy of the test (not shared). Then the macro would open a DIFFERENT workbook that s used only for...

Excel: Macro to copy the values between Max & Min, vba language, max value

vba language, max value, nada: Hi Anna, Here is the code to do most of your problem. I didn t do the mean and median in column T because there is no value from column M that corresponds to the mean to place in column S. This is because the mean will not necessarily match any value in...

Excel: Macro for copying sheet and move to end., vba code, osh

vba code, osh, current date: The VBA code to do this would be something like: Option Explicit Sub CopyMaster() Dim oSh As Worksheet Worksheets( Master ).Copy after:=Worksheets(Worksheets.Count) Set oSh = ActiveSheet oSh.Name = Master & Format(Now, mm/dd/yyyy...

Excel: Macro for copying down, target cells, cell a2

target cells, cell a2, data cells: Greg, One way to do this is to go ahead and store the formulae in the target cells. As the data cells are filled in, the formula cells are automatically populated. If you are worried about seeing error messages like #N/A or #Div/0, then you can use an...

Excel: Macro creation, example spreadsheet, macro creation

example spreadsheet, macro creation, cell characteristics: HI So you want to copy rows from one workbook to a new work book depneding on characteristics of the values in cell sin the source book. This is not a problem and cane asily be done by a macro set to detect font colour or interior colour. perhapes...

Excel: Macro to cut/paste 2 cells and shift up, every other row, cell b1, aa bb

cell b1, aa bb, strange format: You could also use some formulas on a second sheet. Suppose your data looks like this: RC A B 1 a b 2 1 3 aa bb 4 2 5 aaa bbb 6 3 In a new sheet in cell A1, enter this formula: =OFFSET(Sheet1!$A$1,(ROW()-1)*2,COLUMN()-1,1,1)...

Excel: Macro for a daily routine, vba fundamentals, ms excel 2000

vba fundamentals, ms excel 2000, xls workbook: Macros can t be run when the workbook containing the code is closed. IF you need for your macro to run against data from ANY open workbook then I would suggest moving your code to the Personal.xls workbook - a workbook whose one of many purposes is to store...

Excel: Macro to delete row, onecell, irow

onecell, irow, thanks for your time: dim wholeRange as range, oneCell as range dim iRow as long set wholeRange = activesheet.range( H60:H20060 ) for iRow = wholeRange.rows.count to 1 step -1 set oneCell = wholeRange.cells(iRow,1) If oneCell.value = Month 1 Then oneCell.EntireRow.Delete...

Excel: Macro to delete row, cell a1, hi aaron

cell a1, hi aaron, column c: Julian, If you notice in that example, when I define the ColA range, I use the SpecialCells method to pick the Constants (numbers & text) of the column only. You could easily change that line to select xlFormulas instead of xlConstants. I was just...

Excel: Macro difficulty still..., automation error, blank entry

automation error, blank entry, time error: Nothing in the code I sent you should cause that problem - I tested it here and it worked fine. Having the two sheets does not and should not cause the problem. I know what the error means but it should not be surfacing based on the code that I sent. ...

Excel: Macro for E-Mailing Excel Graphs, mail program, broadcast address

mail program, broadcast address, address type: You need to either use an add-in or Automate your mail program from Excel using VBA. In case you use Outlook, see the following two pages on how to do it: http://www.dicks-clicks.com/excel/olSending.htm http://www.rondebruin.nl/mail/add-in.htm Gyula...

Excel: Macro Error, code execution, macro error

code execution, macro error: Sorry, I don t know since I have never seen your code and/or know in what line it crashes. Well, without seeing any code, or at least having further description of the conditions under which the error occurs, it is very difficult to offer any assistance....

Excel: Macro Error in Command Button (Run time error '1004'), run time error, paste application

run time error, paste application, format xls: You may try by explicit the sheet where you want to select the range. For example, change the line: Range( B14 ).Select To: ActiveSheet.Range( B14 ).Select If you find errors further in the code because of the same error, you can safely change those...

Excel: Macro Excel 2007, left hand corner, microsoft guide

left hand corner, microsoft guide, excel workbook: Hi Landi, I know I also ran into this problem converting from 2003 to 2007. One thing I would check is with Excel 2007 you would have to convert it to a specific Macro Enabled Workbook for Macros to perform, not just an Excel Workbook . To do this open...

Excel: Macro with Excel 2007, array array, cross table

array array, cross table, true space: Try putting this at the top of the routine: Sub Afone() On Error Resume Next Application.DIsplayAlerts = False Sheets( Feuil1 ).Delete (and after the line which says Sheets.Add, put in this line): ActiveSheet.Name = Feuil1 Bon Chance...

Excel: Macro in Excel, conditional formatting, bob phillips

conditional formatting, bob phillips, macro in excel: You don t need a macro to do this. You can do this with format= Conditional Formatting after you select the cell you want to change color. Here is a resource for excellent information on conditional formatting Debra Dalgleish http://www.contextures.com/tiptech.html...

Excel: Macro to Execute Add-in, vba code, macro recorder

vba code, macro recorder, buton: Why do you want to attach the add-in? If I understood your question you are having trouble with code you wrote that is accessing/using the add-in and not with the add-in itself. So, send the code you wrote and tell me which add-in your code is trying to...

Excel: Macro for excel indexlettre making, necessary keystrokes, cell a1

necessary keystrokes, cell a1, question thanks: Emiel Rather than writing a macro, I suggest you create a template that has the formulas in it to transfer the data from each of the rows to the first row in the new sheet. The template would already have the required number of sheets or a number that would...

Excel: Macro to extract data from sheet 2 to sheet 1, sheet1, thanks in advance

sheet1, thanks in advance, due date: Sub MoveYinL() On Error Resume Next For Each thing In Sheets( Sheet2 ).Range( L:L ).SpecialCells(xlCellTypeConstants) If thing = Y Then thing.Offset(0, -11).Resize(1, 11).Copy Sheets( Sheet1 ).Range( A65536 ).End(xlUp).Offset(1).PasteSpecial...

Excel: Macro to extract matching data, autofilter, document names

autofilter, document names, o8: Since you have no experience in programming, you can t use a macro. So instead use Data Filter. Example: you have document names in col A and dates in col B. Select a cell within this table and from main menu choose: Data, Filter, AutoFilter. In the date...

Excel: Macro: Find,Cut and Paste, b6, cells

b6, cells: Here is the code: Public Function FindString(ByVal strSearchString As String) With ActiveSheet.Range( A1:A10 ) Set c = .Find(strSearchString, LookIn:=xlValues) If Not c Is Nothing Then ActiveSheet.Cells(c.Row, c.Column...

Excel: Macro: Find,Cut and Paste, b6, cells

b6, cells: you can t cut a row and paste to the next column, but you can cut 255 columns of that row and paste to col B: Sub Zeeshah() for i=1 to [a65536].end(xlup).row if cells(i,1).value= Lat then cells(i,1).resize(1,255).cut cells(i,2) ...

Excel: Macro Function to a list, mail group, time emailing

mail group, time emailing, vba help: Have you tried recording a macro and looking at the code??? If you have absolutely no idea what you re doing, we d be wasting our time emailing each other repeatedly. AllExperts is less than efficient when it comes to file-related correspondence. Send...

Excel: Macro Functionality, microsoft word 2000, mdac version

microsoft word 2000, mdac version, library name: Have him open the file. Hit Alt+F11. Go to Tools-- References (I think?), then he ll have one that s marked MISSING. Have him choose the compatible 2000 one (if you have library name THUSANDSUCH, he ll have it, too, but it ll be 2000 s. Right now it s looking...

Excel: Macro, follow up Adelaide (is he now on vacation?), sheet tab, tab view

sheet tab, tab view, target: Hi there, You can do this: 1. In your summary sheet - right click sheet tab and go View code: copy the code below: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) x = Mid(Target.SubAddress, 1, InStr(1, Target.SubAddress, ! )...

Excel: Macro Help- get data from workbook (*.xls), then move workbook, excel timesheets, excel timesheet

excel timesheets, excel timesheet, type mismatch error: Phil, I would approach it something like this. You can save the open workbook to the OUT directory, then when all done processing, delete all the xls files in the IN directory. You need to get away from selecting and activating things unless absolutely...

Excel: Macro Help, sheet cells, input sheet

sheet cells, input sheet, case project: Josh, A tad bit complicated but this should suffice. Change the sum_sheet_name to the summary sheet. Option Explicit Public Function summarize() Dim sum_sheet_name As String Dim sum_sheet As Excel.Worksheet Dim input_sheet As Excel.Worksheet...

Excel: Macro halts in the middle with no error or reason, dollar values, cursor

dollar values, cursor, array: Try splitting them into two separate routines and then run both MAKING SURE that the cursor is in the place from the first run when you run the second one. You can try substituting Range( A1 ).Activate with Range( A1 ).Subtotal...... in both regardless...

Excel: Macro help, square ruler, control toolbox

square ruler, control toolbox, option buttons: I have created a quick example for you, download it by copying this link into your browser http://www.excel-it.com/workbookdownloads/Controls.zip I don t think you can hide Forms Controls like that. ActiveX controls from the Control ToolBox could...

Excel: Macro help, a21, a11

a21, a11, macros: Sorry, as politely as possible, I don t write macros for people on this site who need one, want one, and/or seem to think I am expected to do so unless they are very short, quick, and simple. Perhaps someone else on this site would. 99% of all macros are...

Excel: Macro help, destination target, target range

destination target, target range, code space: Hi Loren Go to VBA (Alt F11) and paste the following into the code space of the Setup spreadsheet: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Column B With Worksheets( INDEX ) On Error GoTo...

Excel: Macro help, q500, sheet tab

q500, sheet tab, button code: Right click on the sheet tab where the cells are located and select view code. In the resulting sheet module for that worksheet, put in code like this: Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Range adjust the range reference as...

Excel: Macro help, frequent flier miles, index sheet

frequent flier miles, index sheet, vlookup function: Since values for a pt2x6, using that as an example, appear more than once in the index no formula or macro will help you. Either one would need some way of figuring WHICH value for a pt2x6 you would need and how would it know which one? If there is logic...

Excel: Macro help with excel 2003, excel programming, google

excel programming, google, ogilvy: From our other AllExperts Expert, Tom Ogilvey, try this: http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/71b0e38341bb8328/59ba4839d8574971%2359ba4839d8574971 If the above link doesn t hyperlink, please copy it and...

Excel: Macro help please, relative references, random number

relative references, random number, sortem: As long as the formulas are not relative references to other rows in the same cells which are being sorted, this should work fine: Sub SortEm() Columns(1).Insert Range( A1 ).Currentregion.resize(,1).Formula= =RAND() Range( A1 ).CurrentRegion.Sort...

Excel: Macro help, excel sheet, spinners

excel sheet, spinners, spinner: Well, I answered what you asked. There are three different ways you can use/apply spinners and you did not say which way you have used/applied them. Depending on which spinner you have used determines how you go about doing this. Remember, I can...

Excel: Macro to hide blank columns, e excel, loss reserves

e excel, loss reserves, triangles: Do you want the macro to be dynamic and determine the number of columns that need to be hidden or displayed? You do not make that clear. You indicate that the columns that need to be hidden are from AF - IV, the last column, which can be recorded as I...

Excel: Macro to hide and unhide dynamic range of columns, concise solution, hidden columns

concise solution, hidden columns, google: Hello Andrew - thanks for the words of confidence g these worked for me in xl2003. Excel 2007 would require adjustments. These assume there will not be any other hidden columns other than the ones hidden by macro1. Sub Macro1() Set rng = Range(...

Excel: Macro to Import Worksheets from Other Files, master spreadsheet, hi tim

master spreadsheet, hi tim, source directory: Hi TIm Want you want sounds doable I would prefer to work on the code with the acutal sheets other wise we will exchanging dozens of emails. You can mail them to limbic_lesion@hotmail.com Also let me know what the source directory name is so I...

Excel: Macro/Input Boxes, cell b11, input boxes

cell b11, input boxes, allexperts: Tori I am sorry but I don t do VBA but I would think you would need to copy the information in the input box to a new cell that then automatically moves a tag to the next cell so that when you run the macro again it will go into the next cell. I would...

Excel: Macro: InsertRow and FillFormula, master spreadsheet, nature of the beast

master spreadsheet, nature of the beast, insertrow: ...I have a very basic knowledge of programming, so general answers have not been a help to me.... Thus the nature of the beast of macros since they are all written to perform SPECIFIC tasks and why 99% of macros you would find on the web would never...

Excel: Macro to insert blank row at criterion, blank row, excel tips tricks

blank row, excel tips tricks, insertrow: Is anything before the SUB or after the End Sub? send me the file & I ll tell you what s wrong -- bobumlas@yahoo.com I m leading a FREE 1-hour online Webinar on Excel Tips & Tricks on Feb 13, Feb 26, and March 20 from 6-7PM est. If interested, go to http://www.iil.com,...

Excel: Macro for inserting spaces in a telephone number string, number string, do loop

number string, do loop, number changes: Dear Bali... I can help you with the macro but my question is why not do it by a formula. Assuming a number 9892553835 in cell A1, use a formula in cell B1 as =Left(A1,5) & & mid(A1,6,3) & & Right(A1,2) to get 98925 538 35. Copy the formula till...

Excel: Macro for inserting spaces in a telephone number string, number string, program flow

number string, program flow, number changes: You would have to go thru all 5000 rows to have the recorder record a macro to have it then do what you want it to do, which obviously defeat the purpose. The recorder can not record EVERYTHING you would want a macro to ever do - it can not record logic and/or...

Excel: Macro issue want to make sheet protected while running macro, parent cells, budget figures

parent cells, budget figures, rng: Jawad, That is because when you have the If rng Is Nothing Then Exit Sub that gets exexcuted when the D77:D132 is blank and the protect worksheet is not executed The easiest way is to change If rng Is Nothing Then Exit Sub TO If rng Is...

Excel: Macro Loop Cell Replace, rng, ogilvy

rng, ogilvy, cells: Untested, but should get you started. Sub ChangeValues() Dim rng as Range, cell as Range set rng = Range(Range( BA2 ), _ Cells(rows.count, BA ).End(xlup)) for each cell in rng if isnumeric(cell) then if cell.Value 0 then cells(cell.row,...

Excel: Macro for Matching Data in Another Worksheet, cell b1, cell a1

cell b1, cell a1, sheet1: For example, in cell A1 of Sheet1 you have your code (the series of numbers and letters) that exists somewhere in column A of Sheet2. In cell B1 of Sheet1, you could enter the formula: =OFFSET(Sheet2!B$1,MATCH($A1,Sheet2!$A:$A,0)-1,0) which will return...

Excel: Macro needed.... Failry difficult level., blank cells, pivot table

blank cells, pivot table, excel spreadsheet: First of all ... have had great success with you guys before and I plan on supporting your expertice as much as possible like I have in the past... has no bearing on anything. I, like most of the other voluteers I suspect, have nothing to do with this...

Excel: Macro to outline floors of a building, vba macros, rng

vba macros, rng, quick response: Sub AddFloors1() Dim rng As Range, i As Long Dim fl As Long Set rng = Range( B3 ) If Not IsEmpty(rng) Then If Not IsEmpty(rng.Offset(0, 1)) Then If Not IsEmpty(rng.Offset(0, 2)) Then Set rng = Range(rng, rng.End(xlToRight)) Else Set...

Excel: Macro Program, positive reply, reply thanks

positive reply, reply thanks, excel sheet: Is this what you mean? Option Explicit Sub copyData() Dim rToCopy As Range Dim rTargetCl As Range destination sheet two, next empty row Set rTargetCl = sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) With Sheet1 ...

Excel: Macro Program, positive reply, copy worksheets

positive reply, copy worksheets, source sheet: Option Explicit Sub CopyData() Dim sh As Worksheet source sheet Dim sh1 As Worksheet destination sheet Dim rw As Long row for output on sh1 Dim cell As Range cell in column C being checked Dim rng As Range cells in sh with Dates change...

Excel: Is A Macro possible?, pivot tables, pivot table

pivot tables, pivot table, trial balance: 1 and 2 - sounds like the macro should basically go through each sheet, and each row - IF the cell with the balance is zero, you do entirerow.clearcontents (which deletes the values, but leaves the row intact (if this isn t what you meant I ll have to re-think!)...

Excel: Macro problem: PasteSpecial, run time error, run time error 1004

run time error, run time error 1004, alexander hill: Yes, it is more clear. There is nothing wrong with the code. The clipboard is getting cleared somehow between running the first and second macros. You can check this by looking at the Paste icon on the toolbar. If it is dimmed out, or disabled, before...

Excel: Macro Question, waterfall 1, copy windows

waterfall 1, copy windows, cell reference: I assume that it is in Sheet1 Dim What_To_Find As Variant Windows( test Schedule.xls ).Activate What_To_Find = Sheets( Sheet1 ).Range( A1 ) Selection.Copy Windows( Waterfall 1.xls ).Activate Cells.Find(What:=What_To_Find, After:=ActiveCell,...

Excel: Macro Question/Pivot Tables, tom mccann, pivottables

tom mccann, pivottables, vba code: Example: On your active sheet, you have PivotTable1, with a field named month, and you want a macro to select the checkboxes for the months of Feb and Mar . The vba code is: Sub Macro1() With ActiveSheet.PivotTables( PivotTable1 ).PivotFields(...

Excel: Macro Question, vlookup formula, money range

vlookup formula, money range, macro recorder: Create a table to translate dollar amounts into the levels you want to report at. Example: In range A1:A4, put the values 0, 50000, 100000, and 150000. In range B1:B4, put the text Under $50k , $50k to $100k , $100k to $150k , and Over $150k . So now...

Excel: Macro Questions, crtl, h23

crtl, h23, key run: For the both question, yes. For the first, you don t need a button but you can have one. A button-less solution is to assign a special hot key, like Crtl d, to run the macro below, which puts the date and time in whatever cell you have the cursor in...

Excel: Macro question... read all sheets then write, leters, msgbox

leters, msgbox, a6: This is a simple macro that can give you some ideas. It takes the number defined in it (you can change this to fit your needs), check the column B in row that is 5 rows below the number (the layout that you have explained), and if it is empty, it copies the...

Excel: Macro question, apple orange, dim arr

apple orange, dim arr, blank row: Select C1:D1 and ctrl/shift/enter =Mode2(A1:A5) As it stands now, in case of a tie this would return the first maximum found. Mode2 is: Function Mode2(rg As Range) As Variant Dim arr() As String, First As Boolean, ct() As Integer First = True...

Excel: Macro that can put RED FILLS between all YELLOW FILLS, c range, science project

c range, science project, b2: Shaan, [ change: I changed the location of the initialization of the bYel variable to work with the loop you have] I typed in data to match what you have shown in your image/png and this produced the results you describe/show there: Sub YELLOWFILL()...

Excel: Macro Recorder, abc def, blank worksheet

abc def, blank worksheet, macro recorder: A macro solution is OK and if it works then great. The recorded will not does not record the actual macro you would have really wanted because it can not record logic - it only records mechanics. A loop is what your macro should really do since it repeats...

Excel: Macro to Run Custom Autofilter, column headings, macro recorder

column headings, macro recorder, fhg: Consider using Data, Filter, Advanced Filter instead if you still want to use a macro. And, understand this is just only one way of doing this. After you set up a criteria range and output range (if needed) then create two drop downs and let them feed...

Excel: Macro to Run Custom Autofilter, range f1, column headings

range f1, column headings, autofilter: Ian, Yes this is possible. In my sample worksheet, I had Salesperson in Col A, Client in Col B and Meeting Date in Col C. The macro below applied the autofilter based on the date range entered in F1 (Start Date) and H1 (End Date). XF Sub Ian() ...

Excel: Macro to Run Only If A Cell is Clicked, target address, cell a1

target address, cell a1, thr: Please only one question per post. I so this in my own free time so please consider that in thr future. To have code run automatically when a specic cell in a specific cell is selected then use Private Sub Worksheet_SelectionChange(ByVal Target As...

Excel: A Macro that recognizes where a file and updates itself, string fname, documents and settings

string fname, documents and settings, b19: Yes. This is all you need. Dim Current_Folder As String Dim newFile As String Current_Folder = ActiveWorkbook.Path & newFile = Range( B19 ).Value ActiveWorkbook.SaveAs Filename:=Current_Folder & newFile fName = Range( B19 ).Value newFile...

Excel: Macro related to collect data from other workbooks, macros, free time

macros, free time: Yes, you will need to write a macro. And, sorry, as politely as possible, I don t write macros for people on this site who need one, want one, and/or seem to think I am expected to write one UNLESS they are very short, quick, and simple. Perhaps someone...

Excel: Macro related, bar application, sheet tab

bar application, sheet tab, target: Right-mouse click the excel LOGO near the file menu, select View Code, paste this in: Dim Was As Variant Private Sub Workbook_Open() Was = ActiveCell.Value End Sub Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)...

Excel: Macro to remind saving, grammar errors, adavance

grammar errors, adavance, dear bill: It can t be done like you would like. The macro I think you are thinking of would have to be in EVERY document the user has either created or opened. EXCEL always prompts you now anyhow, before exiting and/or closing that file, if you want to save the file....

Excel: Macro to remove unwanted rows, macro script, sql program

macro script, sql program, dotted lines: Because I can help with macros THAT HAVE ALREADY BEEN WRITTEN. It does not say I will write macros. It also says, as you quoted, most all queations , not ALL questions. If you are unhappy with me and/or the way I phrase my profile then I d suggest that...

Excel: Macro to replicate IRM, hi tim, question thanks

hi tim, question thanks, key logger: Hi Tim A closed file can be copied at any time presumably by anyone who can log on to a machine. Given this fact VBA may not be running therefore no event could be captured( as far as I know anyways). It is possible to log and prevent copy actions...

Excel: Macro to round a figure (%), allexperts, thanks in advance

allexperts, thanks in advance, xavier: Hi Xavier, I have to apologize, I received an email from AllExperts saying that I did not answer this question yet. I thought I had, I m sorry! Here is my answer: Public Sub roundnum() For Each cell In Selection If cell.Value -2 And cell.Value...

Excel: Macro to run in Access, macro in excel, mydatabase

macro in excel, mydatabase, application object: Try this. Sorry for the delay Sub EXCEL_Access Get a reference to the Access Application object. Set appAccess = CreateObject( Access.Application ) Open your db. Modify the path as needed. appAccess.OpenCurrentDatabase Mydatabase.mdb...

Excel: Get Macro to run when a cell changes, target address, cell a1

target address, cell a1, combo boxes: Hi Mark, I ll give you a general example and you can change it to fit your situation. To run a macro named RunThis when cell A1 is changed: -Right Click on the sheet tab and choose view code. -The Visual Basic Editor will open and two combo boxes...

Excel: Macro run when cell is clicked, target range, de bruin

target range, de bruin, mscal: Hello Kim, My code shows how to trigger another macro when the activecell is within a specified list of cells. This is partially want, but Ron de Bruin gives you a complete solution identical to what you describe: Ron de Bruins code http://www.rondebruin.nl/calendar.htm...

Excel: Macro Security, macro security, medium security

macro security, medium security, security settings: Not necessarily so. Check Tools Options for XP and make sure they are set they way you want and the are the way your old version of EXCEL was setup. Individual workbooks do not control, set, or change the macro security settings - that is a global EXCEL...

Excel: Macro SHortcut Key, paste application, keyboard shortcut

paste application, keyboard shortcut, false application: Your impression is correct and it makes no sense to me either. I would suggest moving the workbooks.open code up to the top instead of being at the place in the code right before it is needed. You can just swtich between the two when need be. Don t know...

Excel: Macro Shortcut Key, shortcut key, f8 key

shortcut key, f8 key, excel 2002: Try putting this in as your very first line in the macro: Stop then press the F8 key over & over & see where it s stopping. If it doesn t even get to the Stop, then Shift/Ctrl/U is bsing used to run some other macro! If all else fails, feel free to email...

Excel: Macro Shortcut Problem/Solution, keyboard shortcut, problem solution

keyboard shortcut, problem solution, excel 2002: You didn t bother me - I just did not know what you were asking since I saw no question. You seemed to ask a question and also offeer a solution in the same post. And perhaps you have confused me with someone else and I am confused myself. No others...

Excel: Make a Macro/Spreadsheet Expire, fool proof, time kind

fool proof, time kind, macros: Change the date to whatever you want it to be and make sure you put this code in the right place - I assume you will know how to do that based on its name. Also, to help the expiration scheme I would put the code at the end of this post at the beginning of...

Excel: Macro that saves file as what is displayed in cell., invoicing system, invoice number

invoicing system, invoice number, mystuff: ...Ultimately I would like to be able to combine in with another macro.... Well, ummm, OK. That s good to know, I guess. Change C:MyStuff to the folder where you want to save the file. I thought you knew that. And since you did not specify where...

Excel: Macro to search a column and, upon a positive result, will cut corresponding row to new w/s, m1, proposals

m1, proposals: Try the one below. You may need to modify as per the needs... Sub Remove() Application.ScreenUpdating = False Worksheets( Remove ).Select Counting number of expired proposals already entered myExpired = Application.WorksheetFunction.CountA(Range( m:m...

Excel: Macro to search a column and, upon a positive result, will cut corresponding row to new w/s, sheet names, description change

sheet names, description change, sh1: Option Explicit Sub RemoveData() Dim sh1 As Worksheet Dim sh As Worksheet Dim rng As Range, rng2 As Range Dim dest As Range, cell As Range Set sh1 = Worksheets( Remove ) For Each sh In Worksheets( _ Array( Sheet1 , Hardware , sheet3 )) Set rng...

Excel: Macro to self-destruct spreadsheet, macros in excel, creating macros in excel

macros in excel, creating macros in excel, blank document: ...Is there a macro available that can run upon opening that will check the system date.... No, you will have to write that yourself but EXCEL does provide ways to hep you do that. You use the Workbook_Open event. However, though your logic is good,...

Excel: Macro to setup multiple tabs within single workbook, cell a1, chris answer

cell a1, chris answer, code excel: Chris, I need to have some more details. (1) Do you mean data on Sheet 2 will keep changing? (2) I understand scenario as below. Please confirm. (a) Let us call List of sheets to be added as Chris1 to Chrisx (b) You have data in Sheet 2 (c) You run the...

Excel: Macro for sorting Column B for multiple range of cells in Column A, erow, srow

erow, srow, b47: Hi Rajiv, Give this macro a try. I believe it does what you describe. Sub SortSameAcol() Sorts on column B for rows having same non-empty value in A Dim sRow As Long start row of same-A col value range Dim eRow As Long ...

Excel: Macro to start MS Word, ms word document, boilerplate text

ms word document, boilerplate text, spreadsheet functions: You will need to write a macro to make EXCEL open WORD, then open the WORD doc, insert the desired values, then print and close WORD. EXCEL can do this but I do not write macros for people on this site - I only help people who have questions about macros...

Excel: Macro Toolbox, using microsoft office, microsoft office 2003

using microsoft office, microsoft office 2003, default toolbar: Judith The macro toolbar and the record button should only be reflected on the major toolbar if you change you major toolbar, so when you reloaded it must have gone back to the default toolbar. If you cannot find the visual basic toolbar (go to toolbar/view/toolbars/visual...

Excel: Macro, type mismatch, run time error 13

type mismatch, run time error 13, error value: Possibly NOTHING different - the macro as it stands will fall over IF a cell has an error value (eg division by zero) in it as far as I can tell - so the removal of this error would remove the error in the macro - so the error trap statement MIGHT be a good...

Excel: Macro to make things quicker, spreadsheet columns, blank cells

spreadsheet columns, blank cells, sick days: First of all, I do not write macros for people on this site who either need me to do so for them, sometimes seem to get the idea that I am expected to do so, and/or ask me to do so. I answer questions on my own free time and since writing macros for someone...

Excel: Macro for Unique Pairs and Sums, red apple, apple 2

red apple, apple 2, apple red: I guess I am missing something CAM - the answer did exactly what you asked: I need to populate a new worksheet with unique combinations of column 1 and column 9 and then sum the values of column 7 that correspond with the unique pairings The answer does...

Excel: Macro to update a spreadsheet, doctor database, sheet1

doctor database, sheet1, rng: select the column or range of cells you want to search. Do Ctrl+F the find dialog box appears. Enter in the value you want to search for and select any search options you want. then click OK. That is how you use ctrl+F. If you are trying to...

Excel: Macro to update a spreadsheet, continuous block, cell references

continuous block, cell references, paste code: Yes, no problem - BASICALLY the macro needs to make the value of the cells that need updating equal to the component parts, and then clear the rest of the cells - you can record the action of clearing cells (just select them either one at a time and hit delete,...

Excel: Macro using relative references, project abc, relative reference

project abc, relative reference, relative references: Bob I believe a macro can be written to do exactly what you need and I believe that you are taking the correct approach. Unfortunately I am not a macro expert, and I don t know the code for telling excel to copy until it sees the next total. I suggest...

Excel: Macro/VB Programming, master spreadsheet, spreadsheet column

master spreadsheet, spreadsheet column, column headings: What you re asking is not an Allexperts-type question, but a mini-consulting job! I can do it, but I m pretty busy at my regular job to dedicate the amount of time required. Basically, you d have to have the macro ask the user which column of the slave sheet(s)...

Excel: Macro / VBA routine, computer literacy, lawrie

computer literacy, lawrie, addressee: Hi Bill, I cannot answer for MS Word directly (my expertise is Excel); but the following works in Excel: ActiveWorkbook.SendMail addressee@wherever.com , Subject Line It can probably be adapted for Word. The User is presented with a warning...

Excel: Macro - Workbook Resident, xls workbook, share drive

xls workbook, share drive, password access: Macros CAN reside in the active workbook and they can also reside in the Personal.xls workbook. In your case, it sounds as if the former is true. And since I can not and have not seen the code then it is impossible for me to tell why the macro behaves...

Excel: Macro won't update territory numbers, case calculation, value application

case calculation, value application, rng: Sub PrintReports() Dim rng as Range Dim cell as Range set rng = Worksheets( Data1 ).Range( A1:A50 ) for each cell in rng Worksheets( Report1 ).Range( A1 ).Value = cell.Value Application.Calculate Worksheets( Report1 ).Printout End with Next...

Excel: Macro writing, column c, cells

column c, cells, dictionary: I am not sure how column C affects the process, following the explanation and the example I couldn t figure out how to include it on the calculations. This is a macro that does the output, but not in the order that you have it there (is that what column C...

Excel: Macro writing, cell a1, merchant number

cell a1, merchant number, macro code: Jason I m not a real macro expert, so I m not a good one to give advice on your question. However I was wondering if there isn t a way to use a simple link between the worksheets and the worksheet you are pulling to, such as, in sheet1 the formula =+Sheet2!A1,...

Excel: Macro, column letter, cell interior

column letter, cell interior, dups: Sue, Try this routine below. Subsitute the actual column letter for the A in the For Each line. Sub SueX() For Each cell In Range(Range( A65536 ).End(xlUp), A1 ) If cell.Interior.ColorIndex = 8 Then cell.Offset(0, 1).Value = x ...

Excel: Macros, microsoft excel 98 macintosh edition, microsoft excel 97

microsoft excel 98 macintosh edition, microsoft excel 97, run time error: I m afraid you ve got me beat then! The only topics shown on the microsoft knowledge base about this are Mac related. It s POSSIBLE the other PC hasn t got an up to date ODBC driver. It s also possible that you have used a mapping to (say) g drive as a...

Excel: Macros, vlookup function, cathy thomas

vlookup function, cathy thomas, macro button: I am tempted to answer just yes since that would be the answer to your question. But, I will provide more. I still don t know how your macro does what it does - all I know is what it does. But, you don t need to macroize this function. Simply type...

Excel: Macros, sorry for the confusion, individual department

sorry for the confusion, individual department, machine time: Well, considering I am doing this on my own free time then I will need TOO much info to be able to do it on my own free time. I am sure you can understand how the seemingly little things can get quite large and time consuming rather quickly. Sorr...

Excel: Macros, first hope, excel97

first hope, excel97, cell a1: Kwong I think the following code will do as you specify. Please use it on a trial set of data first to make sure it does fit the need. I would hate to see you mess up your data. Here s the code: Sub AECopy() Range( A1 ).Select Do Until ActiveCell.Value...

Excel: Macros, cells, a1

cells, a1, logic: You will need to use some type of loop, For Each, For Next, Do While, etc and check the applicable cells in each row for what you are looking for and then delete that row. Since I don t know what you are looking for in those cells then I can not help with...

Excel: Macros, consecutive rows, excel 2002

consecutive rows, excel 2002, d11: Well, ummmmm, OK. So, what s your question? And, I am very confused. The first row you mention (from B9 to U9 is NOT in one column, that range covers 20 columns). The next two rows you mention also span more than one column also. Please clarif...

Excel: Macros, roy cox, rng

roy cox, rng, datetime: Use the SpecialCells method (look at this in VBA Help) --------------------------------------------------------------------------------------- Module : Module1 DateTime : 12/09/2006 19:43 Author : Roy Cox (royUK) Website : www.excel-it.com]...

Excel: Macros, excel macros, strange one

excel macros, strange one, temporary file: When Excel saves a workbook, it first saves it with this sort of name, and if the save is successful it deletes the original & renames this oddly named temporary file with the correct name. If you crash during the save process anytime, this strange one is...

Excel: Macros, good afternoon, vbe

good afternoon, vbe, spreadsheet: The macro needs to be written, then you can assign a button or an object to run it. In the VBE (Alt/F11), use Insert/Module, and type/copy this in (I m assuming all you want this button to do is print the active sheet): Sub PrintActive() Activesheet.Printout...