excell

I had excell 2007 and i upgrade to 2016. everything was working fine with 2007 and also excell 365 i have this nesting and how i can change to be able to used with excell 2016 =(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE...

I need some help writing a macro that will combine duplicate entries and delete out one of the entries. Please see table below: In below table I would like to combine the two entries for 123 on one row displaying all three reasons. I have a lot of data, so it would need to be a macro. Any help...

Hi all, I am not quite new to VBA in a practical sense. I have been working on this macro today but I cant seem to get it to paste for some reason, It was intended to open hyperlinked documents from a excel file, within this document is a word table, from which I run a macro to copy the...

I am wondering if there is a way to insert multiple blank rows in between my occupied cells which are individual interest rate scenarios broken down by 12 months for 30 years. In one place I need to add 348 blank rows and in other places on my worksheet I need to add 240 blank rows four times...

Hi I need some information how to do pzn and atc in excell sheet please can anyone help me

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

I have a sheet where I want to calculate a price in a range of cells (i18:i26) when a percentage value is entered in range (b18:b26). If the user then wishes to input a price in range (i18:i26) I want the value of the cell in column b of the same row to change to zero. The code below...

I am having trouble coming up with a formula that I need, I'm seeking help to see if one of you guys at help me with. I have attached a screen shot of the table and the "worded" formula. http://img.photobucket.com/albums/v332/andy0o0o/IMG_5118.gif in another sheet I want to pick up the data...

Hi, This may have been answered before. I am looking to develop a excel system where I can enter the customers name and information on the first tab along with their sale item and then this information will feed through to a new tab based on the customers name. If i had the below list...

Hi i was hoping you could help, this is what i have: <tbody> 1 2 3 4 5 a b c d e f g 9 </tbody> and this is what i want: <tbody> 1 2 3 4 5 a b c d e f g 9 </tbody>

I'm trying to create a grade tracker (pictured below) , and I have 2 questions regarding that. (note that I am a complete excel newbie, so please thoroughly explain each step to solve these problems, if possible.) 1. how do I leave the cells in column "Grade"(F8-F14) that have "0%" in them...

I am having trouble getting my IF, IFERROR,IFNA statements to not populate #N/A or #Value Here is my current Formula =IF(B2="Employee",ABS(F2-M2),IF(B2<>"Employee",ABS(N2-M2))) the issue i am having is that some of the M and N columns don't have dates. so i am getting #Value populated...

I am trying to join cells in a row if a value exists in a cell in that row. The data has been imported from a .txt file and various sub headers are split along 2, 3 or 4 columns. The cells cant be merged as the data will only be kept from the first cell. The only words which are always...

hello I create a ribbon width UI Editor. Have groups an buttons. Then when you mouse on a button, appears ahelp messge (press f1 to...). How can prevent thats messages. This is my thirdth ribbon, and the first time thats messages appears.

Hi all, I have got a B sheet in excell in which customers pay us every month a certain amount. I update this accordingly on every row in Collumn F. (like a bank statement) I have already set a forumula that recognises the credit or debit, so it automaticcaly updates this on Collumn F which...

Hi I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all. So if I have a 1 in Type Specific and Land Reg columns then on the same row under...

I need values not formulas from source. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim rmonitor As Range Dim rTarget As Range Set rmonitor = Range("B1:o1554") Set rTarget = ThisWorkbook.Sheets("DATA BASE").Range("x1:ak1554") If Not Intersect(Target...

Hi there, Have a workbook and first worksheet name is summary and have 31 more worksheets and each one named as days of the month (01.11.2015). On summary page i wanted to use a sumifs function (C1) which checks the date (in B1) to find worksheet name and on that specific page get a sum of...

Hi I have tried lots of diffferent variations but I can not make it work. I would really appreciate if someone could help me with my macro. I have a spreadsheet where people will populate some of the cells in column J. Then based on input in column J I want the fields in column K to become...

Hello, I have several countifs functions looking at the same data in order to pull totals. The first equation: =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Plastic") Gives me the total of 1000. =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Glass") Gives me the total of 43. The function...