copy and paste formula

  1. J

    Copying multiple formulas until last row with VBA

    Hey guys! I'm working on a project where an Excel file is used to as a database. Raw data in worksheet1 is treated in worksheet2 with a bunch of formulas. These values are then copied and pasted into a CSV file to be uploaded into a website. Currently, the database has around 7000 entries...
  2. S

    Macro to copy formulas to newly added row automatically

    How do you auto copy formulas from row above to a newly added row?
  3. L

    Skip X cells when dragging a simple formula

    Hi Lovely all, I'm trying to drag a formula but would like to skip two columns. I have 2 sheets. Sheet 1 with results and the other with column A originals, B actuals, C difference. Sheet 2 has only originals. So if I drag it goes: ='Sheet 1'A2, ='Sheet 1'B2, ='Sheet 1'C2, etc... What I...
  4. D

    Data (text) to be copied and amended to another cell in a different worksheet

    Hello all: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would...
  5. F

    quickly repeating long-winded formula

    please bear with me with this... I'm trying to write a spreadsheet for stocktaking where rows 2-40 have the stock items, column C has the price, and then each subsequent column has a different job I've used the stock for, so I can go down the rows adding how many of which item I've used for...
  6. A

    VLookup: automatic column changes

    Please Help! I am working with a worksheet in which I have a vlookup function that needs to be drag and copied 120 columns across. At each change in column, I need the column index number, in the vlookup function, to increase by one. =vlookup($a1,B:CD,1,false) =vlookup($a1,B:CD,2,false)...
  7. S

    Copy and paste formula to different workbook

    Hello, I have several formulas I am setting up for 20 spreadsheets (Excel 2003). I need to copy multiple formulas from one spreadsheet to another in a different workbook (I am just going this process once for the 20 spreadsheets and then I will not need to edit them). When I select the data...

Some videos you may like

This Week's Hot Topics