columna

I NEED SUbtotal with countif in Column D2 When i filtered in columnA give me 0 count in cell d2. ColumnA <colgroup><col><col><col></colgroup><tbody> ColumnB ColumnC Silver South-2 3 Silver South-2 3 Silver South-2 3 Silver South-2 0 Silver South-2 3 Silver South-1 3 Silver...

Hello All. I need to complete a price of different articles on a website and they give me the data in Excel. I explain: Every week they send me an Excel with different article prices and I have to update those on the web. The Excel are two columns, one with the ID field and the other with...

Hi! I have 2 worksheets with extensive data from patient registry. What I want to do is go through worksheet2 row by row only in a single column(A). For each cell in every row in that specific column(A) I want to find that cell in worksheet1(which is 100% there, also in first column(A)) and...

I have last name in column A and first name in columnB. I need it to combine together in columnA ColumnA. ColumnB Steve. Smith Will look like Steve, Smith In columnA I need to do it using a vba loop

Hi everyone I am trying to get an Index Match from a table based on alphanumeric values contained in the lookup value. Sheet2 Table1 ColumnA Header[Item] contains the lookup array Sheet2 Table1 ColumnB header[Shape] contains the return value array Sheet1 ColumnA contains the lookup value...

Hi, My first post in this forum. Any help is appreciated. Thanks. What I'm to achieve in ColumnB based on ColumnA: For each ID in ColumnA, create 3 IDs with letters A, R, S appended to the ID. ColumnA ColumnB <colgroup><col><col></colgroup><tbody> ABI117 ABI117A ABI125 ABI117R...

In ColumnA I have sentences wrapped and in columnB list of words formula should lookup range of words in columnA and get 4 words including matched word. for example. Robert is honored in computer science and Robert earned GPA 3.6 and he has a bachelors degree (ColumnA) 3.5 (ColumnB Range) 3.6...

Buenas tardes, Dante Amor: En un libro excel, en el evento Open, tengo el siguiente código: Private Sub Workbook_Open() Dim N As Integer Dim Texto As String On Error GoTo Siguiente For N = 2 To 62 If Cells(N, 9) - Now < Range("R1") Then Texto = Texto & Cells(N, 6) & Chr(13)...

Hi all! I usually lurk in these forums for all my VBA questions. There are several real nuggets of advice and solutions. I am always able to combine code and learn of the solutions offered. However, I can't get the following problem fixed... Basically I got a dynamic amount of columns in one...

En una hoja Excel, llamada "DATOS", en su columna "H" hay una validación de datos con las opciones "Anulada", "En Tramite", "No aceptada", "Pendiente", "Realizada" y "Traspasada"; y en la columna "F" nombres de archivos, en formato word, de modo que si hago clic en cualquiera de ellos se abren...

Hi, I have two sheets named Sheet1,Sheet2. If ColumnA and ColumnC in Sheet1 is exactly matching with ColumnA and ColumnC in Sheet2, copy the entire matching record (A1 to Z1) in sheet2 to sheet3. Please help me with Excel formula/VBA code for this scenario. Regards, Sri

Hola amigos. He buscado en el foro pero no encuentro algo que pueda ayudarme con mi cometido. Me explico: Tengo una macro que despues de filtrar un campo, me selecciona mis datos y los pega en otra hoja (hasta aquí todo bien). Ahora necesito que despues de pegar los valores , agrege en la...