Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help to copy notes from 1 sheet to another
I have 2 sheets in 1 excel file 500 rows need to make it so that if
Sheet1:ColB is the same as Sheet2:Colb then the Notes in Columc:Sheet2 are displayed in sheet1ColumC note that in most cases the infomation in Colb wont be in the same order etc. and also a few records missing if this is the case i would like it to be blank. Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help to copy notes from 1 sheet to another
In Sheet1 C1 enter the formula and copy that down
=IF(ISERROR(MATCH(B1,Sheet2!B:B,0)),"",INDEX(Sheet 2!C:C,MATCH(B1,Sheet2!B:B,0),0)) If this post helps click Yes --------------- Jacob Skaria "Mrbanner" wrote: I have 2 sheets in 1 excel file 500 rows need to make it so that if Sheet1:ColB is the same as Sheet2:Colb then the Notes in Columc:Sheet2 are displayed in sheet1ColumC note that in most cases the infomation in Colb wont be in the same order etc. and also a few records missing if this is the case i would like it to be blank. Cheers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help to copy notes from 1 sheet to another
Fire this macro while in sheet 1
Sub matchiteminothersheet() On Error Resume Next For i = 1 To Cells(Rows.Count, "b").End(xlUp).Row Set x = Sheets("sheet2").Columns("b").Find(Cells(i, "b"), _ LookIn:=xlValues, LookAt:=xlWhole, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) If Not x Is Nothing Then Cells(i, "c") = "Match" Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Mrbanner" wrote in message ... I have 2 sheets in 1 excel file 500 rows need to make it so that if Sheet1:ColB is the same as Sheet2:Colb then the Notes in Columc:Sheet2 are displayed in sheet1ColumC note that in most cases the infomation in Colb wont be in the same order etc. and also a few records missing if this is the case i would like it to be blank. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lotus Notes - Unable to Copy Paste Special in macro | Excel Worksheet Functions | |||
?? Email Excel sheet thru Lotus Notes | Excel Discussion (Misc queries) | |||
??email excel sheet w Lotus notes | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Notes move around the sheet | Excel Discussion (Misc queries) |