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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top