programming

I have always written my VBA code using absolute cell references. A problem arises when I find it necessary to add a row or column after the program has been finished. The spreadsheet updates but the code behind it does not. This requires much rewriting of the code. There must be a better way...

Hi all! I have a question that is somewhat general, I'm really looking for a starting point, or a thread that can help in more depth. I do consulting work for golf courses - my background is in turf - and as part of my consulting, I often "build" chemical and fertilizer programs for use by...

Does anyone know a good resource for learning the language used in Visual Basic on Excel? I know it's a loaded question since it's a variation of computer programming language - but I am looking for a solid introduction so I can know what I am doing with commands in VBA rather than just...

Dear Brilliant forum I have just received a work related task. I have little knowledge of VBA, however, I told my colleagues that this forum has the best Excel/VBA brains out there. I received a document containing our product sales and an attached macro that sorts these products (and inserts...

I want to do this with only formula, not any scripts. I want to be able to Remove everything BEFORE the LAST occurrence of the a period (and keep the cell blank if there isn't a period present). Ex: This table shows what I need it to do.My current formula handles rows 2-4. However, I need...

Assume you have a mailing list file. this file is currently the active workbook, and the active sheet of this workbook has full names in column A, starting in cell A1, with last name last and everything in uppercase letters (such as Stephen E. Lee). Write a sub that counts the number of names in...

I am stuck. I've created an MS Access db to pull all invoiced and quote dollars for a specific brand from April 2013 to current. My required fields are sales manager and customer name. How do I set a criteria that will aggregate the customer sales dollars greater than or equal to $75K. Then...

I have an excel sheet, and I am trying to bring some sort of automation in to that sheet (since I use it quite often) with the help of macros. The fact is that I am really new to macros and VBA programming language, so I need a little help in writing the code to find the 10th percentile (the...

Hi guys, I've a tricky question here, hoping to get some help. For example; My column A is a drop down list and what I need is when i select an item from the drop list in column A the value in column B will be auto generated. Something like a online registration form. Is this possible?? or...

Greetings, I have been trying to get the following macro to work with my particular requirement and have had no luck thus far. I am a macro novice and any assistance would be greatly appreciated. I am trying to insert a picture in a weight tracking spreadsheet based on the value of another cell...

I am working on a project with baseball data from retrosheet.org. I want to create variables for the score of each team in each inning (VisInning1, HomeInning1, VisInning2, HomeInning2, etc). The problem is that the variable for the box score is coded strangely. Each team has its own variable...

I am trying to come up with a program to impliment the secant method in Excel VBA. I have tried multiple ways of doing this. If statements, for-next, and do while loops. I believe the do while loops was the closest I got to completing it. For the program someone should be able to enter two...

Guys, Apologies if this has been up somewhere before, I did try the search but you never know which wordds someone else might use... What I am wondering, is, as an Excel indermediate, what kind of other programming language would let me make tiny little stand alone applications to perform...

I want to write a code that will copy a worksheet (Sheet2) x number of times and copy a differebt row of data from Sheet1 to each new copy. For example: If I have data in rows 2 - 4 of Sheet1 I would want to copy Sheet2 three times and copy row 2 (Sheet1) to the first copy, copy row 3...

Does anyone know of a discussion board like this one, but that specializes in Microsoft Word/VBA programming?

Hello all, I don't have any experience with the macros programming however I have managed to create the following programme with the help found from older posts here: I have a spreadsheet with fields for writing down daily expenses so at one of the months (specific worksheet) I want a msgbox...

I am making a calendar for work. We are a flooring company that contracts through a large nationwide home store. The calendar I am making will go in these stores so that the personnel will be able to set up measure dates with the customers while they are in the store (rather than us calling...

Hello, I appreciate any help I can get with creating a macro. Each month I musty reformat and work with data from different workbooks, I would like to create a macro to do some of the formatting changes however each month there is a different number of rows and columns. I would like to know...

I have a list of Clients with ID NO'S and Location. I need to segregate those in different worksheets under A, B, C according to the Location. The ID No and Name should appear in the respective worksheets. Whenver the master list is amended or added the change should effect in the respective...

Hi There, I have set up a really simple UserForm in VBA that populates a worksheet that is made up of 4 columns - I've included the code below: <a href="http://www.flickr.com/photos/67298551@N07/6165759057/" title="Table by digiteers, on Flickr"><img...