Sheet1 A1 = Sheet 10 A1

Jun 27, 2007

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 Replies


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

Feb 26, 2009

I 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 Related

Compare Sheet1 With Sheet2 And Copy Unique Values In Sheet1

Aug 13, 2014

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

View 2 Replies View Related

Multiply The Value Of Sheet1 And Sheet 2

Dec 9, 2009

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

View 9 Replies View Related

Remove Pair In Sheet1 If Exist In Sheet 2

Dec 22, 2009

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 ectI 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 Related

Excel 2007 :: Open Sheet Always On Sheet1 A3

Feb 2, 2014

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

View 4 Replies View Related

Copy Row From Sheet1 To Sheet Based On Cell Value

Aug 17, 2006

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 Related

Export 2 Columns Data From 1 To 30 Sheet To One New Excel Or In Different New Sheet1

Aug 29, 2013

How to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet.


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.

View 2 Replies View Related

How Copy The Data From More Cell In Sheet1 To A Row On Sheet2 (others Sheet)

May 19, 2009

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 Related

Excel 2010 :: How To Populate Sheet2 From Sheet1 After Finding Matching Word On Sheet2 From List In Sheet1

Oct 4, 2013

I have 2 Worksheets in an Excel 2010 Workbook -

Column1: contains the word "dog"
Column2: contains the word "bark"

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?

View 4 Replies View Related

Vlookup (look Up Management Teir Information From Sheet1 Onto Main Sheet As Per The File Attached)

Jul 14, 2009

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 Related

Copy The Current Price Back To Sheet1. The Current Price Needs To Be Pasted Back Into Sheet1 (next To The Existing Price)

Jul 24, 2006

All 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,

View 7 Replies View Related

Use Of 'Sheet1.Select'

Apr 25, 2006

I've read on this forum before that it's possible to use expressions such as:


...instead of:


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.

View 3 Replies View Related

Vlookup: Result In Sheet1

Apr 27, 2009

This is the scenario----------------------------

Column A in sheet1

Column A Column B In sheet2
1101 | 14211
1101 | 14541
1101 | 14857....................

View 5 Replies View Related

Spooling Data From Sheet1 To Another

Jul 6, 2014

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‎

View 4 Replies View Related

VBA To Find Value From Sheet1 In Sheet2?

Jul 14, 2014

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

View 2 Replies View Related

Sheet1 & Sheet2 Transfer

Apr 7, 2009

Sheet1 and Sheet2 data transfer between Sheet1,
Sheet2 should be like. macro solution

View 2 Replies View Related

Print Sheet1 From Many Files?

May 10, 2012

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 Related

Use VBA To Activate Sheet1 Of Workbook?

Oct 3, 2013

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

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)

View 3 Replies View Related

Changing Of The Format To The Same As Sheet1

Jun 27, 2007

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

View 9 Replies View Related

Vlookup Formula- (sheet1 & Pak-1)

Mar 21, 2009

i have two sheet (sheet1 & pak-1) like follow.


ITEM #PAK-1DATE PACK PAID BALANCE OPENING BALANCE - 31-Dec-08 483 483 31-Dec-08 500 (17)


ITEM # DATE PAID PAK-1 31-12-2008

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


why it shows the error?

View 11 Replies View Related

How To Select 50 Random Values From Sheet1

Dec 13, 2013

How to copy and paste 50 values randomly from column A in sheet1 to Column A in sheet2.

View 5 Replies View Related

Use Macro Hotkey For Sheet3 While On Sheet1

Jul 2, 2013

I 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

View 3 Replies View Related

How To Transfer Certain Cells From Sheet1 To Sheet2

Dec 15, 2013

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

View 7 Replies View Related

Select A Range On Sheet1 Using Mouse?

Mar 28, 2014

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

View 14 Replies View Related

Check If Sheet1 Has Any Conditional Formatting On It Via VBA?

Jul 18, 2014

How can I check if Sheet1 has any conditional formatting on it via VBA?

View 11 Replies View Related

Stop Macro Functioning On Sheet1

Dec 16, 2008

how 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 Related

Dde Data Copied From Sheet1 To Sheet2

Aug 28, 2009

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

View 11 Replies View Related

Find A Value On Sheet1 And Input It On Sheet2

Nov 27, 2007

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.

View 9 Replies View Related

VBA Automatically Generate Next Number Onto Sheet1

Aug 3, 2007

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,


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?

View 4 Replies View Related

Copyrights 2005-15, All rights reserved