row change

  1. T

    Solver VBA - Changing variables in column

    Hi, looking for some help with this Solver VBA. Here's what I'm trying to do: 1) "Set Objective" is equal to the value in cell D3 2) "Value of" is equal to the value in cell D1 3) "By Changing Variable Cells" - this range in column D (starts on D4) changes according to the number of rows in...
  2. V

    copy and Paste cells x times

    hi i i need to copy cells A1:C10, and paste them X times. The X is in the cell D1, also in the cell A1 i have a formula =IF('C:\Users\..\..\\E kompletuar\[data.xlsx]data'!$H$2=0;"") I need the Cell row $H$2 to change by the number of times the cells A1:C10 is pasted. eg. $H$3 (if i paste for...
  3. K

    Function to alter row height automatically

    I regularly have to manually review large volumes of excel data, one column being the date by which the data is ordered. For visual convenience, every time the month changes (e.g. from August to September), I increase the row height so as to visually group the data. The data is provided by...
  4. E

    Formulas in loops

    Dear All, After a lot of effort (I am a brand new in VBA) I have managed to create a macro to do the following: 1. Copy time vs. Volume data (with variable lengths). A18:B18 2. Calculate deltaT and deltaVolume. (A19:B19). 3. For a constant DR located in cell C6 in the same w/s the following is...
  5. E

    Excel 2013 copy consecutive cells to non-consecutive cells

    Need help... I have two worksheets, sheet1 contains a column of consecutive entries in A1:A20 and sheet2 has 20 groups of data in 13x13 grids with a grid label in the upper left portion of each grid. Grid 1 fills A1:M13, grid 2 fills A14:M26, etc. The grid label is in A1,A14,A27, etc. I am...
  6. S

    concatenate, shift columns, cleanup! Please offer advice!

    Hello Gurus Have an excel listing of prospective clients done by another company, so I cannot ask for a new file. All data (name, address, city/state/zip, phone, email & website) are done for each store in rows, one after the other. Then that's repeated in 3 columns, essentially a customer 1...
  7. A

    Protecting a Worksheet

    Is there any way to protect a set of columns in a worksheet and still allow users to add rows or cut and paste rows without un-protecting those cells first? I have a form that needs to be used by several departments and everyone is worried about the other messing up their work, but the document...
  8. L

    Moving cells around in a worksheet

    I have a worksheet with the word "Provider:" in column C that appears in ramdon rows. I need to move the contains of the cell in column D that follows the word "Provider:" in column C. I need to move it column B and down one row. Appreciate any assistance!
  9. R

    Slow macro wasting time

    I'm trying to run code to color in some cells in a row based on the value they contain. The following code works but it takes too much time to recalculate all 106,500 cells every time you change a value. I need to have it run through a worksheet change event. Is there anyway to have it only...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top