data2

Hello and good weekend to all, Would like a result set of Name1, Data1 and Data2 when the name in col Name1 matches the name in col Name2, is that done in vba or in which area; Name1 Name2 Data1 Data2 Al Bain Win Vung Al@test.com 800-777-7777 Sue Reed Al Bain

Hi all, couldn't find an answer to my specific question so I'm hoping some one can assist. I have a range of data in Sheet1 from A1:T5000. I have a Named Range called "Doc" which I have created in Sheet2. Here is an example of what Column A looks like in Sheet1: Column A Name1 Data1 Data2...

Hi, I have a macro which creates rows according to a column value cell and transposes the rest of columns; and this works fine. Sub Copydata1() Dim data1 As Variant, data2 As Variant Dim i As Long With Range("A4", Cells(Rows.Count, "A").End(xlUp)) data1 = .Resize(...

hi all, I have a sheet where in every row there are many blank cells and 3 cells have data in them, all in different columns. ie: <tbody> 1 data1 data2 2 data3 data4 3 data5 data6 4 data7 data8 </tbody> I would like to delete all the empty cells...

The following VLOOKUP() works OK - =VLOOKUP(M3,Data1,N4,0), even if the Data1 array is on another sheet However if I want to define the array as either Data1 or Data2 I don't seem to be able do so by referring to cell A3 where the A3 cell contains either Data1 or Data2 as in...

Codes Formula A001,A002 (return 10+20+30=60) B001 (return 40=40) Code Data1 Data2 A001 10 20 A002 30 B001...