copy and paste formula

Dear all, I have some slight knowledge about VBA and writing code. But this has my mind boggled, and probably it is something really stupid. I am trying to copy and paste Format and Formulas, from the row above. By the push of a button. The formulas should be 'dynamic', in the way that any...

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

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

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

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

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

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

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