I'm trying to copy one cell data from one sheet to another if it matches a ciritra but need multiplue arugments
i.e
if A1,sheet1 = Yes then I need to copy B1sheet1 into a say,a1sheet2, but if A1 = No then copy b1sheet1 into b1 sheet 2
So copying data from one sheet to another sheet, the if true copy to one cell in that sheet if false copy to another cell in that sheet
Sheet2, Sheet4, Sheet6, Sheet8, Sheet10, Sheet12, Sheet14, Sheet16, Sheet18, Sheet20, Sheet22, Sheet24, Sheet26, Sheet28, Sheet30, Sheet32, Sheet34, Sheet36, Sheet38
If G8 = “E” and if F8 = “H” and E8 is >=10 Copy A8:G8 and paste to sheet tab Sheet40.
If G8 = “E” and if F8 = “E” and E8 is >=1 Copy A8:G8 and paste to sheet tab Sheet40.
If G8 = “E” and if F8 = “L” and E8 is >=20 Copy A8:G8 and paste to sheet tab Sheet40.
When at anytime “D” is in G8, do nothing.
These conditions would be for each row from 8 – 3000 down the page
On Sheet1 I'm attempting to auto populate specific cells in columns B,C & D with information found in Data Validation lists (found on Sheet2) based on the "value" chosen from a list in column A. For instance,
If A2=Pig Then B2=Slop, C2=Pen, D2=Food
Is this best accomplished through VBA or a basic Function?
Ok so i have 2 sheets. Sheet 2 is a form that needs to be printed.sheet one will have data pasted into it by the user. The data will be placed in column a and b. If a has data in it then so will b. Now I need the macro to identify if data is in a then the macro needs to then copy a and paste special into A18 on sheet2 then copy b and paste into A6 on sheet2 then print sheet2. Repeat this process to every row as long as A has data in it.
View 3 Replies View RelatedI have Worksheet 1, with columns A to E. I would like a row to be copied to Worksheet 2, as soon as cell F in Worksheet 1 is populated. Also the row to be deleted from Worksheet 1.
So, as soon as F1 in worksheet 1 is populated and enter button pressed, row A1:F1 will be copied to the next empty row in worksheet 2, while being deleted from worksheet 1. So eventually all rows in worksheet 1 will be deleted and rows in worksheet 2 will be populated.
In sheet "Main" If B7 = ALL to copy the names from range(B8: B34) from the sheet (sheet names are like Oct-2012 Nov-2012 .... Dec-2013) indicated by cell B2 (month) and cell D2 (year), then copy range (C8: Q34) in range (D8: R34) Main sheet.
Ex. If cell B7 is ALL and in B2 is October and in D2 is 2012, then will copy the data from worksheet Oct-2012 specified areas. If B7 is not ALL do not copy any date regardless of month and year of B2 and D2.
If cell A5 contains some data inside it then by using vba code in a button it can copy the data to sheet2 cell E7.
View 1 Replies View RelatedI have the following code in another workbook that is used to populate a cell on the same sheet based on input to cells in column 'A'.
Is it possible to modify this for the attached workbook to select a cell with data (numbers) on the Input Data sheet in column 'E', add text to the beginning, ('CG' in this case), and paste the result to the Import Template in the corresponding cell of column 'A'? I currently have a formula copied to dozens of cells in 'A' but since the number of rows for the Input Template is variable, there are usually cells in 'A' that contain CG but no corresponding data in the rest of the row.
When I enter my sales data into a sheet it can be 10000 rows long, I want to be able to enter a set number of transactions on a second sheet which then uses a formula to look up what items was sold on said transaction.
I'm pretty sure it's possible but I'm out of my depth. I've using something like it before which was this statement - =IF($B1566="","",INDEX('RMS Sales'!P:P,MATCH($C1566,'RMS Sales'!$A:$A,0),1))
I've attached example sheet : For-Excel-Forum.xlsx
I use an excel time sheet for my employees and I am wanting to use a command button to copy data in a cell from worksheet1 to worksheet2. The cell that will be copied from worksheet1 will always be "S14". I want to copy that data to another worksheet and have it paste the data in the correct cell. The code needs to find the employees name in worksheet2 and paste the data in the next blank cell. Currently the command button I have works perfectly but I have to use the specific range, I would rather have the code seek out the employees name on worksheet2 so that I don't have to worry about specific row/column ranges. Is it possible? I'm sure it is. I have attached what worksheet2 looks like.
Rather than having to use .Range("A4:AA4") I would prefer to have the code find the employees name.
Attached file: Book1.xlsx‎
I want entry the data with different row and different cells, so when I click the button, the data on sheet1 is clear and copy to empty row on sheet2 and automatic create a border and automatic insert new row, so we can entry again and next. And I attached my sample Excel File with the description too.
View 10 Replies View RelatedI have a have excel problem Im trying to figure out. I have 2 sheets. Sheet1 and Sheet2. I want to copy into sheet1 cell B2 the contents of sheet2 column C row x iff sheet2 column B row x = 1. There will be only one cell in that column equal to 1, so I will be copying that cells(colB; rowx) adjacent cell (colC;rowx) contents. This is what I have so far but it doesnt work. =IF('Sheet2'!B:B=1,DONTKNOW WHAT TO PUT,""))
View 5 Replies View RelatedI would Need a macro which would Search a Keyword in the excel sheet and copies and pates the data in Cell "A2". for Example "Market" and then after the search it copies 12 rows upwards and 10 columns from the Cell that the word "Market" is placed. And then it copies 12 rows downwards and 10 columns from the Cell that the word "Market" is placed.
I have tried recording the same but it does not work if the Word "Market" is placed in different cell value.
I want to be able to copy a name from one sheet (Available Players), paste it to a cell in another sheet (Round 1 through Round 20). The cell that will be copied is fixed but the place where it will be pasted will be different and may be on a different sheet.
also i would like to change the color of the copied cell to "greyed" out or cut if it can not be greyed out. I have created a button and put in a macro that i created but have been having problems with it, generic 1004 errors that i can not figure out. i am attaching the document.
I am tring to create an excel spreadsheet used to track loan numbers that we will scann to excel, the date it was scanned and then scan the tracking code and place that in a seperate location. I have done some preliminary work but am running into a a few issues. I need to copy the tracking number to each loan number it is relitive for example we would scan 10 files then scan the tracking number and that tracking number would be copied on each line of record. I also need to creadte a code to identify if it is a tracking number not to imput the info in the field.
View 6 Replies View RelatedI have attached a 97-2003 .xls file with data for multiple store locations on sheet 1, and the desired result on sheet 2. I am actually using excel 2007, but I dont think I need any special features that it provides.
I will try to explain the issue here without opening the attachment.
Here is an example of the Data on Sheet1
I am trying to put togther a VBA form button click to do the following: I have several customer names all in master sheet A1 - A300. I want the code to notice that there is a new customer and generate a new sheet, naming the sheet the customers name and copying and paste the entire sheet named 'worksheet' to this newly generated sheet.
View 2 Replies View RelatedI have a master sheet and various other tabs with IF statements where if certain cells on the master sheet contain my predefined criteria they pull over all the data from that line on the master sheet.
Here is the formula:
However data in A is hyperlinked - how can I ensure that carried over to the other tabs as a link?
=IF(AND(Master!$V:$V="January",Master!$U:$U = "Y"),Master!A2, "")
A2 data is a hyperlink
Example, I have a sheet named DATA1, I want to add a new worksheet, copy a certain range from the DATA1 sheet to the new sheet and rename it the same name DATA1 and delete the old DATA1 sheet.
Also, the sheetname will be unknown, the macro must get the sheet name first.
I have a Workbook which I'm trying to apply the following VBA to (the moment Sheet11 is opened):
If Sheets("Sheet11").Range("B8:B372")=Sheets("Sheet8").Range("F1") - Dates
Sheets("Sheet8").Range("L24").Copy - Numbers
Sheets("Sheet11").Range("B8:B372").PasteSpecial PasteValues.Offset(0,1) (paste into relevant cell in Column C)
Else, 0
I would then like the relevant cell in Column D to be activated. IE: Offset(0,2) so the user can then enter their relevant data - more numbers.
update code based on a dynamic range of cells, which worked! I want to drop a csv file into one sheet, and copy the data to another sheet. However, if I drop a new csv file in, and there are fewer rows, the old rows aren't deleted. For example, if my first set of data had 10 rows, and the new has 8, the extra two rows are still there.
[code]
With Sheets("Raw Data")
.Range("A10", .Range("A" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("A12")
.Range("B11", .Range("B" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("B12")
.Range("E11", .Range("E" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("C12")
.Range("F11", .Range("F" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("D12")
.Range("H11", .Range("H" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("E12")
End With
[code]
How to create macros. I need to copy a certain group of cells from one sheet to another, and then do it for x number of times. I'm just using the record function and now i'm lost. Here is the code i currently have:
Sheets("Mapping QTR2").Select
Range("B137:D230").Select
Selection.Copy
Sheets("ExpDB_Q1").Select
[Code] ....
Also, column C is blank. i would like to get the values from another list in the same workbook, say "branch list". I would like to populate Column C with one specific branch for each "batch", if that makes any sense...
i have a workbook that has a lot of sheets but i need to pull information from the one sheet "Veneer Log" i Need it to make new sheets with the same heading as on the "Veneer Log" (Rows 1 & 2) Sheet but it needs to be filtered by the "Product" Column (H) with a new sheet made for all the diffrent products i.e. Dimensional, Drywall, Corners - Thin V., Accents,..... so each product will have a new sheet with i am hoping someone can help me with this. This log changes Daily and it would be nice to have a sheet with only the same product on it to compare new orders so we can batch run. i hope i have given you enough information so someone can help me with this. i have attached a sample log the real log has about 10 worksheet for diffrent departments but i only need info from the Veneer Log Sheet.
View 14 Replies View RelatedI would like a macro that will go to a fixed sheet, copy the format, go back to the previous sheet and paste the format. My problems arise going back to the previously activated sheet rather than just a fixed sheet.
View 2 Replies View RelatedI have a workbook with a hidden sheet ("Template") and a visible sheet("New Job"). I need code so when cell F1 in "New Job" is populated:
1-the sheet is renamed to the value of F1,
2-a new tab is made (a carbon copy of the hidden sheet "Template")
3-the new tab is named "New Tab" and marked as unhidden.
Public Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Name = Range("F1").Value
End Sub
Function WorksheetExists(SheetName As String, _
Optional WhichBook As Workbook) As Boolean
Dim WB As Workbook
Set WB = IIf(WhichBook Is Nothing, ThisWorkbook, WhichBook)
On Error Resume Next
WorksheetExists = CBool(Len(WB.Worksheets(SheetName).Name) > 0)
End Function..................
Is there a vba codes to copy all data from sheet 1 to 5 in workbook to sheet 6 same workbook? and paste it as value.
View 5 Replies View RelatedI am trying to take data from specific cells on PBI_DATA_SORT and paste it into a new line in PBI_DATA_SORT_TRACKING with a date and time stamp in separate cells.
I have been able to get it to copy from one to another but not with a date and time stamp.
Code:
Sub Macro3()
'
' Macro3 Macro
'
Sheets("PBI_DATA_SORT").Range("D139:H139,M139").Copy
[Code]....
What I would like to do is use the IF function to retrieve data from another sheet called Data which has six columns but has various amounts of data that I would also like to pick as a drop-down menu.
The initial cell has a dropdown populated with data using the Data Validation.
Example would be if the following is selected from the initial drop-down menu and then allows me to select data depending on the previous selection.
PX1 - fetch information from Data T2 to T25 and then select that data which then would allow me to select data again from say column U2 to U9.
Is this possible?
I have three IF statements as below. the problem is if the first statement is true I want it to skip the next two statements or the result will be changed again.
View 2 Replies View RelatedSheet one will contain the following:
DATE A B C D E
2/22/2008TRUEFALSEFALSEFALSERon
2/23/2008FALSETRUETRUETRUEPhill
2/24/2008FALSETRUEFALSEFALSETracy
2/25/2008FALSEFALSEFALSEFALSESharon
2/26/2008TRUETRUEFALSETRUEBill
On sheet two I need to list any date that has three or more true statements with the coresponding name.
EXAMPLE:
2/23/2008Phill
2/26/2008 Bill