net

All hi, i am kindly require to provide me a VBA code so that to run through col. "A" and where find the description "NET COST OF SALES/(FOOD)" twice, should delete once entire row but the second one. I present below original data and expected result. Thank you all in advance Original Data...

Hi Does anyone know how i can return multiple column using VLOOKUP in a new workbook? I have tried this off the net but it won't work. =VLOOKUP(A3,[Parks and Leisure Sites.xlsx]Sheet1'!$A:$F,{2,3,4,5},FALSE) Thanks Ernie

Someone please solve this equation. I have a markup equation that I fill down. I'm trying to net no less that 5.00 but I have products with a wide range of total cost. Price = Total cost + Markup percentage. Net = Price - Total cost. That part works great. The following is what i'm trying...

Hi I am trying to create a pivot table based on this <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> No. Invoice Date Company Net Amount (£) Infrastructure M&S/Aldi/Retail Safeline </tbody>...

Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...

I would like to add a formula to this cell (B53) to replace the two occurrences of the word "Dale". The cell currently contains approximately 822 characters. Excel limits the text within a formula to 255 characters. I understand that the CONCAT functions allows for putting text strings...

Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...

Cell C1 has the name 'Bob' in it and cell D1 has the name 'Sue' in it (without quotes). The formula below is returning 'Bob combined net income (before retirement)' just as it should and if C1 is blank, it is returning 'Name & Spouse/Partner combined net income (before retirement)'. This is...

Hello, I have a spreadsheet in which is added data in 2 columns each month at the end of the sheet, called "NET" and "VAT". I am trying to write a formula that sums entries from last 12 columns "NET" (one formula for last 12 "NET" columns, f.e AK, AI, AG, AE etc) and "VAT" (another formula for...

Hi! I need to run a macro that a message box will appear when the value in multiple cells is not equal to zero. I have this right now, but I need the Range to be 4 different cells and not juxt the one! Can you help?? Private Sub Worksheet_Change(ByVal Target As Range) Dim x As StringOn Error...

Using " as a string is not as easy as I thought and I couldn't find any relevant informations on the net. Thank you very much fow your help!

Hi All, I am tracking movement of members between categories, "Affiliate", "Fellow" etc. Members can move both ways between these categories, e.g. from Affiliate to Fellow, and from Fellow to Affiliate. (Note, if that sounds odd, its just an illustration). Does anyone have any ideas on how I...

Attempting to calculate the available annual man hours per production worker based on their years of service. Their annual leave both vacation and sick are based on their years on board. Knowing this I can then calculate what their true production man-hours per year are. Having trouble...

I would like to create an audit report showing dates when values were changed and what those values were changed to, but only one row for each date the value changed. We modify payment terms for our vendors and the payment terms show up on the purchase orders (PO). So if we change payment...

HI i am very new to VBA, I have been working on them but mainly finding them on the net and then pasting and adjusting them to suit. i require help to work out how to delete a row if in column N the time is less than 30mins. Also to note when I paste the data into the excel sheet it is in text...

<tbody> Area Price Discount 1 Discount2 Net price A 100 20.5 3.78 79.5 B 100 15.7 2.95 84.3 C 100 11.3 1.87 88.7 A 20.5% 4.75% B 15.7% 3.5% C 11.3% 2.105% </tbody> Please help to make single formula in Net price column for example in E2...

Found this wonderful example of Net work hours between dates. I need to now know now how I can modify this formula to allow me to add a set time value of say 7 hrs to cell a6 so I get result 25/02/2019 07:00 etc etc. Hope that makes sense. B2 = 2pm A2 = 6am A6 =...

Hi I would like my macro to do the following: Go through each worksheet in a workbook Find a cell value that is in all worksheets Copy the cell that is two cells to the right Paste values into a Worksheet called “Daily Net Movement” However the error I receive...

Hi there. I have the following code, looking for all text to the left of "Gross". Is there a way to update this to show text to the left of either "Gross" or "Net"? Thank you =TRIM(LEFT(A2,MIN(FIND({"GROSS"},A2&"GROSS"))-1))

Hi, My first post and I would request the esteemed members to provide me with a basic Salary Sheet in Excel for my salary calculation purposes. I run a Take-away, online ordering and delivery ******* and my basic requirements for salary calculations are:- 1) CTC 2) Number of days absent. (To...