cell contents

I'm looking for a way to create cell names dynamically. I can find more complex answers to more complex questions, but not this one. For example: I'm trying to name cell B1 based on the contents of cell A1. And so on: the name of each cell in column B is the contents of each cell immediately to...

Hi all, I'm trying to figure out a way to insert 4 rows, based on the value cells in a specific 1-column range. For example, for all cells in column C which equal "I need help", insert 4 rows below. Any help would be much appreciated. Thanks!!! Tony

In a nutshell Work Book; "Client Services Analysis" As a new name is put in a column B: and there is a value in column J Open a form Add the name in Column B to a specific cell Copy the form and rename it based on the contents of cell in column J Put it in another directory and maintain...

Afternoon, I'm sure this is simple, but I can't get my head round it. I have a workbook that aggregates 3 separate worksheets onto a 'summary' sheet then sorts it into weekday order. Private Sub Worksheet_Activate() Application.ScreenUpdating = False Range("A9:G4000").Select...

Hello, I thought this would be quite simple to do, but so far have not found a solution. I would like to take a value in a cell and remove the second and third characters in that cell. For example: "V0010" would become "V10." I've found formulas for removing the beginning and ending...

Hi All I have a sheet that counts the number of people that fulfil requirements on another sheet and displays the number. i.e. it counts students who have a target grade of B, who have achieved a C and are in class 10r1. The sheet containing the data is called 'data' the target is in column D...

Hello all, I have found a number of threads on this subject, but all point towards using '=indirect()' or a macro. The problem with the indirect function is that I cannot consistently have the referenced file open, hence a #REF error. I also do not want to use a macro due to the volatility of...

I've seen several threads here for this function but haven't been able to successfully modify those codes to work in my situation. I have a form I created on Spreadsheet1 I named M635Frm used to enter data that will stored in a database format on SpreadSheet2 (Named M635Db). I viewd a couple...

Hi All I am trying to make a seat booking form for a school, who currently hand write all the tickets sold. I have in say A1 a list box showing the price of the ticket bought In B1 I have a space to put the name of the person buying the ticket and In C1 I wanted to put in a commandbutton that...

Hi, I'm having a userform where user will enter a query number to search in a list of 1000 queries.. Query number is alpha numeric & a unique number (eg. L01Q001, L01Q002, L02Q003) the lot number(L01,L02,L03,L04) repeats at times but the query id Q001, Q002 number is continues number and do not...

I have a spreadsheet (Excel 2003) which I want to distribute to the members of a group. There is a requirement to clear the contents of a range of cells (I15:Q29) at the end of each year. For security purposes, many of the cells in that range are locked, but do not contain any data. The sheet...

Hello, I’m not certain how to word this, but here is my attempt: I have a template in an excel worksheet that needs to be saved using a thousand plus plan names which are listed in another excel sheet under column c. basically i want to run a macro that will pull the name out of column c (on...

To make myself slightly clearer. I need to write a macro that will find the contents of a cell. For example in cell B3 is the word straw, I need to copy cell B3 and paste it into the find function and find all words with straw in. Now this works fine, but when I change the word in B3 to...

I tried looking in the forum and could not find anything that may assist me. I have a cell (C) which may contain: <TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0 x:str><COLGROUP><COL style="WIDTH: 329pt; mso-width-source: userset...

Goal:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> To determine the value of a potential client based on given variables, the farther along in the sales phase, the greater percentage of the value remains. <o:p></o:p> Variables:<o:p></o:p> Sales Phase...

I find different threads on MR. Excel about empty cells that are not really treated by excel as being empty. As soon as I use "" in a formula, Excel will still recognise this as a populated cell. Since they seem to be 'older' discussions, I kind of hope that Microsoft has found a solution for...

Thanks in advance for any suggestions! <o:p> </o:p> I have information in column B which is a list of account codes and names, with a sub-total name below the names, eg. 106432 Salaries (B3) 106772 Benefits (B4) 106882 Leave...

Hi, I am a teacher using Excel 2003. In order to check student work, I have them print the "original" copy which shows the normal display of the spreadsheet. I also have them print the cell contents copy (CTRL + ~) so I can check their formulas. Is there a way to get both copies to print on...