final

Hi all, I copy dates from another sheet and paste in column, K and then format as 30-Sep-17. I need to add [.C01709503.BIL] . to the date,. without brackets. The addition will always be the same all the way. Or in anther way, I am combining two columns, date and AFE (C01709503) adding .BIL at...

Hi I may have done this by accident so I think it can be done, but now I am trying to do it again I can't! I have a master list/register which I want advance filter to produce certain records onto another sheet. That sheet then has an additional 2 fields (columns) per row where the user adds...

29=11 I can get by using in B1 formula =SUM(VALUE(MID(A1,ROW($I$1:OFFSET($I$1,LEN(A1)-1,0)),1))) and then again using in C1 =SUM(VALUE(MID(B1,ROW($I$1:OFFSET($I$1,LEN(B1)-1,0)),1))) I get final 2 How I can get that "2" in one single formula,please.

Hi all, I'm something of an Excel neophyte, and while I've mostly been able to cobble together some clunky algorithms to do what I need, I'm stuck on one point which has a few more variables than I can sort through, and have come up dry after scouring the internet. Basically, I'm preparing a...

Hi, I feel like this should be really easy with an if statement and a concatenate but the max on the date is throwing me off. I'm looking to add a formula to column F that determines the line is "LIVE" or "INACTIVE" So If "Customer & Code & Product & Status" appear in the list of data...

Greetings, I am receiving an object required error on the following line: COM.Worksheets(AC).Range(Cells(j, Column.End(xlToRight) + 1)).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Other applicable lines include the following: AC = ws.Name Dim AC...

Hi, I have values in column listed as following. Is there any way to find if any value in column going less then the permissible limit? For example: I have a column A Which have variable data when making any changes effects values in column B I want to set the constraint such that if column...

I want to create a macro and I would like to: be able to open an invoice, hit my macro to lookup the item numbers in column A and search a different workbook called "Final" on my desktop (C:\Users\Glen\Desktop) for the same item number in column A. When found I want to take the corresponding...

Greetings, All! I am new to this forum and will appreciate any advice/ help :) I have a spreadsheet that consists of a few worksheets. The first couple of worksheets have data manually inputted in them. The last and final worksheet has cumulative data from all preceding worksheets. How can I add...

Apologies if this has been answered before, I can find similar topics but not an exact solution I need to create a .csv file from data in an excel worksheet for use in another application. When the csv file is created there is always a final carriage return / blank line which requires manually...

Hello! New user here! I've been trying to figure out for a day and can't seem to find any help on any thread for this, so I decided to post a new one. Below is the sample database for my problem. The final goal is to have a cell that returns the number of times a unique brand (Column A with no...

Hi everyone. I deal with a sheet that adds a column each day. I am trying to write a macro that copies and pastes the last column on a different tab. I have struggled with this for a few hours. The macro I have simply selects the row, not the final column. Any help would be fantastic! Here...

I have a total of 3 worksheets. Two of the 3 consist of a rank from an average of 3 rankers (JS, JJ and SB). On the FINAL worksheet I'm trying to consolidate the information from the previous 2 worksheets and rank (from lowest to highest) from their averages. I have the formula on the FINAL...

Hello, I have a total of 3 worksheets. On the first two, I have a formula to rank the averages of each player. And, I have created a FINAL worksheet to include player's rank and at the same time I want them to sort (lowest to highest) from their average on the previous 2 sheets. I have attached...

I have a workbook that is titled "Results". It has 2 columns that I need help with, a 'status' column (B) and a 'finalized date' column (C) Column B is the 'status' column: Formula: ('[May Database]Summary'!$B$1) The May Database B1 column is a dropdown with options "In Progress" and...

I need to remove the last character in a cell, which is always a "?" - the single words in each cell will have varying lengths, and can commence with a upper or lower case letter, and will contain any of the 26 letters of the alphabet, which could also include a hyphen, e.g. "day-dream?" should...

Hi all. Could somebody please shed some light on the reason office engineers made it available for users to choose to still edit cells after marking a workbook final?? What's the point of that?? And how do I prevent them from doing it? Thanks in advance

Hi, I am using xl2010 and xl2003. In VBA I am trying to extract the final row from a Range. e.g. if my range variable is A1:B42 I would like to extract 42. I could have something like: Dim rngTest as Range Set rngTest = Range("A1:B42") rngTest.cells(1,1).end(xldown).row However xl...

Hi, I have a string of information in a field and I want to extract the last word into another cell. The values in the field are separated by spaces, so to extract the first bit of info I am using FIND to locate the first space then using LEFT with the result of the FIND-1. So this is simple...