help me please

I have been googling for a couple of hours now, and would like some help. I am looking to shorten this code (I have 95 variables): For j = 1 To icolumncountSelect Case Cells(header_row, j) Case NONTEMP(1): ModeNumber = j Case NONTEMP(2): TestNumber = j Case NONTEMP(3): DataNumber = j Case...

Hey guys, This is a sub in word that I call from in Excel. It works perfectly when i step through it but when I run it throws an error when doing the pasteandformat command. Any help would be much appreciated! :) Code : Sub titles() For i = 2 To 10 ActiveDocument.Bookmarks(i).Select...

I'm working on a spreadsheet to calculate production costs for jewelry design. I have 3 sheets corresponding to different components of a finished piece (e.g., chains, findings, charms), with basic math formulas diving the total cost by the total units to calculate the price per unit. There...

Hi, I am trying to automise effort calculations for a project by phase (the columns in the spreadsheet hold days per week per resource type). As the phase can vary in time, I've created a header which indicates the phase. I need "something" :) to look up the header to determine which phase and...

Hi there, I am making a rugby player database system in Microsoft Access 2010. I have a main database table with player information AND parent information all in the same record. This is because I couldn't find a better way of relating the player to parent. The difficulty comes because I have...

Hi Everyone! I want to run a macros automatically on the hour, every hour. Could anyone help with my following problem please? I'm relatively new to VBA and I dont want someone to write a program for me so links to articles (and possibly a li'l bit of VBA code (if necessary)) would be great...

Hi guys, I have some limited excel experience, but need help setting something up for my Mum. It is a record of shares she owns and the dividends they have paid her. I have a workbook with several sheets. each sheet has a table that is a record of an individual stock. Each table has 10...

Hi guys I have un problemo!! im trying to devise a spreadsheet with vlookup basically to calculate the charges of processing someones payroll for them. The price will depend on the number of employees the client will have. These are the price listing rules i have been given...

Hi I am trying to make TicTacToe. I am trying to create a command button that has a set varible of 'nothing', 'X' and 'O'. The buttons need to be activaited by a click. then a counter will be used to swap the turns around between the players that are 'X' and 'O'. Hope people have got...

Right, what I'm attempting to do here is work out the cost incurred to each individual of a number of people who went on a trip. Basically, I paid for everything and now want to split the cost between appropriate people so I made a table (food down the side and people along the top). The...

Im using excel 2007 and I have a worksheet with information in columns A-M. Some of the cells in M have specific dates and I need to know if i can have a formula that will copy and rows that have dates in Column M and place the copied rows into a separate worksheet within the workbook. Also if...

Does Anyone know how to write a formaula that will return the last entry in a Col. to the Total line in a table sort??? :confused::(:warning:

Hi - I'm trying to add some conditional formatting to compare two lists. I've tried the COUNTIF and MATCH functions, but when executed, the formatting applies to the entire list. I am trying to add the conditional formatting onto cells that are populated completely via VLOOKUP and...

So have the basic VBA but its not working. Currently its highlighting the last five lines and saying that its expecting an end of statement. Any help would be greatly appreciated. Thanks :) Sheets("Sheet3").Select ' Select the cell in the upper-left corner of the chart...

Range("A65536").End(xlUp)(1, 2) = txtTitle.Text 'Prints the text in the Title column' This code goes to a text box on a form and it prints whatever I type in the text box directly into the first blank row in the second column. I found this code on this site, but I would like to understand it...

I have this code: For i = 7 To 2000 If Range("L" & i) <= (Date - 365 * (3 * Range("N" & i))) - 182 Then Address = Cells(i, 15) strbody = "Relief Valve number " & Cells(i, 1) & " at " & Cells(i, 2) & blank & Cells(i, 3) & Cells(i, 4) & " needs to be tested"...

<TABLE class=tborder id=post2795179 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2795179 style="BORDER-RIGHT: #ffffff 1px solid">I have this code (see below) that goes thru column L to see if the something is true or not and if it...

Hi all, I have a userform which asks for certain details such as; date, time. but within the form anyone can enter what they like, is there anyway i can get the user form to display eg date dd/mm/yy in the box for people to see as a reference and to set the textbox to only accept values to...

Hello! I'm working on a project and have already learned a lot about Excel's options.. however there's one thing I can't figure out. I'm hyperlinking to a large car rental website that offers services for several cities. However, I want it to automatically link to the city that appears in...

Hi, I have these columns with their respective values: Category | ProductID Apparel | UA-101 Apparel | UA-102 Apparel | LA-101 Apparel | LA-102 Sports | Ten-101 Sports | Ten-102 Sports | Gol-101 Baby | Toy-1 Baby | Toy-2 since UA-101...