copy & paste formula.

I have a workbook that contains about 100 worksheets that house data I need to combine into one master file. Each of the worksheets are formatted the same with the data contained in the same column(s)/row(s). I need to take the info and create a row of information for each client. The Data...

Hey Guys, I am inserting the formula but having trouble getting it to copy down. I want it to copy down to the last row of column AA to account for variable data. Sub Insert_QueryTitle_Formula() Range("AA1").Formula =...

Hi All, First post on the site so please bare with :) Im creating a document which is going to be forecasting sales for different products and to save time and not have to manually copy and paste i would like to know if its possible if a macro/vba code could achieve this obviously i don't wan...

Hi, I want to copy a formula down a columns to about 200 cells. This is the formula; =IFERROR(VLOOKUP(I5,A5:C330,2,0),0) The only thing that should change is the row for I. So it should look like this =IFERROR(VLOOKUP(I5,A5:C330,2,0),0) =IFERROR(VLOOKUP(I6,A5:C330,2,0),0)...

Good day! I am an average excel user, i only know the basics and I have no knowledge on Macro or VB. But I really wanna shorten the time I complete my monitoring worksheet. Basically, I have a tab where i source all my formula from another tab. On this tab which contains all the formula, I...

Hello, I have this formula that works fine: =IFERROR((INDIRECT($A2&"!C30")),"") I need the column in the "C30" reference to change as I copy and paste it to the left or the right (ie. B30, D30) I'm guessing I need to use the "column" function in there but I can't figure it out. Any help...

Hello all, I am trying to write a macro and I want it to do the following: If the value in column A is empty, then copy value in G+1 column, (+ 1 meaning but one row below) and paste it to G+2. Do this for all the empty value in A column. After that delete all the empty rows. Thank you for...

Hi Team, Looking to know if there is an easier way to copy down a formula through 100K+ of rows without causing excel to give up and die quietly. For example I am using this formula =IF(COUNTIF($Q$2:$170621,Q170621)>1,"Y","N") Any help will be greatly appreciated as I have a bit doing this...

Hi All, I have a worksheet that has data in 52 rows (starting at row 2) and 4 columns (A, B, C, and D). Currently column A is unique to itself, and Columns B, C, D go together. Excluding headers, each column has the following number of cells with data: Column A has 52 cells Column B has 40...

What I want to do: I have headings in cells B1 to BJ1 which I have copy - paste special - transposed on sheet 2 in cell A2 to A61 . In sheet 1 I have skills from cell A2 to A49 which I have copy - paste special - transpose on sheet 2 in cells B1 to AW1. In cell B2 on sheet 2 I want to put the...

Hey all, I need help from you "more experienced guys". My idea is pretty basic, but since I am still rookie I just can´t write it. In my work I do a lot of copying and this would help a lot. In my excel file I have in one column "Material" codes of products with following weeks(variable...

I hope someone can help with what is probably a very simple problem. I am trying to copy formula as follows: <colgroup><col span="3"><col span="2"></colgroup><tbody> 2 3 1 10 =A4*B4*D2 =A4*B4*D3 2 20 =A5*B5*D2 =A5*B5*D3 3 30 =A6*B6*D2 =A6*B6*D3 </tbody> <colgroup><col...

Using Excel 2002. Search cell for URL, copy URL only, and paste to new cell. For example: If A1 contains a URL: A1 = Hi, my name is corzo http://test.com. Then copy URL only to new cell: A2 = http://test.com Thanks kindly in advance.

Hi, I need to go from format "a)" to "b)". This is more complicated than a regular transpose, as you will see: a) <tbody> a1 b1 a2 b2 a3 b3 a4 b4 </tbody> b) <tbody> a1 b1 a2 b2 a3 b3 a4 b4 </tbody> Thank you in advance!! T

I have created a large spreadsheet which breaks out a monthly forecast and within this forecast there are dollar values relating to each of the items on this forecast. In the same row as these dollar values i have assigned a date to each item. I would like to produce a table as seen below which...