#excel #expert

WE NEED DATA TRANSFER TO TABLE AND EASY DATA ENTRY ........... SO I WAS FAILLED... I Don't know how to write vba coding As per my Question DATA Range : J7:MJ Table Range : C7:C24

Ólá pessoal, preciso tanto de uma ajuda . Tabalho com planilha online, porem do nada todas as pessoas que acessam minhas planilhas elas parecem como se tivessem em uma linguagem diferente, eu já fiz todo tipo de ajuste de indioma, porem sem sucesso. preciso tanto de socorro nesse assunto...

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink) This Invoice Product name Combo box with show Hyper link button appears Out side the combo box, how to possible pleased Need this vba code , (Condition : How to fix same place in range...

Hi. I have data in multiple workbooks in a folder with the same template and I need to extract those circled data into one master workbook as below I have a code to loop thru all the workbooks in the folder but I do not know how to do the data copying/extracting. Thank you for any help!. Sub...

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

how to Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result - I was try but i was failed matching Product list with Category Kindly Need formula this Query K3 =SUMIF(A:A,I3,C:C) L3 =SUMIF(E:E,I3,G:G) M3 =K3-L3

Hello, I am trying to make a formula that can detect consecutive duplicate values in excel. Once this is detected I want it to only return the lowest value for "LOW" and highest values for "HIGH". Any way this is possible to do with helper colums and formulas? In the data below I have shown...