lines

I have uploaded to my Google Drive an Excel spreadsheet - https://drive.google.com/file/d/1JzPo1MSrQO44SOf1SBR6oRdPs34icPp2/view?usp=sharing There are two tabs, ORIG and DESIRED RESULTS. This is just a subset of a much longer file. The goal is to have all lines with the same address on one...

Hi All I have a register in excel which gets reviewed every 3 months which has 10's of Thousands of lines. What I would like to be able to do in the status column (AH) is trigger a automation, When the status changes to "Remove"it moves it into a different tab called "Removed" in the same...

We are trying to create a single column for double checking commissions pays. All the data is on one worksheet The logic would look something like: 'If there are 1-14 lines with the dates of October, then multiply the value in this cell by .01, and if there are 15-19 lines with the dates of...

Hello, I have an XLS template with text and some fields that I want to update them automatically. Can you tell me please how do click a button and do stuff like: 1) count the number of lines in a sheet apart from the header 2) count the number of lines in a sheet that the field under a...

Hi I hve a cell with as many as 100 lines and which can change depending on user input. I can find how many lines there are using, but I want to separate the lines into different cells. Is a way to separate number of lines just like we use mid, left and right with number of charaters? Thanks

I have tried to post a question with a couple of lines of example, but it only posts the first couple of lines -why?

Hello Everyone, Requesting your help. I have two excel work book named "Inventory.xls" and "Resource.xls". In a resource workbook, I have a set of resources available for the day and everyday the data may be change. In a Inventory workbook, I have a set of datas needs to be worked. I need...

hi i m working on a factory, we have 12 lines and they have different styles. i do their line balancings with manually. i want to see all possible balances with permutations. There are about between 17-35 workers in each lines. And each model have diffirent quantitiy of operations. i know the...

Hello to all. I know that there are lots of info on this but i can´t put it to work, so i ask for help I created a Lisbox1 that populates when i click the search button. Have a Dynamic range for populating ( Workbook \ Formulas \ Name Manager -...

Is it possible to copy lines of data into a new tab based on the contents of the data? In other words, I have a large dataset (updated twice daily) and I want to create tabs such that only lines of data with condition A are copied into the new tab (where I then have a pivot table do analysis on...

hi I was wondering if someone could help I am trying to write a macro to change data in a cell if spacific data is in two other cells I will have various different variations of the data but the basic struture evades me. i hav something along these lines, there is a large sheet of data that had...

Good morning, I have searched the forum for an answer to this question, but although there are some close answers, I can't quite comprehend (VBA novice) how to use the code in my scenario. Using Excel 2016: I have the following whereby the results are feeding from an adjoining sheet. I am...

Hello, i'm trying to align grid lines of 3 separate Excel charts as seen on image (i'm new to charts), representing Actual sale by products and % variance to Plan/Prior Year. Manually i cannot align them to the exact alignment (check the mismatch on last grid lines below): Is it possible to...

Hi All Can anyone point me in the right direction with this one? I am capturing time data in a vba form. The data is being entered as number of hours and to make it easier the number of days is also captured. I am then using add to functionality to post into an upload sheet for a secondary...

Using VLOOKUP in VBA with userform and combobox I get an error (actually two) 1) See error on msgbox 2) on the VLOOKUP lines I get "Compile error Expected: list separator or )" I want to populate fields base on the selection from combobox Code below: Private Sub Combo_WO_ADD_Change() Dim...

Hi, I have been trying to set a grid of 50 cells x 50 cells and use the Shapes.Addline method to draw lines on it using coordinates that relate to that grid. I think I understand the coding but am not clear how Excel decides where to draw the line on my screen. For example if I use...

I am trying to create a formula for a table that contains two street address lines, City, State, Zip. If there is one street address line, I wanted to suppress the Carriage return. If there are two address lines, I wanted to incorporate both lines. I can conceive using the Concatenate and If...

Hi, I use a worksheet that is mostly pics of several hundred small charts and lines with text descriptions of each. It is currently using about 460MB of memory, but the pics will increase as time goes by with updates. Are there any "tricks" I can use to help it run more efficient and use less...

Im having trouble finding the syntax to correctly define a range variable. I am receiving an error on the lower of the two lines. These lines both exist within a with statement. If .Cells(bb, "A").value = sampleVar Then Set TblRng = .Range(Cells(bb, "A"), Cells(bb...

Hello all, I am very new to excel vba and this may look trivial so please bear with me. I have two text files containing numbers each with one column. I need to compare each line in the first file with all the lines in the second file. The files do not contain the same number of lines. If the...