lines

I've been working for months and months on a complex workbook designed for use by many different people in many locations within a large organization. Thanks to all of those whom helped me over the many hurdles I encountered! I know that there are 29 user forms and 14 modules (that's obvious)...

Hi, I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.

I have an address that is in one cell formatted with: Name address address2 city state zip There is a hard tab (alt tenter) between the lines after the first line. (the bolded lines) I need to keep everything in one cell, and add five spaces in front of each line. I need to be able to do this...

https://imgur.com/gYDlsNh Hi, I have a big excel list with over 2000 lines I would like that whenever a line's value is zero ("Final Cost column") to divide the number from above that is not zero by the number of duplicates ("Extra line count in my case").

I have some lines in a text file. the lines were written in a way such that the last line is added at the bottom. i have a listbox that i want it to read the lines in the text file in a reverse order i.e from the last line to the first line

I would like a formula that I could lookup and return the latest date. There will be multiple matches, but only want the max one returned. I will have to do this for multiple lines and I have been unable to get Array formula's to work previously

For this little guy: =SUM($A$2:INDEX(A:A,ROWS(A:A))<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">) The only reason a simple =SUM(A2:A10000000000000) won't work is because too many lines are getting deleted with each update, and I'm trying to avoid having to check if...

I have 8 years of daily stock data that includes a line for the daily stock price and 2 moving average lines and it's getting harder and harder to differentiate between the lines at the current data point because of how compressed the chart is getting. Is there a way to make the last 30 days of...

Hi all, I am working on a new sheet combining multiple tables from one sheet into 1 long list. Only the length of the tables can be variable and dynamic. Currently, I made a work around to code lines in use and empty/last lines. Below is an example of the coded lines I already made...

I'm look for VBA code to change the font size in a cell based on the number of lines in another cell. I use the following formula to find out the number of lines in the other cell: =LEN(InfoEntry!$B$14)-LEN(SUBSTITUTE(InfoEntry!$B$14,CHAR(10),""))+1 If the result of this formula is "8" lines...

Dears, I would like to kidly ask you for your help/advise regards vba code. I need to split multiple lines filled in text box to separate lines in excel. See attached picture, Assume it will be clear for what I'm looking for. btw...I'm vba beginer, so please be patient :D

Good evening, There are occasions when I am presented with line level detail and need to sum related lines into a single transaction. At the moment I sort and subtotal related lines and copy detail from the cells above into subtotal lines. This be as follows: Date Unique Reference Line...

Hello all, New poster but long time reader. I have an Excel 2010 spreadsheet that i am trying to create a VBA code to do some specific things. I am not totally familiar with VBA but do know enough to be dangerous. Scenario: Sheet 1 has a cell (say C3) that has a number that can be typed in...

I have an invoice spreadsheet that needs the ability to write notes at the bottom. I want to lock the spreadsheet but there are a few requirements I need with a text box: The main one is that I need to lock the sheet and keep writing in it I need the text box to expand as you write more lines...

Hello, I have directory with multiple excel files and I need to pull the first 5 lines of only the first file in the directory into a new sheet. Can anyone help? Thanks in advance!

My first post here... please be gentle So I have a very, very large data set that I have distilled down to a table of 500 lines, summarized according to some COUNTIFS statements. Now what I need is the geometric mean of the totals. For example, in the first row I have pasted below, I know I...

Hello I have mutlipe business lines each with many products listed with revenue show next to them. I want to vlookup from another cell/different tab all business lines and then capture and seum all monthly revenue into a single sell. Identify all the matchting rows: <tbody> Business 2...

Hi all. I am new to excel VBA and I am trying to create a module that will concatenate multiple lines. Here is an example of data from the excel workbook: Once the macro is executed, I would like the result to look like this: Any information would greatly appreciated. Thank you in...

Hi I am having trouble getting this simple task completed. I want to retrieve the lines from the dataset which match the criteria in the criteria range as there's more than one criteria, the lines retrieved must match just one of the criteria to appear in the result. The formula I am having...

Thanks to all who attempt to assist. Will give feedback on solutions. Why I am I getting a "Run-time error '1004'. Application-defined or object-defined error on the following line: Sheets("Template.Line.Item.Data").Range(Cells(2, 13) & Cells(LastRow, i)).Formula = _...