row1

Hello, Please I need your help. I have the link below for my shop workbook "example workbook" that contains a userform to manage my invoices I'm stuck in the following steps and don't know how to solve them, and need your help if you may In TextBox "txtBarCode", If I search for an item by...

Hello, I am looking for a count formula for duplicates. For example: In column A I have invoice numbers: Column A Row1 10001 Row2 10002 Row3 10005 Row4 10001 Row5 10003 Row6 10001 I want to enter a formula in F1 that will take the value in A1 and find how many...

Consider the table below <tbody> COL1 COL2 COL3 COL4 EXPECTED RESULT ROW1 100 200 100 300 COL1, COL3 ROW2 200 100 50 400 COL3 ROW3 100 100 100 100 COL1,COL2,COL3,COL4 ROW4 900 900 900 900 COL1,COL2,COL3,COL4 </tbody> as an example i have added just four rows...

The code below generates what I think are the proper keys and sort code but doesn't work. Any idea why? Sub Data_Sort(SEET, Row_Rng, Col1, _ Optional Col2 = "", _ Optional Col3 = "", _ Optional Col4 = "", _ Optional...

All - seeking your help on this issue. I have a table of values (lets say 5 rows and 3 columns). I have a userform which has 3 textboxes on it. What I want to do is to, turn by turn, display each of the values in each row across the 3 boxes (each textbox would hold a value from each col - so...

Hello I have a question regarding pivot table percentages I have PivotTables similar to the below QTY. % row1. 15. 15.00% row2. 10. 10.00% row3. 75. 75.00% The percentages are set as percentages of grand total, I would like to be able to add...

Hi Everyone, I need a macro that can remove the last 3 characters from every cell in column K that has data in it except row1 please help if you can Thanks Tony