data1

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

I have an excel file as the sample file share link . I would like to have a macro for arranging the shee1 to sheet2. Then I want to compare the sheet2 with another workbook named book1 sheet named Data1 for Invoice No, Item Name, and party name. If work book Data1 don't have such records then...

I've a worksheet with data in 2 columns and i need compare then and extract the diferences to another columns. There is a problem because i've repetitions in both columns and my macro doesn't work properly with this. I think i need a new macro to do this. <tbody> Data1 Data2 100 100 100...

Hi, Looking for some assistance. I have the following code that lists all worksheets from an open workbook. Sub ListWS() Dim FolderPath1 As String Dim data1 As Worksheet Set data1 = Worksheets("DATA") FolderPath1 = data1.Cells(5, 3) FileName1 = data1.Cells(4, 3) FileName2 =...

Hi Guys, I have a range of data. I need help writing a VBA code to see if the code column matches more than one name then if it does to only change the value of that code to the ext code. So in this case it will only change Data 2 and data 3 as they both have the same Code numbers. Any...

Hi, I have an 8 column table in access named DATA1 which I pull into Excel based on date. Example (SELECT * from DATA1 where EDAT = " '20181108'") Does anyone know if it's possible with VBA to edit the pulled data and update the access table with new values ? Appreciate any help

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

Hello, In vba, is there a way to use "application.worksheetfunction.min()" to find the minimum of a vector Inside a matrix. Exemple Data(1 to 3, 1 to 20) as variant Inside my Data(1,: ) i have dates. I would like to easily find the minimum date. Thank you!

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

Hello folks, Apologies if this is a obvious issue I'm a beginner at VBA. I have 2 sheets (Data1 & Data2) with tables of information which will vary in size. I'm trying to write macro that will find the table size on "Data1" and paste it into a new sheet "AllData" After that it will find the...

I have a formula which is copying data and repeating it numerous times in column B in a worksheet: =IF(ISBLANK(INDIRECT("Sheet1!B"&ROW(B2))),INDIRECT("Sheet2!B"&(ROWS($B$2:B2)-(COUNTA(Sheet1!B:B)-2))),Sheet1!B2) This formula is achieving part of what I am looking for, but now I need to list...

Hi I need a macro to copy data from one file to another. eg : from Workbook A, Sheet Name : Data1 (Range : Entire Sheet) copy to Workbook B, Sheet Name : Data1 & from Workbook A, Sheet Name : Data2 (Range : Entire Sheet) copy to Workbook B, Sheet Name : Data2 Thanks in advance...

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

Hi Everyone, So I have 4 sheets all the same 1 is Data1 data2 etc. (If we could write this macro to run on all sheets called "Data**" that would be great.) NOw data1 is where the data is entered, So what I need is a macro that if any cell in column C of Data1 is changed it unhide the next...