cell contents

  1. G

    Create cell name from contents of another cell

    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...
  2. T

    Insert constant number of rows, based on cell value

    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
  3. B

    Create new user form for new entry

    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...
  4. R

    Selecting and formatting range dependendat on cell content in column

    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...
  5. S

    Remove 2nd and 3rd character in a cell?

    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...
  6. S

    VBA to convert cell contents to comments.

    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...
  7. J

    Reference filename based on Cell contents

    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...
  8. L

    Macro to Copy Cell Contents to new Cell Row

    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...
  9. N

    Print cell contents using VBA

    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...
  10. V

    displaying error when a user provided value is not found in the excel

    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...
  11. Ozhatch

    Clear cell contents

    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...
  12. B

    Excel macro, cell contents file name, looping?

    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...
  13. B

    I want to write a macro that searches for the contents of a cell and not what was initially in the cell

    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...
  14. T

    Split cell into two cells

    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...
  15. D

    Formula Referencing Cell Contents Not Value

    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...
  16. S

    Define empty cell in IF-formula not ""

    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...
  17. F

    Search for non value and move contents to a specific cell

    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...
  18. M

    Printing display AND cell contents on the same page

    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...

Some videos you may like

This Week's Hot Topics

Top