im trying to do is when i put an input in sheet 10 a1 i want sheet 1 a1 to equal it.they are both formated the same with formulas and column widths.ive tried making it equal A1:p7 but it just shows a1.
View 9 RepliesI have I workbook that contains 2 sheets. The first sheet "Business Objects" is the master list. The second sheet "Gene" contains similar data but is incomplete. There is a unique identifer for both sheets and that is item ID. what I would like to do is look at the Item ID column on sheet1 compare it to SS# on sheet two and copy any rows from sheet1 to the end of the sheet in sheet 2. I have found in my searches on this forum a bit of code that identifies the ones in sheet1 that are not in Sheet2 and highlights them red(which is not neccessary for me, but I am struggling to figure out how to take that and paste it to sheet2.
View 3 Replies View RelatedI am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.
[Code] .....
I have 3 sheet.
i need to multiply the value sheet 1 and sheet 2.
Sheet1 AB1NameAmount2Kumar1003Siva2004Sasi3005kannan400 Excel tables to the web >> Excel Jeanie HTML 4
Sheet2 ABC1Name MonthComments2kannan5good customer3Kumar10average customer4Siva20ok5Sasi25not bad Excel tables to the web >> Excel Jeanie HTML 4
The answer should be like this
Sheet3 ABC1NameAmountComments2Kumar1000average customer3Siva4000ok4Sasi7500not bad5kannan2000good customer Excel tables to the web >> Excel Jeanie HTML 4
I have two sheets of data: sheet1 and sheet2. Data in sheet 1 and sheet 2 are in pair, ex: row1 and row2 is 1 pair, row 3 and row 4 is one pair ect…I need a program that start from each pair in sheet1 and search for it in sheet2, if that pair already exist somewhere in sheet2, then cut that pair from sheet1 and paste it into sheet3.
View 12 Replies View RelatedAm using a VB for auto transpose values to sheet 2 from sheet 1 in MS EXCEL 2007.
What code to add to the already existing VB so that if someone is using the sheet and leaving the cell in E12, for example, and saving it, then the next user should find it again on A3 but not on E12.
The sheet should always open on A3..
i'm trying do is have information from sheet1 copy to sheet2 upon selecting a value from a DV list. Based on my attached sample, in Column J, upon selected "Yes", I would like to get the information from A6:H6 copied to sheet2 in the same row. I've tried it with the "if" formula and writing a macro for it.
View 3 Replies View RelatedHow to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet.
E.g
Name project target ,weekly %, and monthly percent% ,present, absent are there in all sheet but i want to export only Name and monthly percentage to different excel or different sheet in same excel.
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 2 Worksheets in an Excel 2010 Workbook -
Sheet1
Column1: contains the word "dog"
Column2: contains the word "bark"
Sheet2
Column1: contains the sentence "I like dogs a lot."
Column2: is blank
What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.
How can I do this?
I'm having trouble to get VLOOKUP to work. Basically I need to look up Management Teir information from Sheet1 onto Main sheet as per the file attached. Both RecordID columns are Text so they should work right? But VLOOKUP returns #NA error.
View 4 Replies View RelatedAll data is located within one book. I have two sheets with material codes in each sheet which include pricing (existing and current)
Sheet1 (has existing material codes plus existing pricing) Has about 1200 lines
Sheet2 (has current material codes plus current pricing), has about 36000 lines
I need to cross check if the material code (taken from sheet1) are still available in sheet2, and if they are, copy the current price back to sheet1. The current price needs to be pasted back into sheet1 (next to the existing price). If the material code doesn't exist (for whatever reason, in sheet2), the program needs to move onto the next line and leave the current price for that material code blank. The program should finish once all the lines in sheet1 are completed. I have attached a sample of what I'm trying to do,
I've read on this forum before that it's possible to use expressions such as:
Sheet1.Select
...instead of:
Sheets("Sheet1").Select
The first of these has the advantage in that it is independent of the name of the sheet. It simply refers to the first sheet created in that workbook and, if deleted, it cannot be recreated. However, I seem to encounter errors whenever I try and use this approach.
This is the scenario----------------------------
Column A in sheet1
1101
1201
1301
1401
1501
1601
Column A Column B In sheet2
1101 | 14211
1101 | 14541
1101 | 14857....................
I need to spool data from Sheet1 (Data) such that when the pins are pasted into the combo box and button is clicked it brings up the corresponding reasons and comments for each pin
I have attached a doc. pinpopulate.xlsx‎
I want to find a value from Sheet1 in Sheet2. The code below has worked in the past, but this time Sheet2 has the value as a result of a function and it doesn't seem to recognize it. What do I need to change to make it work?
Sheet1 - the value is a number that has been typed in
Sheet2 - the number is the result of a function
[Code] .....
Sheet1 and Sheet2 data transfer between Sheet1,
Sheet2 should be like. macro solution
I have 11,000 excel files in a folder "INV" on my desktop. Each file has six sheets that are used. I need to print "Sheet1" from each file.
View 1 Replies View RelatedHow do I use VBA to Activate Sheet1 of a workbook? I am using the following to go BACK a sheet, but really need to get to the first sheet in the workbook.
Code:
Sheets(Sheets.Count - 1).Select
If it's a new wb, then it's tab is called Sheet1.If it's an existing wb, and it only has 1 sheet, then I need that one (in case someone has added a sheet and deleted Sheet1)
changing the format of sheet2 to exactly like the following image below.
*there are some codes in sheet2 which I think is the place to change the format.
Private Sub Worksheet_Activate()
Dim myDate As Date, mySize As Long, n As Long
With Sheets("Sheet1")
If Not IsDate(. Range("a2").Value) Or Int(Val(.Range("a4").Value)) < 1 Then Exit Sub
myDate = .Range("a2").Value: mySize = Int(.Range("a4").Value)
End With
i have two sheet (sheet1 & pak-1) like follow.
PAK-1
ITEM #PAK-1DATE PACK PAID BALANCE OPENING BALANCE - 31-Dec-08 483 483 31-Dec-08 500 (17)
Sheet1
ITEM # DATE PAID PAK-1 31-12-2008
#N/A
in sheet1 i want when i write date in the date column it should should show the paid amount for this i am using the following formula
=VLOOKUP($B$2,'PAK-1'!$A$5:$Z$1048576,3,FALSE)
why it shows the error?
How to copy and paste 50 values randomly from column A in sheet1 to Column A in sheet2.
View 5 Replies View RelatedI try
With Sheet3
'Sub TF()
Dim i As Long
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Cells(i, 1).Value = 1 And UCase(Cells(i, 2)) = "Y" Then
Range("F1").Value = "GREEN"
End If: Next: End Sub
End With
To allow me to push my macro hotkey while im on sheet1 and have it run the macro thats on sheet3 but it does not work
I am trying to do some kind of sorting?
if the first character of the cell is number or * then copy that cell(row i ) and the cell above(row i -1) to sheet2. I am not sure how to check the first character is *.
The idea is this:
[Code]] .....
when i select a range on sheet1 using mouse e.g i select the range ( d5:d16 )
this range (d5:d16) should be appear In texbox1 and press any key to lock this range in textbox1
How can I check if Sheet1 has any conditional formatting on it via VBA?
View 11 Replies View Relatedhow to stop macros running on a particular worksheet within a workbook. I have a workbook monitoring vehicle faults with a control sheet. The control sheet displays the reg no and a "traffic light" indicator highlighting faults next to the reg no. Traffic light is turned red and green by If blank control. Each vehicle has a worksheet where faults can be recorded and a menu bar at the bottom of the screen operates numerous macros to "email worksheet"-"clear and copy to history" etc etc. The menu bar though can also be viewed and operated while in the control sheet. If a macro is activated within the control sheet it destroys it as it was not designed the same as the worksheets. Can I programme the menu to be inactive when in the control sheet OR that the menu will only appear when in every other sheet.
View 3 Replies View RelatedI am enlcosing a file that I partially acquired (the macro portion) and I am trying to add to that.
The workbook has a dde link in sheet 1, the macro will write the data to sheet2 at set times. I am creating a report of the data in sheet 2 in sheet3. at this point it is very rudimentary. I need some assistance to clean up the macro and the post of the dat in sheet2. I have created a detailed (probably over detailed) explanantion in sheet 1 in a text box.
If I have 2 sheets names 'User Info' and 'Labels' what i'm looking to do is on the 'Labels' sheet under cell J2 to be able to enter a number, 505 in this case which searches for this number under column B of sheet 'User Info' finds it, looks to the entry in column D (the name Ken) and in turn puts the name into cell J2 in sheet 'Labels'.
The real life use for this is to search a phone extension number in User Info sheet, and use the user name at that extension number and place it in a label on the Label sheet for a reception phone. The Reception phone can have multiple extensions on it made up of any 3 digit number on any where from 3 keys to 12+. So the ability to search for 100-999 is needed.
In column A on sheet1 I have a list of unique numbers . On sheet2 I have a list of unique numbers that are available. I am currently using this formula,
=INDEX(Sheet2!A:A,MATCH(TRUE,INDEX(Sheet2!A:A"",0,1),0),1)
to look at sheet2 and tell me what number is next after I copy it to sheet1. My problem is how do I automatically generate the next number onto sheet1(by double clicking) and have that number removed from sheet2?