There are about 200 rows with values, I need to copy the numbers frow row 1 that are 75,36 -6,73 30,74 ,then in row 5 they are 69,44 -8,28 36,3...etc.
So the point is I have to copy every 4-th row with values in a nearby column. Of course I've tried the Ctrl + left click for every 4 rows then copy/paste it, but I was wandering is there a faster way??
In the attached spreadsheet, I am trying to drag the formula from one column to the next but I need the same cells to be used in every column with the exception of one cell. For instance, the formula I want to use is in the cell highlighted yellow. In the next cell over (highlighted blue) I want the formula to use the same D and E cells with the only change being the first part of each (G). Both the blue and yellow cell represent what I want to do. For example, the next column (H) would have (H4+D4+E4) in the first part. Column I would have (I4+D4+E4), and so on.
The D and E columns will be in every equation for each column. The problem is that excel wants to use the next column over instead of keeping D and E in each. How do I drag these equations so that it just changes the first part and keeps the D and E columns the same?
What VBA code will copy column A in Sheet 1 to column B in Sheet 3? The range of column A to be copied begins in row 2 and varies in length. Column A ends right before the last nonblank cell.
I want the row in one worksheet to contain the data in the column of another worksheet. For example, Column C in the "Agency" worksheet contains the acronyms for 57 agencies. I want populate ROW 3 in the "Child" worksheet with those acronyms without having to enter a unique "='AGENCY'!C..." formula in each cell of Row 3. How can I do this?
At the moment I have data in column A that I would like to move over to columns B, C, D, E, F, G and H. I need to do it for the whole sheet (60,000 rows), but the data isn't evenly spaced so I'm making a bit of a mess trying.
Here are a couple of examples of what I am trying to do.
Example 1: Data on the left Example 2: How I want the spreadhsheet to look Example 3: What happens when I copy and paste the row 3 columns b-H
I've been messing around with formulas like: if column A = the word CD, put the contents of the cell in this cell. I'm not that clever though! I know it can be done and it's annoying me not being able to do it.
every month a create two different spreadshets and I'm tyring to figure out what is the easiest or the best way to transfer the date from the sample2.xls to Sample1.xls (samples attached). Probably is an easy solution but haven't been able to find a solution on my own so I decided to ask for your expert opinion.
The data columns in both the workbooks are of same length,I just want to copy the corresponding columns from source to destination as per above referenced cells.
I am using a macro to copy a variable column of data from one file column A:4to another but what I want to do is copy the column apart from the last 2 cells. I am using:
I have a sheet which has multiple columns, i want copy the data from column Q to Column H depending on the filter that i'm using on column D. Below is the code, what am i doing wrong here
I'd like the following code to do is to go through each worksheet in the workbook and copy the value of the formula in cell S2 down the S column to the last row based off of a count of rows in column B. It's not working quite right and was hoping someone would be willing to correct it.
I have finished a subroutine that allows me to press a button to run Macro1 that will open a dialogue box to select FileB (that contains data I want to import). Right now, it will import that data (always B4:B20) from Workbook1 and insert it into Workbook2.
I would like to adjust this macro so that each time it is run the imported data won't replace into one column but instead be inserted into the next empty column. i.e. Right now the first run places it into B4:B20 in Workbook 2, and I want the 2nd, 3rd, etc times it's run to place the data in column C, then D, etc.
This is what I have so far, but it only does it for the first piece of data. I want all 16 entries.
I have a cell "A1" that changes values. Every time "A1" gets a new value I want to copy it the the cell below the last value in Column "B". Assume "B1" contains a column name.
I want to copy A1 to B2, then copy A2 to B3 when A1 gets a new value.
Then I want to copy A1 to B3 when A1 gets another new value and so on.
The requirement is Copying a col. B value when the criteria that there is value 'NO' in column C or D. The value of col.B should be pasted into another excel workbook called 'Deliver_Error Log'.
I have pasted the Sample checklist and the Deliver_Error Log. Sample checklist.xlsx and Delivery_Error Log.xlsx
Condition 1: Example in the Sample checklist row. 8, 9, 10 & 12 have value No in either of the column C or D hence the value in col. B of row 8, 9, 10 & 12 must be pasted as 4 new available next row items into the Deliver_Error log into col. L (Error subcategory ) i.e Sample Checklist ,row 8,value col.B = next available row of Delivery Log with col.L (Error subcategory )as Col.B (Q-Checker CheckList) and it must also automatically fill the Delivery_Error Log col.B(Data type) as "Error" and copy the Object Name (value in C2 of sample checklist) into col.E (Object name in log).
Condition 2: If all the values in the checklist are Yes in Column C and D then Copy the Object Name (value in C2 of sample checklist) into col.E (Object name in log) and set Date type as Delivery
Condition 3: If value in checklist is blank or NA take no action.
There will be one Deliver_Error log but multiple checklist of different Object names.
Why my code is not working. When I choose a single column it works. Once I select more than one column it doesn't work. It something to do with my "column1:column2" reference.
I want to copy a D1-C1 formula all the way down column E. If I don't have any data in column D1 and C1, however, I don't want anything to appear in Column E.
Is there a way to hide the formula once I have built it for the all of Column E? The reason I need this to happen is because I can't have any zeros popping up in Column E, because I am calculating a running average of Column E and "zero" values would throw off my average.
How do you make a formula continue all the way down a column, so i haven't got to drag or copy it down all the time?
Lets say I have a formula in row Z, which is =SUM(A1:T1) If I want that formual to be in every cell of row Z, I would have to copy it down. However, if I do that, the spreadsheet becomes huge. I just want that formula (in fact my formula is much more complicated) to always be in row Z, for evermore, as the spreadsheet in time will have more and more rows in it.
I have an Excel file where there are multiple people's information on one sheet, and I have to split them out into multiple sheets. So I have written a loop to successfully do that.
However, I need all the sheets to have the same column widths as the original sheet. So after I insert a new sheet and cut and paste the appropriate data, I call another Sub Procedure from my main Procedure to do this. That Sub Procedure looks like this:
Sub MySetColumnWidth() ' Copy the column width for the first 30 columns Dim i As Integer
For i = 1 To 30 ColumnS(i).ColumnWidth = Sheets("Sheet1").ColumnS(i).Width Next i
End Sub However, I am not getting the results I expect. The column widths change, but are not the right sizes, and I have no idea why.
One odd thing I have notice, is that is mind code, whenever I type in: Columns(i) VBA automatically changes it to ColumnS(i) I have no idea why. I have no code or variables named "ColumnS". I am not sure if this is somehow playing into my problems...
I have written a code for a cell in excel but it only works for the row it is on. I want to copy this code down the column (until reaching an empty row) will cells refernced in the code changing accordingly (just as if i had written the code in the cell and dragged it down a column). A sample of the code I have written is given below.
Private Sub Worksheet_Change(ByVal Target As Range)
I have 2 columns of data E and F. Column E has 11 different words that randomly repeat, Column F has 10 years of dates, about 1,000 entries (10/11/12 format). Both columns values come from formulas.
I am trying to copy cells E & F to columns K & L starting in row 2 only if there is is data in column E (one of the 11 words) and skipping all others rows. Both the E & F values of tthe row must be copied together, i.e if text is in E45, then copy E45 and F45 into column K and L starting with K2 & L2. This is a task which will be repeated multiple times as data is replaced in columns A-D.
I am creating a training document for work; the sheet I'm creating is a summary sheet which works out how many people answered questions correctly, incorrectly (bringing in from another sheet), number of questions answered and percentage of correct answers.
Looks like: Correct: =COUNTIF(sheet1!E2:E36,"correct") Incorrect: =COUNTIF(sheet1!E2:E36,"incorrect") Number of questions answered: =SUM(C4+C5) (correct+incorrect) Percentage right: =SUM(C4/C6) (correct/number answered)
I need to drag these 4 formulas down into another 400+rows, however in the correct and incorrect formulas I need it to keep the 2:36 but change the e to f, g, h, etc.
I need the Row values to change, not the "array formula parts" (because I don't know what they really are called). So, as I copy down I need the new formula to read:
I'm working on a spreadsheet that tracks project accepted and done over a course of time. I am expecting the data to eventually reach the thousands in a year's time. I have several formulas in specific columns that I need to replicate as the user enters new data into the next row.
While it is easy to copy paste the formulas from the cells above, we are looking to save time by having the sheet do this automatically which also prevents the user from accidentally deleting/modifying the said formulas. I am also looking to save file size which is why I am considering doing this in VB. An example of a formula that I need to move down into the next column is:
So I have a spreadsheet that has a Title in Cell A1, then entries in B1, D1, F1, H1, J1, etc... with empty cells between.
What I would like to do is copy those entries to the right, i.e. B1 into C1, D1 into E1, F1 into H1, but all the way along because in my master sheet there are a lot of columns.
In the first column name of the month is specified.And in the third column of the same row day is specified.And followed by some data in rest of the columns and rows.
I need to copy the data from the presant sheet to a new sheet based on some conditions.
first need to search for the row where the word "MONTH" is there.if it is found then in the same row third column need to be checked for the day like "MONDAY" or "TUESDAY".If it is monday then need to copy 6*8 array of data i.e. (6 rows and 8 columns) into a sheet "MONDAY".if it is TUESDAY then 5*8 array data into a new sheet TUESDAY.And the search should be continued till the end of sheet.
I have a name in cell A1 and a number of 20 in cell B1. Is there a function to copy the name in cell A1 the number in cell B1 (20 in this case) times into column C?
