#excel #formula #confused

how to generate Next invoice number After search table1 in excel ? Dear Sir, pleased Solve My Query We need formula For increase invoice number......

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

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

When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table

Option Explicit Private Sub cmdSave_Click() Dim LR As Integer, Master As Worksheets Set Master = ThisWorkbook.Worksheets("Master") LR = Master.Cells(Rows.Count, "A").End(xlUp).Row If LR = 2 And Cells(LR, "A").Value = "" Then LR = LR Else LR = LR + 1 End If Master.Cells(LR...

@how can I show a icon in Excel when I click on a Description column (Range (A15:A30) , if i will click after open Userform ? Icon Move After cell Selection. kindly Need VBA Coding

@ 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

=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,"")) I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result... Get pivot data using "SUMIFS" FORMULA for Stock management. HELP ...

Hi, the current formula is asking Excel to search $B$2 (single cell), is there a way to make it search in a range (search in any active cell in the range)? For example if I type anywhere in $B$2:$B$10, I get the result in $C2 down I tried...

Hi, this what I have got so far, I get it to stacked but it won't ignore blank (it is showing 0), I need it for older version, any suggestion please? Thank you!

Hi, I achieved the result I wanted (below at G4:G5) which is getting multiple returns from multiple conditions using FILTER function. However, I have to hard time trying to change this formula (to achieve the same result) into something that would also work on the older version too. I try a...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

Hello, new here and I hope someone can help. Not sure if what I need excel to do is just to complex or it is just me. I have a huge excel sheet with 20 plus pages that I am creating for my work, where I'm stuck is with items that have varied weights or amounts. I have a sheet that shows what the...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

(1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...

WE NEED SUMIFS FORMULA AS PER QUERY...... NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS